Post reply

Integrated to SQL Server Security...

  • July 7, 2011 at 9:37 pm

    #254204

    I did a really stupid thing. WinXP Pro... I'm administrator, and since I'm lazy, I used the built-in Administrator account with Integrated Security. Works fine. Then, like an idiot, I created another account with Administrator rights. So my original account, called "Administrator" is now inaccessible. And since my database is using Integrated Security, I can't get into my database. Not a huge deal, since nothing is terribly important (fortunately), but is there an easy way to get back into my (local Administrator account and back into SQL Server where I can change the security to Mixed?

    Okay, okay... YES, I already have a sign! Bill Engvall has already visited!

    Thanks!

    Pieter

  • July 8, 2011 at 1:42 am

    #1350175

    See here:

    http://www.mssqltips.com/tip.asp?tip=1441

    Hope this helps

    Gianluca

    -- Gianluca Sartori

  • July 8, 2011 at 6:35 am

    #1350303

    Awesome!! So even even I could do it at 7 AM without coffee!

    THANKS!

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

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