Post reply

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

  • April 20, 2014 at 2:37 am

    #290419

    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

  • April 20, 2014 at 6:04 am

    #1707319

    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"

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply