Hello All,
I am new to SQL Server 2008.I was just wondering if there is any way to add a user as an admin in SQL Server 2008? Is it possible to do using SQL Server Management Studio?
Thanks.
Hello All,
I am new to SQL Server 2008.I was just wondering if there is any way to add a user as an admin in SQL Server 2008? Is it possible to do using SQL Server Management Studio?
Thanks.
Jump to PostYes, you can use SQL Server Management Studio this way:
security --> logins --> new login
--> general: create new login
--> server roles: mark at least sysadmin (there is no admin, sa is obsolete)etc.
-- tesu
Yes, you can use SQL Server Management Studio this way:
security --> logins --> new login
--> general: create new login
--> server roles: mark at least sysadmin (there is no admin, sa is obsolete)
etc.
-- tesu
Thanks for the reply.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.