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

login creation problem

hi, i'm using the last ctp of sql server management studio to create a database to sql express and add a login that give access to that database.
i created the login, assigned the user to the database assignig db_onwer and public, setting the default database, and create the login.
if i browse inside the database i find the news user created, the login seem created fine and linked to the user of the database, but if i try to use the login data to connect to the database i obtain the message

Login failed for user 'sitogs'. The user is not associated with a trusted SQL Server connection. (.Net SqlClient Data Provider)

this happens with both management studio and a my asp.net application.
I followed the procedure i always used with enterprisa manager and sql server.
Im doing something wrong?

> try to use the login data to connect to the database i obtain the
> message >
> Login failed for user 'sitogs'. The user is not associated with a
> trusted SQL Server connection. (.Net SqlClient Data Provider) What does your connection string look like? Are you sure you are trying to use SQL auth and not windows auth? Sounds like you are relying on windows auth. A

|||the connection string is:

workstation id=XPNEW;packet size=4096;user id=sitogs;data source=XPLAP;persist security info=True;password=sitogs

and is working fine with sql server 2000 with sql server authentication, and i have the same problem if i open sql management studio, change to sql server authentication and insert userid and password

|||"Trusted connection" is synonymous with "Windows Authentication". Make sure you've selected SQL Authentication in the connection dialog and not Windows Authentication.