Integrated to SQL Server Security...

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  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

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  July 8, 2011 at 1:42 am

  #1350175

  See here:

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

  Hope this helps

  Gianluca

  -- Gianluca Sartori

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  July 8, 2011 at 6:35 am

  #1350303

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

  THANKS!