June 3, 2004 at 12:04 pm
I'm beginning to learn SQL Server. I have SQL Server 2000 Developer Edition installed in my PC. My PC runs Windows XP Professional operating system.
In Enterprise Manager, when I "Edit SQL Server Registration properties" and try to change the connection to "Use SQL Server authentication", SQL Server rejects the Login Name 'sa' and shows the following message:
"SQL Server registration failed because of the connection failure displayed below.
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection".
*-------------------------------------------*
'sa' is already a SQL Server user. It belongs to the 'System Administrators' role and has 'public' and 'db_owner' roles on all databases.
Please tell me what to do.
Thanks in advance for your help,
Xavier Castillo.
June 3, 2004 at 12:46 pm
Hi Xavier,
This is a simple problem. All you have to do is change from windows NT authentication to mixed mode authentication. To do this, Go to EM, righclick on your server, choose properties, go to securitiy tab and under authentication select SQL Server and Windows radio butten.
This should solve your problem.
Regards.
June 3, 2004 at 10:37 pm
It worked right away! Thanks for your help.
Xavier Castillo.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply