Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


sa can't access but newly created user performed like sa


sa can't access but newly created user performed like sa

Author
Message
imneaz
imneaz
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
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.
regards

ayub
Joie Andrew
Joie Andrew
SSC Eights!
SSC Eights! (970 reputation)SSC Eights! (970 reputation)SSC Eights! (970 reputation)SSC Eights! (970 reputation)SSC Eights! (970 reputation)SSC Eights! (970 reputation)SSC Eights! (970 reputation)SSC Eights! (970 reputation)

Group: General Forum Members
Points: 970 Visits: 1912
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"
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search