Login failed for user

I recently installed SQL Server 2008 July CTP, and am not able to login using the Windows account. I left everything as default during installation, set the authentication mode to Mixed, set up the sa account password. I can login using the sa account with no problems, but can't login using the windows account.

Anyone have any iseas what I could be missing?

Thanks,

Dhruv

Please add the following information

- When you type GPRESULT from a command prompt window, do you see BUILTIN\Administrators as a group you are a member of?

- Which operating system is this on? If this is Vista, try to spawn a command prompt as administrator (right click on the command prompt icon and choose "Run as Administrator") and test connectivity using sqlcmd. If that works, you will just have to add your windows account explicitly to SQL Server as a sysadmin to get around Vista UAC.

|||

GPRESULT does show BUILTIN\Aministrators, sqlcmd shows the following -

C:\Windows\system32>sqlcmd -S USLAP007;
HResult 0x35, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [53].
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : An error has occurred w
hile establishing a connection to the server. When connecting to SQL Server 2005
or above, this failure may be caused by the fact that under the default setting
s SQL Server does not allow remote connections..
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.

Thanks,

Dhruv

sql