Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
anjali66
Starting Member
23 Posts |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
anjali66
Starting Member
23 Posts |
Posted - 2010-12-22 : 23:47:02
|
hi, I have admin rights to this sql server. I installed the sql server and client on my machine.The server is also my local machine. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
konark
Yak Posting Veteran
60 Posts |
Posted - 2010-12-27 : 01:55:11
|
Disconnect all the server connections. orset database <db_name> set single_user and then try login as sysadmin privilege and make the change authentication mode.Confirm if it works.Chandragupta MouryaTakhyashila |
|
|
sen5241b
Starting Member
2 Posts |
Posted - 2010-12-29 : 09:59:11
|
I had a similar issue with SQL 2005 becuase the sa password I entered did not meet the server-level (or domain level) password complexity rules. I had to edit the hardcoded password(s) in the on-disk setup scripts and change it to a more complex password. |
|
|
|
|
|