SQL Server 2008 and Windows Integrated Authentication

Due to UAC, SQL Server Administrator Rights are not inherited from Windows. This results in failure when attempting to log in to SQL Management Studio using Windows Integrated Authentication.

Fix

Click Start, point to All Programs, point to SQL Server 2005, right-click SQL Server Management Studio, and then click Run As Administrator.

Note:
Run as Administrator option elevates the user permissions.
You will see a User Account Control dialog box. You might have to provide the administrator credentials. Click Continue.

1. In SQL Server Management Studio, connect to SQL Server.

To add the Windows user to the sysadmin fixed server role, follow these steps:

2. Click Security.
3. Right-click Logins, and then click New Login.
4. Type the user name in the Login name text box. e.g. DOMAINUSERNAME
5. Click Server Roles.
6. Select the sysadmin check box, and then click OK.