rhwimmers
asked on
SQL 2008 SA password default
I installed SQL that comes with SBS2008 and it is set for windows authentication, I have an app that needs the SA account. I see it if I click on security, logins, but I cant change the password, I get the error message:
Cannot alter the login 'sa' because it does not exist or you do not have permission sql server error 15151
Cannot alter the login 'sa' because it does not exist or you do not have permission sql server error 15151
Is the sa account enabled? Set the authentication to mixed mode.
ASKER
How do I verify? I tried to enable or disable via a command but got the same, or similar error message. How do I see if its set to mixed mode, I think it is as well...
Load up Management Studio and expand the tree to Security and then Logins and then check the properties of the sa account. It may be enabled, it may not be able to log in.
On the first page when you bring up the properties of the sa account, ensure that the SQL Authentication is ticked and that you have set a password. Then clicking on status on the left, ensure you have grant and enable checked.
ASKER
Yes, under general there is a password in there, not sure what it is though.
Under status it is set for grant and enabled
Under status it is set for grant and enabled
ASKER
And if I check login disabled and try ok I get the same error message - sa doesnt exist or I dont have permission.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok, I get the same error if I try to set a password.
ASKER
Ok, thanks for the help - I found out what the sa password was set to (by a vendor).
Should be good to go now.
Thanks
Should be good to go now.
Thanks