SQL Server Performance Forum – Threads Archive
adding an admin account on sql server 6.5How 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
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.