Sql database server (Create another user other than SA Account)

Question

_{Monday, March 25, 2013 12:47 PM}

Hi All,

How can I give the same permissions as the other user account .After I create another account.

Just In Case If SA Account is locked? in sql server 2005

All replies (3)

_{Monday, March 25, 2013 8:10 PM ✅Answered}

Refer link : Connect to SQL Server When System Administrators Are Locked Out.

YOu can unloack sa account or can give permission to other user as sysadmin  if no user having sysadmin rights by below link.

http://msdn.microsoft.com/en-IN/library/dd207004.aspx

Regards,
Rohit Garg
(My Blog)
This posting is provided with no warranties and confers no rights.
Please remember to click

Mark as Answer and

Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

---

_{Monday, March 25, 2013 12:54 PM}

select * from sys.logins

and check the users roles

Ramesh Babu Vavilla MCTS,MSBI

---

_{Monday, March 25, 2013 11:02 PM}

There are essentially two things to do.  First, an SA account is basically an account assigned to the sysadmin role.  If you want a backup sysadmin account, then simply create a new login and add it to the sysadmin role.  Second, if you only have one SA account that gets locked, then you can reset it following the directions in the post below that I provided.

Please see the following post.

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/525eff7b-ae00-492c-8f28-f81cf6b03cd3