- Launch SQL Server Configuration Manager (Run -> SQLServerManager11.msc)
- Stop SQL Server (SQLEXPRESS) instance
(To stop: right-click stop or click then click the stop icon)
- Go to the properties of SQL Server
(To get to properties: right-click click properties or click then press alt+enter)
- SQL Server 2012
Click “Startup Parameters” tab and enter “–m” then press Add, Apply, and close the window
SQL Server 2008/2005 Unfortunately I don’t have a screenshot of the 2008 or 2005 properties window, but I believe the startup parameters is under the advanced tab and make sure to add separate the parameters by ; (this bit me the first time around) - Start the SQL Server (SQLEXPRESS) service
(To start: right-click and click Start or click then click the start icon) - Run SQL Server Management Studio
(To start: win+r and type ssms press enter)
- Connect and add the BUILTIN\Administrators or whatever users you prefer to add
- Remove the –m startup parameter
- Stop SQL Server
- Open Properties
- Remove Startup Parameter
- Start SQL Server
- Good to go
Live Demos
▼
Monday, January 07, 2013
What to do when you are locked out of SQL Server
I was recently helping out a fellow Headspringer when we realized we were locked out of his local SQL Express installation. We just needed to start SQL Server in single-user mode, give rights to whatever users we want, and then start back in normal mode. Here’s what we did:
Excellent blog here! Also your site loads up very fast!
ReplyDeleteWhat web host are you using? Can I get your
affiliate link to your host? I wish my site loaded
up as fast as yours lol
Take a look at my page :: microsoft registry cleaner
http://chlorigheiru.tk/ind/anketa46191.htm#tp35173 Проститутки M. Планерная - Индивидуалка Дарья, не доступен
ReplyDeletehttp://deiwaltare.tk/checked/anketa/84024 Оценки Светлана, Москва, (926)9750314
http://saywtenasun1972.tk/ind/anketa78091.htm Проститутки M. Пушкинская - Индивидуалка Лялька, +7 (921) 747-41-76
http://inetarem.tk/ind/anketa85332.htm Проститутки M. Лубянка - Индивидуалка brandy, +7 (964) 729-81-89
http://inetarem.tk/ind/anketa48331.htm#tp33972 Проститутки M. Алексеевская - Индивидуалка Верона, не доступен
Thanks for sharing excellent informations. Your site is very cool.
ReplyDeleteI'm impressed by the details that you've on
this site. It reveals how nicely you perceive this subject.
Bookmarked this website page, will come back for extra articles.
You, my friend, ROCK! I found simply the info I already
searched all over the place and simply could not come across.
What a perfect website.
Stop by my website: how to hack a twitter account
Just wish to say your article is as amazing. The clearness to
ReplyDeleteyour submit is simply cool and i could think you are an
expert in this subject. Fine with your permission allow me to clutch your RSS feed to keep up to date with forthcoming post.
Thank you a million and please carry on the rewarding
work.
Here is my web site; Watch TV Series Online
Good post. I learn something new and challenging on sites
ReplyDeleteI stumbleupon every day. It's always exciting to read content from other authors and use a little something from their sites.
Also visit my blog post :: airplane simulator games
If some one needs to be updated with most up-to-date
ReplyDeletetechnologies after that he must be visit this web site and be up to date daily.
Here is my homepage - Minecraft Download
Quality posts is the crucial to attract the visitors to go to see the site, that's what this web site is providing.
ReplyDeletemy webpage: Watch TV Shows
Pretty! This has been an incredibly wonderful article. Thanks for providing this information.
ReplyDeleteAlso visit my site :: get dragonvale
Very interesting subject , regards for posting . "I am convinced that life in a physical body is meant to be an ecstatic experience."
ReplyDeleteby Shakti Gawain.
Take a look at my homepage: hack sharecash
Wow, this post is fastidious, my sister is analyzing these things, therefore I
ReplyDeleteam going to let know her.
Look into my page; Watch TV Series Online
hello!,I like your writing very much! proportion we keep up a correspondence
ReplyDeleteextra about your article on AOL? I need an expert in this area to unravel my problem.
Maybe that is you! Looking ahead to peer you.
Here is my homepage :: Winrar password cracker
Hello, I enjoy reading all of your article.
ReplyDeleteI like to write a little comment to support you.
Also visit my blog sms Bomber
Hi there, this weekend is good in support of me, since this moment i am
ReplyDeletereading this enormous informative piece of writing here at my home.
My weblog; book of ra free games online
Write more, thats all I have to say. Literally, it seems as though you relied on the video
ReplyDeleteto make your point. You obviously know what youre talking about, why throw away
your intelligence on just posting videos to your blog
when you could be giving us something informative to read?
Also visit my website :: vliegtickets
I get pleasure from, lead to I found exactly what I was looking for.
ReplyDeleteYou've ended my 4 day long hunt! God Bless you man. Have a nice day. Bye
Also visit my web page: book of ra free (http://crew.perininavi.it)
If you want a Premium Minecraft Account check out this generator.
ReplyDeleteWith it you can generate a unique Minecraft Premium
Account which no one else has! You can Download the Free Premium Minecraft Account Generator
http://www.free-minecraft-download.tk
I really like reading a post that can make men and women
think. Also, thanks for allowing for me to comment!