Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

sa can't access but newly created user performed like sa Expand / Collapse
Posted Sunday, April 20, 2014 2:37 AM


Group: General Forum Members
Last Login: Monday, October 17, 2016 1:54 AM
Points: 17, Visits: 258
dear experts, i just created a user on SQL server 2008. named 'gakk/amin' and after that i can't access by sa.
this in my production server. i am worried,please help me. i don't need this 'gakk/amin'.
how i drop this user. and how i set everything as default sa.

please help me.

Post #1563315
Posted Sunday, April 20, 2014 6:04 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, October 18, 2016 4:15 PM
Points: 949, Visits: 1,884
Are you the DBA for the instance? If not you need to get with the DBA to resolve.

How do you know that the newly created user has anything to do with you not being able to access the instance now? The two seem unrelated. If you can take the instance down you can restart it to gain access from a command line:

net stop mssqlservr
net start mssqlservr -f -m

This should start the instance in single-user mode with minimal configuration. From there you can connect to the instance with sqlcmd and ensure that you're admin account has rights on the instance. Once done you can stop and restart SQL Server and try accessing it again.

Joie Andrew
"Since 1982"
Post #1563328
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse