Post reply

Server Admin, need SQL Account

  • February 10, 2012 at 1:27 pm

    #250610

    I am administrator on the Windows server but can't log in to SQL Server. Is there any group I can assign myself to that will allow me to log into SQL Server as sysadmin? (I did not do the install but am the DBA.)

    Thanks!

  • February 10, 2012 at 2:10 pm

    #1445784

    If you start SQL Server in single user mode, than any member of Local Administrators is a sysadmin and then you can connect (I'd suggest SQLCMD not SSMS) and add your normal windows login as a sysadmin.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 13, 2012 at 1:25 pm

    #1446478

    Thanks. That did it.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply