Post reply

add login

  • June 25, 2008 at 8:33 am

    #192869

    Hi,

    I have a W23k server running a GL application. I changed the name of the domain administrator. Since then in the event log I keep getting this error - Login failed for user 'NT AUTHORITY\SYSTEM'. My question is - how do I add this login to be sa? I have just read MSDE comes with no admin tools. Please be explicit what needs to be done as I have NO MSDE experience.

    Thanks for any and all replies.

    John

  • June 25, 2008 at 9:13 am

    #834080

    Change the MSDE account in services to run as Administrator or under a ADMIN account.

    Maninder
    www.dbanation.com

  • June 25, 2008 at 8:56 pm

    #834372

    Try using osql to connect to SQL Server (you should be able to connect using [font="Courier New"]osql -E[/font] from a command line). Then run these commands:

    [font="Courier New"]sp_grantlogin 'NT AUTHORITY\SYSTEM'

    go

    sp_addsrvrolemember 'NT AUTHORITY\SYSTEM', 'sa'

    go[/font]


    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare

  • June 26, 2008 at 12:27 pm

    #834927

    Scott,

    Thanks much for your reply. When I try to use the osql -E command, I get a Login failed for user 'domain\username'

    I assume that means the logged on user is not recognized by MSDE. Don't know how to correct this. Any thoughts?

    Thanks again.

    John

  • June 26, 2008 at 2:55 pm

    #834994

    Do you have any other windows account having sysadmin privileges on this installation?

    Manu

  • June 26, 2008 at 3:17 pm

    #835003

    what id do you normally connect to MSDE with? use that id if it has sa privelages, or use the sa id itself if you know the password

    osql -Sservername -Usa -Ppassword

    ---------------------------------------------------------------------

  • June 26, 2008 at 9:49 pm

    #835128

    jhindman (6/26/2008)

    Scott,

    Thanks much for your reply. When I try to use the osql -E command, I get a Login failed for user 'domain\username'

    I assume that means the logged on user is not recognized by MSDE. Don't know how to correct this. Any thoughts?

    Thanks again.

    John

    By default, BUILTIN\Administrators has sysadmin rights in SQL Server. Make sure the account you are logged in to Windows as is in the local administrators group.


    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare

  • June 26, 2008 at 9:53 pm

    #835130

    [font="Verdana"]Hi,

    You can try the article below to recover sa login!

    http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx

    [/font]

    Regards..Vidhya Sagar
    SQL-Articles

Viewing 8 posts - 1 through 7 (of 7 total)

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