adding an admin account on sql server 6.5 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

adding an admin account on sql server 6.5

How do I add an admin account on sql server 6.5?
Using SQL Security manager:
ON the server goto start –> programs –> MS SQL 6.5 group –> SQL Security Manager
and select SA Privileges (or View –> SA privileges) and select account to add in. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
So with the sa account I can not grant another user sa privileges w/o going thru security manager. When I tried security manager the check box that allows adding an account to the Administrators group was greyed out.
I tried the xp_grantlogin proc that did not work.
]]>