SA Account SSMS

Question

SA Account SSMS

robertlewis2001

SSC-Addicted

Points: 489
More actions
April 24, 2009 at 6:38 am

#95475

How do I log in and use the SA account using Sql Server Management Studio? What's the password? I tried black but that gave me error 18456

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

george sibbald SSC Guru Points: 104210 More actions · Answer 1

If you don't know the password there is no way we can guess it for you. When installing SQL server 2005 you have to specify a password so it will not be blank.

you need to connect with another account with sysadmin privileges and change the sa password:

sp_password NULL, 'securepassword','sa'

BTW, its bad practice to logon to SSMS with sa, set up a group containing those people who need sysadmin and connect via membership of that group.

---------------------------------------------------------------------

robertlewis2001 SSC-Addicted Points: 489 More actions · Answer 2

Thanks Ten Centuries.

I'm a new developer to Sql Server, so I'm still learning. How do you create groups, and then once the groups are created do I log in using Windows Authentication or Sql Server Security??

george sibbald SSC Guru Points: 104210 More actions · Answer 3

I'm talking about a windows group for use by a team of DBAs really. A new group would be created in active Directory by whoever looks after that, then that group is added to SQL via SSMS - security - logins - new login or the create login statement in SQL, and given sysadmin rights.

Same could be done for an individual user, such as your windows account.

You then connect to SSMS using windows authentication, under the auspices of the account you have logged onto the server\client with.

---------------------------------------------------------------------