Sql-server – Sql Server management studio 2005 cant connect to localhost using windows authentication

databasesqlsql serverssms

I am trying to localhost using windows authentication with SQL Server management studio and I am getting a message that "Login failed for user…" (Error 18456).

I made sure that all the services are started, and I enabled the named pipe, TCP/IP protocol and shared memory for both Network configuration and Native Client config.

I have never tried to connect to localhost before, but I installed the Adventureworks sample database fine, and that's what I am trying to get to.

Thanks

Best Answer

Turns out that I had to go into the Surface Area Configuration and add myself as an Administrator. I am not really sure why this was the case, but it seems to have solved my problem. I could then connect using my computer name.

Related Topic