Reputation
Top tag
Next privilege 15 Rep.
Flag posts
Badges
1 3
Impact
~6k people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Sep
24
awarded  Autobiographer
Sep
16
awarded  Notable Question
Jan
10
awarded  Popular Question
Jun
15
comment Microsoft SQL Server says my login is disabled, even in single user/DAC mode
Hrm I'm getting a new set of errors now when I try to start the db in single-user mode. I'll see if I can make sense of those & if not post I'll it here.
Jun
15
comment Microsoft SQL Server says my login is disabled, even in single user/DAC mode
Still working through the process; starting the db in single-user mode isn't working for me at all right now. Restarting the db normally, and trying your add user commands, I get: Msg 18456, Level 14, State 1, Server SARAHS-PC\BPSINSTANCE, Line 1 Login failed for user 'Sarahs-PC\atemplogin'.
Jun
15
comment Microsoft SQL Server says my login is disabled, even in single user/DAC mode
>net localgroup administrators Alias name administrators Comment Administrators have complete and unrestricted access to the computer/domain Members ------------------------------------------------------------------------------- Administrator sarahg The command completed successfully.
Jun
15
comment Microsoft SQL Server says my login is disabled, even in single user/DAC mode
I'm happy to paste full logs somewhere but this comment thing seems to have a character limit.
Jun
15
comment Microsoft SQL Server says my login is disabled, even in single user/DAC mode
I think the sqlagent thing is the only part that's different to what I've tried, and I get: C:\Users\sarahg>net stop SQLAgent$DBNAME The SQL Server Agent (DBNAME) service is not started.
Jun
14
awarded  Student
Jun
11
comment Microsoft SQL Server says my login is disabled, even in single user/DAC mode
I don't know the password for any other user, including SA. Is there a default?
May
29
asked Microsoft SQL Server says my login is disabled, even in single user/DAC mode