I recently installed SQL2005 and SQL2000. I only created SA login permissions with Admin access to the database (There are no Windows Users that have access).
I then installed SQL2000 and it overwrote the "mixed connection mode" . whenever I try to connect with the sa login I get the following error
Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
The problem is explained in a fix http://support.microsoft.com/kb/269587
The only problem is that the fix requires access rights that I don't have. My only logins are "BuiltIn\Users" that have public access rights and then a "sa" login (that doesn't work) that has Admin rights within the db engine.
So my question is... Can I create an sysadmin account with windows authentication (for a normal Windows Admin Account) without having the proper rights within the database engine?
-Tom
I would recommend taking a look to the followign post:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1353448&SiteID=1
If the information there doesn't help you, please let us know, we will be glad to help.
Thanks,
-Raul Garcia
SDE/T
SQL Server Engine
No comments:
Post a Comment