Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Sunday, April 20, 2014 2:37 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 10, 2014 8:46 AM
Points: 11, Visits: 177
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.
regards

ayub
Post #1563315
Posted Sunday, April 20, 2014 6:04 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, July 18, 2014 11:32 AM
Points: 709, Visits: 1,410
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