Tuesday, March 20, 2012

can not access sql server after changing the access right for sa to "denied"

I can not access my SQL server, I have a password for
standart user but I get a message that connection failed.
the problem started when I "played" with "sa", I changed
the security for sa to "Denied" What can I do?There are a couple of possible solutions.
1. Restore master from a backup prior to making this change.
2. Rebuild master. Recreates the master database & sets back the defaults
3. Attempt to register the server as NT Administrator using Windows
Authentication.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

No comments:

Post a Comment