Sysadmin Login been dropped from the Server

• ajay.g

  Ten Centuries

  Points: 1117

  More actions

  October 24, 2013 at 6:46 am

  #284231

  Hi,

  We've come across an issue by connecting to the Server. Because, the Sysadmin Login been dropped from the Server which was only the Login with administrative permissions and remaining ones having DB level permissions.

  Now, we are unable to connect the Server with admin Login to perform Server level activities.

  May I know any workaround for this issue?. Please suggest, it is an emegency.

• e4d4

  SSCertifiable

  Points: 5777

  More actions

  October 24, 2013 at 7:06 am

  #1661256

  Without stopping an instance eg. http://www.mssqltips.com/sqlservertip/2682/recover-access-to-a-sql-server-instance/

  Or if this will not work, run an instance in single user mode, and then add a sysadmin account.

  http://technet.microsoft.com/en-us/library/dd207004.aspx