CODEWITHSUNDEEP
sqlsql-server
BeYourOwnGod
BeYourOwnGod

Reputation: 2425

After new SQL Server 2008 installation cannot connect to localhost through windows authentication

I just finished an install of SQL Server 2008 and when it came ot the screen where it asks you if you want to connect through windows authentification or mixed mode I chose mixed mode. I supplied an sa password and then where it asks what accounts are part of the system admins I did not chose to add myself but added the computer's "administrators" account -- which I am a part of. I did not add myself because I am prepping this machine to be used as the base image for a team of developers and thought that if I added myself then I would also be adding myself as the admin for everyone who uses this image. I thought that adding "administrators" would be smart since I know that anyone who uses this image will also be a part of the administrators for that machine. SQL Server is only being added to the machine for local development and for the client tools to access our company's dev/staging/prod SQL Servers.

I just fired up SQL Management Studio and tried connecting to localhost with windows authentification and I am being prompted for a password. Not what I wanted...How do I fix this without a reinstall?

Upvotes: 2

Views: 3821

Answers (1)

Igor Borisenko
Igor Borisenko

Reputation: 3866

Connect to the server with SQL Management Studio with sa login, add your windows user in Security->Logins and give this new login sysadmin role.

About server-level roles you can read here http://msdn.microsoft.com/en-us/library/ms188659.aspx.

Good luck.

Upvotes: 2

Related Questions