Share via

SharePoint 2010: UAC with SharePoint Product Configuration Wizard

  • Article

When I had to configure my Product Configuration Wizard I could not connect my SQL Database with my SharePoint.

 

 

 

  • I was thinking about permissions, but my user was DBCREATOR and SECURADMIN.
  • I was thinking about DNS record errors, but my NsLookup and ping was ok.
  • I was thinking about ports that are blocked on the firewall, my firewall was disabled.
  • I was thinking, thinking and thinking again.

Is my password correct, is my domain operational, do my user has to be SYSADMIN, My occupation was “BING-ing” but nothing could help me.

I had no choice to start SQL Agent.. SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs. SQL Server Agent uses SQL Server to store job information. Jobs contain one or more job steps. Each step contains its own task, for example, backing up a database. SQL Server Agent can run a job on a schedule

I stared my SQL Agent and I saw a great but nothing saying error: “Login failed for user SPDEV\Administrator'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors.

And there, for the first time in my life BING made a great search operation for me, at the page 14 or like that there was a website who was saying 2 words “UAC” and “SQL CONNECT SP2010”

We have to know what is UAC?  User Account Control (UAC) is a technology and security infrastructure introduced with Microsoft's Windows Vista and Windows Server 2008 operating systems, with a more relaxed version also present in Windows 7 and Windows Server 2008 R2. It aims to improve the security of Microsoft Windows by limiting application software to standard user privileges until an administrator authorizes an increase or elevation. In this way, Blablaaaa Blaa.. (Just watch the image to understand what a UAC is)

  

The reason why I could not connect was UAC. If you have the same issue as me please perform the following:

Try right clicking and running as administrator and seeing if it goes away. Of course if you added your user explicitly you’re probably fine, but just to get a cluster up and running I added my domain admins user to the DB - and of course that’s a membership that UAC will mask.