Discussion in 'General DBA Questions' started by sonnysingh, Feb 27, 2008.
Any help on this please......
Go to your "Security" folder and right-click the login for BUILTINAdministrators. Under General tab you should see Security access radio buttons: Grant access and Deny access. Choose Deny access and next time you login and you use a userid that is a part of BUILTINAdministrators to let's say register your SQL Server via Enterprise Manager, you will receive an error message like the one below:
SQL Server registration failed because of the connection failure displayed below. Do you wish to Modify anyway?
Login failed for user 'MySQLServerAdministrator'
-OR if via SQL Query Analyzer-
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user 'MySQLServerAdministrator'.
Let me know if this is the solution you want.
Separate names with a comma.