By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,400 Members | 1,335 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,400 IT Pros & Developers. It's quick & easy.

Create user similar to 'sa'

P: 2
In SQL Server 2000, how do you create a new user that essentially has the same permissions as the default 'sa' user, preferrable through Enterprise Manager?
Feb 14 '08 #1
Share this Question
Share on Google+
2 Replies


ck9663
Expert 2.5K+
P: 2,878
I believe (read: not sure) so. Just give him all the rights. During user creation, grant him all the server rights.

-- CK
Feb 14 '08 #2

Jim Doherty
Expert 100+
P: 897
In SQL Server 2000, how do you create a new user that essentially has the same permissions as the default 'sa' user, preferrable through Enterprise Manager?
Grant Access as a Server Administrator

Enterprise manager...security node...logins...select the user...double click ...Server roles tab .....then tick Server Administrator
Feb 16 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.