Member Avatar for ChPravin

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.

  • 2 Contributors
  • 2 Replies
  • 78 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by ChPravin
Member Avatar for tesuji

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

Member Avatar for ChPravin

Thanks for the reply.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.