• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 365
  • Last Modified:

accidently removed user from SQL. Now cant login to management studio

Fellow Sys admin removed user from sql server database. Unknown to Sys admin was that the 'user' was used to log into Management Studio. Now cant log into sql server Mgt Studio. how do i get back into sql server mgt studio
0
JohnAchille
Asked:
JohnAchille
  • 3
  • 2
1 Solution
 
chapmandewCommented:
have your sysadmin add the user back.
0
 
JohnAchilleAuthor Commented:
thats the problem we cant log back in to sql server mgt studio
0
 
chapmandewCommented:
ok.  are you able to log onto the machine (physical machine) as an admin.  the admin user is likely still able to log into the instance.  log onot the physical machine as an admin, open ssms, then readd the user that was deleted.
0
 
JohnAchilleAuthor Commented:
DUDE!!! U R MASTER JEDI CHAPMANDEW and I am you Padwan. That did it!!
0
 
JohnAchilleAuthor Commented:
Directly to the answer!!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now