Post reply

SQL server 2005 windows authentication fails and sa password unknown

  • November 26, 2008 at 9:03 am

    #201766

    I'm at a lose here; after running a simple transfer database package in the bus intelligence development suite, the windows authentication now fails with any attempt to connect to the database. I've researched extensively and have found many suggestions to reinstall sql server. A possible solution but would rather not if an alternative exist. The folks that initially installed this server failed to note the sa password or didn't initiate an sa account at all. I've also read something about starting in single user mode, stopping the service and issuing a sql command via sqlcmd window but can't find that page to reference. Any and all help is appreciated and happy Thanksgiving.

    Brian

  • November 26, 2008 at 9:14 am

    #903854

    Do you have any id avaialable which is sysadmin on this instalation so that you do these single user stuff and issuing a command from command prompt.

    MJ

  • November 26, 2008 at 9:17 am

    #903860

    Can you not connect to the server at all, or just this database?

    Can you connect to master on this instance?

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • November 26, 2008 at 9:23 am

    #903866

    Thanks for the reply. To my knowledge the accounts that have these rights are domain user accounts which require the windows authentication.

  • November 26, 2008 at 9:25 am

    #903870

    I am able to login to the server but unable to connect to the master db, same authentication issue.

  • November 26, 2008 at 9:28 am

    #903875

    That means you are not sysadmin there. Right?

    MJ

  • November 26, 2008 at 9:32 am

    #903880

    My ID is part of the administrator group on the server and sql server as well.

  • November 26, 2008 at 9:36 am

    #903885

    A colleague of mine had the same problem after running the transfer db package but was able to recover as he had the sa account and password.

  • November 26, 2008 at 9:41 am

    #903887

    Then try restarting it in single user mode by following the steps mentioned under this article:

    http://blogs.techrepublic.com.com/window-on-windows/?p=390

    HTH,

    MJ

  • November 26, 2008 at 9:45 am

    #903893

    Thanks for the tip, I'll give that a try and let you know.

  • November 26, 2008 at 4:04 pm

    #904085

    Follow-up;

    I was able to login to the sql server after adding my user ID to this group SQLServer2005MSSQLUser$SERVERNAME$INSTANCENAME and SQLServer2005SQLAgentUser$SERVERNAME$INSTANCENAME.

    I still have not figured out why windows authentication does not work with NT AUTHORITY\SYSTEM as part of security\logins.

    The access is at least there now with having added the necessary ID'S to these groups.

  • November 26, 2008 at 10:54 pm

    #904143

    Dear MANU

    Please tell the location of Rebuildm.exe file.I've searched it in my sql server2005 folders but I've not found it..

    Thanx

    Thanks

  • November 27, 2008 at 2:27 am

    #904188

    It's not in SS2K5. You need to use the setup.exe on your installation media.

    Not being unfriendly, but you could have googled that and got the answer much faster than you did here. Could save you some time in the future.

    Cath

  • November 27, 2008 at 12:16 pm

    #904458

    Find it in the doc attached. Hope you have the backups of system databases with you.

    MJ

  • November 27, 2008 at 9:33 pm

    #904543

    Dear Manu

    Thanks for the DOC.

    Thanks

Viewing 15 posts - 1 through 14 (of 14 total)

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