When I had to configure my Product Configuration Wizard
When I had to configure my Product Configuration Wizard
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.