Share via

Step-by-Step: Installing SQL Server Management Studio 2008 Express after Visual Studio 2010

  • Article

UPDATE 7/31/2012 - Since this post new versions of SQL Server & Visual Studio have been released. To install the latest version of SQL Server see SQL Server Install. For more information on working with SQL Server Local DB in Visual Studio 2012 see Working with SQL Server LocalDB in Visual Studio 2012 and the MSDN Library SQL Server 2012 Express LocalDB.

One of the first things I always do after installing Visual Studio is to install SQL Server Management Studio (SSMS). Visual Studio 2010 installs SQL Server 2008 Express on your machine but doesn’t include SSMS. Although you can use Visual Studio to create/connect/design databases, I like having SSMS around for advanced management. I recall SSMS for SQL Server 2005 was a simple install, unfortunately they threw the kitchen sink into the SSMS 2008 installer and I’m always confused at which buttons I need to push to get it to do what I want. So I’m writing up this blog post for two reasons 1) So I remember the steps and 2) So you can be less frustrated :-) (BTW, a birdie tells me that the SQL team is looking at making this installer much simpler in the future. Hooray!)

Okay the first thing you need is to make sure you get the right version of SSMS. If you installed Visual Studio 2010 then you will need the 2008 version (not R2).

STEP 1: Download Microsoft® SQL Server® 2008 Management Studio Express and select either SQLManagementStudio_x64_ENU.exe or SQLManagementStudio_x86_ENU.exe depending on your machine’s OS bit-ness. I’m running Windows 7-64bit so I’ll be detailing the steps as it pertains to that OS.

STEP 2: Make sure you’re logged in as an administrator of the machine then right-click on the exe you downloaded and select “Run as Administrator”. If you’re on Windows 7 then you’ll get a compatibility warning. Click past it for now to continue with the install. Later you’ll need to apply SQL 2008 Service Pack 2.

STEP 3: You should now see the “SQL Server Installation Center” window. Yes it looks scary. Select the “Installation” tab.

image

STEP 4: Select “New SQL Server stand-alone installation or add features to an existing installation”. It will then run a rule check. Make sure there are no failures and then click OK.

image

STEP 5: The next step is misleading. The Setup Support Files window looks like it’s doing something and stuck on “Gathering user settings.” It’s actually waiting for you to click the Install button! Doh!

image

STEP 6: Another rule check. You’ll probably end up with a Windows Firewall warning this time. If you want to enable remote access to SQL Server you’ll need to configure the firewall later. Since I’m using SQL Server Express for development purposes on this machine only, I won’t need to worry about that. Click Next.

image

STEP 7: Okay here is the step I always mess up because it’s just not intuitive at all. On the Installation Type window you have a choice between “Perform a new installation of SQL Server 2008” OR “Add features to an existing instance of SQL Server 2008”. You need to select new installation, NOT add features. I know I know, totally weird. You would think that since you just want to add SSMS that it would be Add features to existing instance – I mean I don’t want a new instance, just the dang tools. Sigh. Click Next.

image

STEP 8: Next you get the Product Key window. You obviously don’t need a product key for SQL Server Express since it’s free so just click Next.

image

STEP 9: Accept the License Terms and click Next.

image

STEP 10: Okay now for the window we’ve all been waiting for - Feature Selection. Check off “Management Tools – Basic” and then click Next.

image

STEP 11: Verify your disk space requirements and click Next.

image

STEP 12: Help Microsoft improve SQL Server features and services by selecting to send usage and error reports to them (or not). Click Next.

image

STEP 13: Another quick rule check runs. Click Next.

image

STEP 14: Now it looks like we’re ready to install. Click the Install button.

image

The install will kick off and will take about 5 minutes to complete.

STEP 15: Once the installation completes, click the Next button again.

image

STEP 16: Complete! Click the Close button and you should be all set.

image

STEP 17: Fire up SQL Server Management Studio! You should now see it in your Programs under Microsoft SQL Server 2008. Make sure you run it as an administrator for access to all the features.

image

And don’t forget at some point to install the latest SQL Server 2008 Service Pack. I hope this helps people who have just installed Visual Studio 2010 but also want to install SQL Server Management Studio. I know I’ll be referring to my own post on this when I need to do it again :-)

Enjoy!

Comments

  • Anonymous
    February 18, 2011
    Very helpful, Beth.  The pictures remind me of some of my project documentation.  This is a great example of one of the several instances I have encountered recently where setup installer processes stray from the installer operation patterns what we all get familiar and comfortable with.My solution to that problem is to use VMs, and incrementally snapshot each "correct" step as the system is being built.  Then, getting it "right" only has to happen once. :)It seems to me that when I encountered this myself, I installed R2 express, had it upgrade the existing express instance, along with adding SSMS, but it was long enough ago that I don't remember for sure, but I know I was pleased enough with the results of my installation...

  • Anonymous
    February 18, 2011
    The comment has been removed

  • Anonymous
    February 18, 2011
    Great article -I have SQL 2008 Standard installed with Mgt Studio. I need to also have Expess for all the demo's and learning tutorials that have Express files included in the download.What is the best way to install side by side - having problems Express.

  • Anonymous
    February 20, 2011
    Hi JimDev EIf you have SQL Server standard edition you really don't need Express, you can attach the same MDF database files to your SQL Server instance and then just change the connection string to point to your .SQLSERVER instance. Check this out:msdn.microsoft.com/.../ms190209(v=SQL.100).aspxHTH,-B

  • Anonymous
    February 20, 2011
    Hi Beth -I tried that many times and sometimes it works and sometimes I get an error similar to "The path so and so does not exist" Like the path where the MDF should exist is hardcoded in the file itself or something.Thanks for the pingback though.

  • Anonymous
    February 26, 2011
    Hi Beth,After running SQL Server SP2 on Windows 7 x64 did it upgrade your SSMS to 10.2.4000.0 or did it leave it at 10.50.1600.1? Both my Win3k3 x32 bit and Vista x32 systems have been upgraded to 10.2.4000.0.All of your publications are great!!!

  • Anonymous
    March 24, 2011
    good tutorial on how to install this, i'm having hug problem installing sql server 2008... thanks...... in my case i just update sql server 2008 to sp2, before i install sql server 2008. visual studio 2010 have install sql server R2..... anyway thanks again beth.... i got error when luch ssms "The file %CommonDir%vslangproj80.olb could not be loaded. An attempt to repair this condition failed because the file could not be found."

  • Anonymous
    April 05, 2011
    Your instructions are very useful and clear so I've referenced this page on my class website.  Hope you don't mind.  www.cop1000.com/.../Announcements.aspx

  • Anonymous
    April 16, 2011
    The comment has been removed

  • Anonymous
    May 22, 2011
    Very helpful, Thank you!

  • Anonymous
    May 25, 2011
    Thank you very much Beth.  Your instructions are very helpful.

  • Anonymous
    June 15, 2011
    good effort dear.....

  • Anonymous
    June 23, 2011
    Thank you. I was already giving the installation when I found your tutorial. you saved me

  • Anonymous
    June 29, 2011
    Thank you so much. It saved me a lot of time. Good work!!

  • Anonymous
    July 05, 2011
    Thank Somuch...This article really helped me. All weard steps.

  • Anonymous
    July 21, 2011
    No helpful to me as all I want to do is install the Management Studio on my desktop as the database is on the server. I want to be able to administer from my desktop. I have MS SQL Enterprise Manger still on my desktop as my previous server had SQL Server 2000 and this was an upgrade. It sees the Express installed on the server and will even attach to it but won't let me manage it. Any suggestions on this?

  • Anonymous
    July 25, 2011
    The comment has been removed

  • Anonymous
    August 03, 2011
    Amazing post, I just have one question, will I be able to get access to the Adventure Works Database after the installation is Completed?

  • Anonymous
    August 04, 2011
    Hi Bhaskar Manna,Once you install SQL Express you can install AdventureWorks here:msftdbprodsamples.codeplex.com/.../37109HTH,-B

  • Anonymous
    August 06, 2011
    nice one...completely unintuitive by MS. Spent most of the day looking for that step. Thanks again

  • Anonymous
    August 09, 2011
    now when i use the New SQL Server stand-alone installation or add features to an existing installation  there is something that says browse for sql server2008 installation media  what should i choose  and good job

  • Anonymous
    August 22, 2011
    Thanks for sharing. following the steps documented here, I successfully installed.

  • Anonymous
    August 30, 2011
    Thanks for the helpful article...I thought I was on drugs when I couldn't install the mgmt studio...was not intuitive at all for me. Glad I found your article. Thanks for taking the time to write it.

  • Anonymous
    August 30, 2011
    Perefect! That works. Thanks a lot!

  • Anonymous
    September 03, 2011
    The comment has been removed

  • Anonymous
    September 05, 2011
    thanxxxxxxxxxxxxxxxx alotttttttt

  • Anonymous
    September 21, 2011
    plz give me a link to download sql server2005 or 2008.

  • Anonymous
    September 27, 2011
    Thanks for the helpful article , thanks Beth

  • Anonymous
    September 30, 2011
    The comment has been removed

  • Anonymous
    October 03, 2011
    Thank you so much, which i had found this 2 hours ago ;(it saved (the rest of) my day.You are a star

  • Anonymous
    October 08, 2011
    This helps a lot.  The installation is quite complicated.

  • Anonymous
    October 09, 2011
    this is such a big help! thank you for your kindness to share this to everyone! thanks!

  • Anonymous
    October 19, 2011
    Very Helpful... thanks a lot...

  • Anonymous
    October 19, 2011
    thanks a lot !

  • Anonymous
    October 19, 2011
    I have 1 degree in IT and I am now working on the remaining 3, but If it were not for this webblog of yours I don't think I would have been able to install this nightmare from Microsoft.     ThankYouVeryMuch

  • Anonymous
    October 23, 2011
    Thank you Beth, very helpful !!!

  • Anonymous
    October 24, 2011
    Kept wondering why I couldn't add that feature to my existing installation. Thanks!!

  • Anonymous
    November 02, 2011
    Thanks a lot this has helped me several times.

  • Anonymous
    November 04, 2011
    Thanks for posting this. It really helped me make sure I was doing the right thing.  Like you said, it is very un-intuitive and the exact opposite of obvious.Your guide helped a lot, thanks again

  • Anonymous
    November 09, 2011
    Thanks!  This was really helpful!

  • Anonymous
    November 10, 2011
    Worked even for us non SQL folk

  • Anonymous
    November 13, 2011
    Thanks for installation steps :)

  • Anonymous
    November 20, 2011
    Thank you! The installer is quite confusing and this helped a lot. :-)

  • Anonymous
    November 28, 2011
    Straight and to the point. Your work save me time.Thanks.

  • Anonymous
    December 01, 2011
    Thanks..       this is super....guideline to install

  • Anonymous
    December 12, 2011
    Doesn't work for me as well

  • Anonymous
    December 12, 2011
    When i try to install SQL server Management Studio,everything moves smoothly, but when on the Set Up Support rules ,all rules are passed except Powershel which has failed.I therefore have no option to move to the next stage.What can i do?

  • Anonymous
    December 13, 2011
    It was really helpfullThanks!!!

  • Anonymous
    December 15, 2011
    At what point should I install the sql server 2008 service pack?

  • Anonymous
    December 19, 2011
    Thanks for posting this, i would have never looked under "Perform a new installation of SQL Server 2008" to install Management studio.

  • Anonymous
    December 19, 2011
    Thank you!! Very helpful!

  • Anonymous
    December 25, 2011
    thanks a lot dudeit was very help full

  • Anonymous
    December 25, 2011
    Thank you very much!

  • Anonymous
    December 27, 2011
    i send a message , why doesnt it show up?

  • Anonymous
    December 31, 2011
    Great job! You saved me a lot of time. I appreciate all your efforts.

  • Anonymous
    January 05, 2012
    This has been great help to me today. I've been looking all afternoon to determine how to do this, and finally found your block today. I wonder why Microsoft doesn't make a setup for the Management Studio app without the server install? My guess is that it would make it too easy. ;-)

  • Anonymous
    January 05, 2012
    Thanks a lot. I tried some time without success. Your blog helped me so much!

  • Anonymous
    January 09, 2012
    Thanks. The New install/Add features to an existing install totally confused me.

  • Anonymous
    January 25, 2012
    Thank you so much. I don't understand why this has to be so complicated. I have to do this a couple of times a year and can never remember the process.

  • Anonymous
    January 26, 2012
    I appreciate the assistance.  I would get error messages popping up but then would go through the process again okay.  It would have taken even longer without the installation steps.

  • Anonymous
    January 26, 2012
    The comment has been removed

  • Anonymous
    January 26, 2012
    Thank you most kindly!

  • Anonymous
    February 05, 2012
    Hi,I had come across this before but swiftly moved on to something else.  Thankyou for taking the time to document this, it is greatly appreciated!Cheers,

  • Anonymous
    February 09, 2012
    Huge help!  It certainly wasnt obvious and screen shots were just what I needed.  Thank you!

  • Anonymous
    February 10, 2012
    The comment has been removed

  • Anonymous
    February 19, 2012
    Hi Beth,While Installing SQL Server 2008 Express, Three is a SERVER CONFIGURATION feature in the left panel (below disk space requirements). My question is which ACCOUNT NAME I should choose.Does NT AUTHORITYNETWORK SERVICE OR NT AUTHORITYSYSTEM to be chosen?I Appreciate Any help.Thanks.

  • Anonymous
    February 21, 2012
    thanks a lot. I have done three installations already and it was not working. your blog helped me a great deal. You are a star!!!

  • Anonymous
    February 26, 2012
    Thank you! Thank you! Thank you! Thank you! Thank you! Thank you! Thank you! Thank you!

  • Anonymous
    March 03, 2012
    I tried installing SQL Server 2008 Management Studio but i'm stuck on the FEATURE SELECTION page; as I find all the Check Boxes inactive. Dont know how to deal with it. please assist. Thanks!

  • Anonymous
    March 03, 2012
    I tried installing SQL Server 2008 Management Studio but i'm stuck on the FEATURE SELECTION page; as I find all the Check Boxes inactive. Dont know how to deal with it. please assist. Thanks

  • Anonymous
    March 04, 2012
    Thanks a lot, very helpful!

  • Anonymous
    March 06, 2012
    The comment has been removed

  • Anonymous
    March 10, 2012
    Finally got the right version installed after a loooong try.But why can't I login to the system with windows authentication ( no password )?Can someone help me out here?  Thanks in advance :)

  • Anonymous
    March 12, 2012
    What is the problem if my installation occurred an error at step 5?

  • Anonymous
    March 14, 2012
    This little guide was FABULOUSLY useful, accurate and easy to follow. Thank you Beth Massi, Installation Guru.

  • Anonymous
    March 15, 2012
    Thanks a ton. You saved me some serious frustration.

  • Anonymous
    March 15, 2012
    Thanks! It was really very helpful!

  • Anonymous
    March 18, 2012
    thankx alot to you my friend i install twice before SQL but Management studio is vanished then i follow you so its really helpful.Bundle of thanx again

  • Anonymous
    March 20, 2012
    Thank you soo much

  • Anonymous
    March 20, 2012
    kindly any one let me know after install how can i get to connect sql server 2008 when creating a new table in express

  • Anonymous
    March 22, 2012
    Awesome info. Thanks!

  • Anonymous
    March 24, 2012
    Thanks for presenting the screen shots of the steps. They were a big help.

  • Anonymous
    March 28, 2012
    It was very helpful especially step 7. Thanks

  • Anonymous
    March 30, 2012
    Thank You So much

  • Anonymous
    April 01, 2012
    Thank you! It was hard to find the right option that make Management studio to appear, it works now :)

  • Anonymous
    April 04, 2012
    Hello i basically followed your steps after i installed visual studio 2010 on my windows 7 x64 laptop but when i tried to install management studio it asks for visual studio 2008 sp1 but when i try install that it then won't let me do that either. I guess visual studio 2010 also installs vs 2008 then? This is a major headache.

  • Anonymous
    April 10, 2012
    Step 7 was the hurdle for me. Thanks for saving me time Beth!

  • Anonymous
    April 18, 2012
    what is the server name that i can log in with?

  • Anonymous
    April 19, 2012
    Nice post, thank you very much.  It's very complicated to install this software.  

  • Anonymous
    April 19, 2012
    Hi Beth,Thank you so much for the great post. I installed the management studio a month ago following all your steps and it worked great.Now I discovered that I have a problem with my hosting company: they are using 2008 R2, and when I try to restore the DB from the server back on my computer, I get an incompatibility message. I am using VS2010, and I just saw in the beginning of your blog that for VS 2010 I need to use management studio 2008 and not R2. What do you recommend that I do?I am an absolute beginner with MS SQL, so I feel very lost. Do you have any suggestion for me?Thanks so much!

  • Anonymous
    April 20, 2012
    Hi Ela,I wrote this post over a year ago and more recent versions of SQL have been released. So you will need to download the version of SSMS that is compatible with your SQL Server versions. The latest SSMS will connect to older databases. If you have more questions, I'd ask them in the forum:social.msdn.microsoft.com/.../threadsHTH,-B

  • Anonymous
    April 24, 2012
    Thanks Beth.  Screenshots are alittle different but I got through the install in about 5 mins.  1 year later and M$ still hasn't improved this install.

  • Anonymous
    April 28, 2012
    thank you soooo much...it ws very helpful...i had almost pulled my hair out until i found this article...thank you once again :)

  • Anonymous
    May 01, 2012
    I... I think I love you

  • Anonymous
    May 01, 2012
    Thank you !!!

  • Anonymous
    May 08, 2012
    Thank you. Saved a bunch of time. It is amazing how complicated it is to install a tool.

  • Anonymous
    May 20, 2012
    Thank you. For some reason a always choose 'Add features to an existing instance of SQL Server 2008'

  • Anonymous
    May 21, 2012
    Thanks Beth.

  • Anonymous
    May 21, 2012
    Thanks for posting this, this saved so much time for me! Keep up the great work.

  • Anonymous
    May 24, 2012
    Thank you so much for "STEP 7" I thought I was losing my mind when I couldn't figure out what to do. Thanks again

  • Anonymous
    May 30, 2012
    Yeah... new installation to extend existing one. This is what I like in MS ;). Thanks!

  • Anonymous
    June 01, 2012
    hey, i can't seem to do this. the part where it asks you the installation type does not appear whenever i try it. this is so frustrating.:(

  • Anonymous
    June 02, 2012
    The comment has been removed

  • Anonymous
    June 02, 2012
    on clicking the installation tab iam getting a message that says to browse for SQL server installation media whati should i do? please help

  • Anonymous
    June 03, 2012
    Dear Sir,              Please sir send me SQL Management Server 2008

  • Anonymous
    June 04, 2012
    Thank you so much for this. Why do they have to make everything so needlessly complex and hide things under layers of rubbish? lol

  • Anonymous
    June 06, 2012
    OMG I went through that installer 10 different times and didn't figure that out. THANK YOU!

  • Anonymous
    June 12, 2012
    Thanks a lot

  • Anonymous
    June 19, 2012
    Thanks very much for this article. I had made each of the mistakes you mentioned above! Lets hope the next SSMS installer is easier...

  • Anonymous
    June 20, 2012
    You are a life saver :)

  • Anonymous
    June 25, 2012
    Hey man, great job with the walk-through, but I've been having a problem that's been preventing complete installation of the sql server management studio. When I get to the feature selection page, the 'management tools' checkbox is inactive and I believe it is for this reason that when I complete installation, I can't go past the page where you specify the server name and all those other details. Any help on this will be appreciated.

  • Anonymous
    June 25, 2012
    Even though I've done this roughly once a year for 5 years, I always get stuck.  THanks for pointing me in the right direction! (in this case, I'd also downloaded the wrong .exe.  D'oh!)

  • Anonymous
    June 26, 2012
    Thanks for sharing this.

  • Anonymous
    June 26, 2012
    Thanks for the post.  I would have given up on this install otherwise.  Microsoft is wonderful at leading users into the void - I'm glad this article was here to pull me back.

  • Anonymous
    June 29, 2012
    very very helpful....Thank you so much

  • Anonymous
    July 02, 2012
    Many thanks for this installation support; it really helps me al ot ;-).

  • Anonymous
    July 05, 2012
    Thanks for the info. This was very helpful.

  • Anonymous
    July 05, 2012
    The comment has been removed

  • Anonymous
    July 06, 2012
    Beth, I'm really glad I found your web page. I'd downloaded the client from MS but would never have thought on clicking 'New installation'. You saved me a ton of time and effort, thanks a bunch!

  • Anonymous
    July 07, 2012
    Sadly, several versions and a year later, and the installer is still a mixed-up mess.Contractor programmers... You get what you pay for.

  • Anonymous
    July 19, 2012
    Thanks a lot. It is very confusing indeed. I wouldn't have managed it without your help.

  • Anonymous
    July 20, 2012
    Cheers, really helped me install the SMT as I was getting stuck on what the installation centre was all about.

  • Anonymous
    July 24, 2012
    thanks a lot.so usefull

  • Anonymous
    July 24, 2012
    Awsome. Thanks

  • Anonymous
    July 29, 2012
    Just wasted a day following this. Complete waste of time. it needs sqlncli.msi for R2 which you say you don't need. The download for this sends the wrong file and the install fails. It is impossible.

  • Anonymous
    July 30, 2012
    At the last step it shows error message Management Tool - Basic failed.What to do?

  • Anonymous
    August 04, 2012
    :-)  thx!

  • Anonymous
    August 05, 2012
    If we perform the installation action on the installed instance the microsoft setup file does not work

  • Anonymous
    August 06, 2012
    Thanks Beth, that was a great help.

  • Anonymous
    August 06, 2012
    Hey I hav gone through All of the above screens in my Installation Process too!But for the Last one!The SQL Server2008 Installation is done Successfully but the Program doesnt Exist on my System At all!It isn't on my All-Programs either!What do I do??Pls Help me!!

  • Anonymous
    August 07, 2012
    I am not going to say anything new, but thanks for saving me hours of work on such on such a non-intuitive installation.

  • Anonymous
    August 08, 2012
    Have to echo previous comments and say thanks for saving me time and effort with such a confusing and counterintuitive installation script.

  • Anonymous
    August 24, 2012
    Sheesh! Thank you for this! :)

  • Anonymous
    August 27, 2012
    The best manual of anykind, tnx!

  • Anonymous
    August 28, 2012
    Thanks to this valuable post to do the right steps for installation.

  • Anonymous
    September 11, 2012
    hi i have uninstalled both vs 2008 and sql server 2005 and 2008 form my machine and re installed vs2008 and i installed sql server2008 r2 but mng studio is missing and i downloaded mng studio from ms and installed but its showing one error " previous version of vs is not updated pls update sp1 " what i have to i am not getting pls help me  

  • Anonymous
    September 21, 2012
    Obrigado pela ajuda. Este passo a passo fui muito importante.Um abraço

  • Anonymous
    September 22, 2012
    OOOmg thankyou...! Weirdest installation for a program ever!

  • Anonymous
    September 23, 2012
    Hi Beth,thank you for this brillant explanation of installation.Best regards

  • Anonymous
    September 23, 2012
    i installed my sql server right way but i dint get mamageent studio i followed all steps correctly what hppend i dont know how to troble shoot

  • Anonymous
    September 24, 2012
    Dude!! This guide is GREAT! I was having the exatcly same problem as you had. I use VS2010 Pro but I also like the SSMS to work out with databases and the "add new feature" trick is quite anoying since its not intuitive at all.Found your blog googling... thanks for write it!RegardsFG

  • Anonymous
    September 24, 2012
    I am also always getting confused on the new installation/add features page...

  • Anonymous
    September 26, 2012
    Awesome writeup... good detailing !!!

  • Anonymous
    September 26, 2012
    Thanks.straight forward and very helpful.

  • Anonymous
    September 27, 2012
    hey man, you made my day, thank you

  • Anonymous
    October 02, 2012
    Very nice walkthrough.   Thanks especially for STEP 7...that is the one that was throwing me off.

  • Anonymous
    October 08, 2012
    thanks a lot for your article helped so much...confused on same point

  • Anonymous
    October 08, 2012
    Hi. out of the problem.. thanks a ton... :) long live Beth.. :)

  • Anonymous
    October 12, 2012
    Thanks for taking the trouble to write this up. Installing SQL Server Management Studio is something I do relatively rarely - and ALWAYS waste time working out how to get it to work (due to the need to select "New instance") - Microsoft have a knack of finding ways to make us all waste time needlessly!)

  • Anonymous
    October 24, 2012
    Great post thanks Beth. Saved me a load of time. Would never have worked that out - got to be one of the least intuitive installs I've come across.

  • Anonymous
    November 01, 2012
    The comment has been removed

  • Anonymous
    November 02, 2012
    Thanks. Easy to follow guide. Perfect.

  • Anonymous
    November 05, 2012
    Thanks a lot!Your article helped me to aviod a lot of problems.Wouldn't you mind, if I will translate it to Russian and post into my blog? With your name and reference to ths page, of course.

  • Anonymous
    November 15, 2012
    Thanks!  Life saver :)

  • Anonymous
    November 19, 2012
    Heart felt thanks for the details  provided

  • Anonymous
    November 20, 2012
    Fantastic guide - Great screen shots and really well written.

  • Anonymous
    November 21, 2012
    Why do you say check off - you should just say check, or check on:Check off “Management Tools – Basic” and then click Next.

  • Anonymous
    November 21, 2012
    Thanks for the great info. It is SO counter-intuitive!

  • Anonymous
    November 22, 2012
    This was very helpful!

  • Anonymous
    November 22, 2012
    The comment has been removed

  • Anonymous
    November 27, 2012
    Thank you so much for this.  It always impresses me that people take the time to provide a step by step guide. I was flummoxed by the the compatability warning and kept trying to deal with that! thanks again.

  • Anonymous
    November 29, 2012
    Very helfpul reference, used it to add Mgmt Studio to SQL 2008 Express evaluating a vendor product.  The screen shots helped greatly to see where Mgmt Studio is pulled in.

  • Anonymous
    December 02, 2012
    Thank you for a great - clear - informative tutorial.It was a fantastic help.

  • Anonymous
    December 04, 2012
    Thank you for this, step 7 kept me at bay for awhile.

  • Anonymous
    December 10, 2012
    we must to install the same version for microsoft sql server and management studio.Both, For example sql server 2008 and studio 2008

  • Anonymous
    December 10, 2012
    Hey Beth,Thanks for sharing this post, Its very helpful to me... Thanks a lot

  • Anonymous
    December 11, 2012
    Thank you ! The install could be a little bit more clearer.

  • Anonymous
    December 11, 2012
    Very helpful... Thank you very much... it helps a lot

  • Anonymous
    December 15, 2012
    I hope you and everybody realize how such a shame it is to have a complex 17 steps installation for something that should take 2 or 3 intuitive clicks. MS is doing it all wrong these last years, after many years of doing almost all good :(

  • Anonymous
    December 18, 2012
    these is very helpfull .  thank you  :)

  • Anonymous
    December 24, 2012
    hi buddy..... i have installed sql 2008 according yr instructions but now i m unable to connect datat base engine. cox i dn't have and dnt know server name.plz help me out

  • Anonymous
    January 06, 2013
    Thanks very much for the guide. Very helpful!

  • Anonymous
    January 09, 2013
    You were very right... Thanks for this.

  • Anonymous
    January 09, 2013
    Thanks. I needed this: step 7 was what kept me going wrong and made me search. Much appreciated!

  • Anonymous
    January 13, 2013
    just now tried to install sql server 2008 on my laptop. it first shows me error that compatability issue and after pressing "run program" its give me error in installation process "restart computer fails". I tried lot to solve to this problem but didn't succeded.

  • Anonymous
    January 17, 2013
    Thanks, you saved me a lot of time :-)

  • Anonymous
    January 20, 2013
    thanks

  • Anonymous
    January 24, 2013
    Thank you Beth!!  Your instructions are perfect!  Works Great!

  • Anonymous
    January 25, 2013
    I have a windows 8 OS and have installed sql server express r2 .. but stil am not able to install swl server management studio . it says compatability issues prevail .. any help on where can I get a proper file for sql server management studio for windows 8 ...

  • Anonymous
    January 28, 2013
    Great post

  • Anonymous
    February 04, 2013
    Very well explained and documented Beth.I don't think any one could install SQL Management Studio with out your notes.Thank you.

  • Anonymous
    February 05, 2013
    That was perfect to the T.  Many thanks!

  • Anonymous
    February 06, 2013
    This is a great example thanks a lot.................

  • Anonymous
    February 15, 2013
    Thank you!!  Very helpful - I was wondering what they did to the installation...  VERY unintuitive, makes you wonder if the developers ever attempt to use their own product!  ;-)

  • Anonymous
    February 16, 2013
    Years later, this is still helping people.  Helped me!

  • Anonymous
    February 17, 2013
    The comment has been removed

  • Anonymous
    February 19, 2013
    Ok, I hate to admit it, but I sat at that screen waiting for something to happen. Your big green arrow probably saved me like 10 minutes of "what are you waiting for" time.. lol  And I would also have not selected full install and picked add features.. Thank you for your time to put this out there. :) Jeff

  • Anonymous
    February 21, 2013
    I was going insane, thank you very much for your explanation!

  • Anonymous
    February 24, 2013
    Thank you very much,It is very helpful document.

  • Anonymous
    February 25, 2013
    Thanks this was really helpful.  You should translate for Microsoft.

  • Anonymous
    March 05, 2013
    Great for home usage ! Because I have Visual Studio 2010 with SQL Server 2008 Express Edition which is for home development just enough. But you don't have a tool or some GUI to easily manage your SQL Server database. And here is step by step solution how to get most important tool for me at home SQL Server Management Studio ! Finally I got it. Cool blog !

  • Anonymous
    March 05, 2013
    thanks for this. it's really helpful!

  • Anonymous
    March 08, 2013
    Absolutely outstanding! Thank You

  • Anonymous
    March 09, 2013
    Thank you so much. I've always been confused with the installation of this. You've been a tremendous help!

  • Anonymous
    March 09, 2013
    Thank you very much! Saved my day!

  • Anonymous
    March 10, 2013
    Excellent guide... worked perfectly... Including the comments on the "new install vs. feature update"...

  • Anonymous
    March 11, 2013
    Very helpful, Thank you!

  • Anonymous
    March 11, 2013
    Thanks, I should read step 7 slowly.

  • Anonymous
    March 16, 2013
    Hi,I am trying to install with your guide I come to a point that says Windows Powershell Failed, how and where do I install powershell?

  • Anonymous
    March 17, 2013
    i cannot get the server name in my installed sql 2008.can u help me in finding the server name of my sql plz....

  • Anonymous
    March 18, 2013
    This was very helpful. I performed all the "what was thought as intuitive steps" before coming here and seeing this well written article. Thanks.

  • Anonymous
    March 18, 2013
    Great job. Thank you!

  • Anonymous
    March 31, 2013
    Thank you. although I did it already in the past, this thing still confuses me..

  • Anonymous
    April 09, 2013
    Thank you for writing this step-by-step guide of installing SQL Express 2008.Are the steps for Service pack installation the same as this?  There seems to be instance configuration involved. Please help

  • Anonymous
    April 09, 2013
    Nice description. Pretty amazing way of finding the management studio :)

  • Anonymous
    April 10, 2013
    Excellent stepwise instructions.Thanks.

  • Anonymous
    April 12, 2013
    Thanx a lot.............

  • Anonymous
    April 16, 2013
    The comment has been removed

  • Anonymous
    April 18, 2013
    The comment has been removed

  • Anonymous
    April 18, 2013
    firewall doesnt block me....n i dont get the option "installation type" ?? :(

  • Anonymous
    April 20, 2013
    Hi Beth,Thanks for giving your valuable time to tell us about the installation process but i am still not able to use it.I did all the steps given here but when i am firing Sql Server from All Programs it is not giving me the option of "Sql Server Management Studio" only "Sql Server Installtion Center" is coming

  • Anonymous
    April 22, 2013
    I love your detailed step-by-step installation guide. Thanks.

  • Anonymous
    April 23, 2013
    Perfect. this was the need of the hour for me and it helped. I had a management studio free version installed on my machine, and was figuring out how to install the management studio alone in order to look at tables and data. Your article led me into venturing into alleys that have misguiding names, and finally got what I wanted. Thanks again for this nice article.

  • Anonymous
    April 24, 2013
    You are excellent!thanks

  • Anonymous
    May 06, 2013
    Thank you

  • Anonymous
    May 07, 2013
    nIce tHAnKS YoU :)

  • Anonymous
    May 09, 2013
    am not getting the option new sql server stand alone installation.....i have windows 7 of 32 bit os ...what to do...pls help

  • Anonymous
    May 09, 2013
    Very helpful, thanks!

  • Anonymous
    May 10, 2013
    Beth,  This article helped me to install Management studio on Windows 7.  I could not understand why I had to do all the steps as if I were installing the Sql Server itself.  And there is nowhere it mentioned about studio until I reached step 10.  It seems some one just copied the same process and did not change the names in the wizard it still says SQL Server not the studio.  But your article helped me to see actually it was installing studio.  I wish you have article on installing the service pack also.  

  • Anonymous
    May 12, 2013
    Thanks! You saved my life! :)

  • Anonymous
    May 14, 2013
    Awesome article ... really helped me out when I was confused as could be. The only wrinkle was that I had to also remove the 2005 Studio version in the middle of this!

  • Anonymous
    May 14, 2013
    thanxs alotttttt...this is very helpful 4 meee

  • Anonymous
    May 14, 2013
    thanks its useful and work great

  • Anonymous
    May 16, 2013
    Thought Microsoft was trying to drive me mad, then typed "problems installing sql server management studio" into Google and found this :-)

  • Anonymous
    May 18, 2013
    Great info! Thanks!!

  • Anonymous
    May 20, 2013
    Thanks so much!

  • Anonymous
    May 20, 2013
    The comment has been removed

  • Anonymous
    May 21, 2013
    I have an error:TITLE: Microsoft SQL Server 2008 SetupThe following error has occurred:Another version of Microsoft Visual Studio 2008 has been detected on this system that must be updated to SP1.  Please update all Visual Studio 2008 installations to SP1 level, by visiting Microsoft Update.please tell me what to do next?

  • Anonymous
    May 30, 2013
    Hey i have installed as per your rules and following screenshots but I have got tackled with a problem that after opening the Microsoft SQL Studio 2008 Express EditionI a msg is popping as the Server is not connectedalso the MS SQL services not getting Installedplease help me ....

  • Anonymous
    May 31, 2013
    Very helpful, thanks

  • Anonymous
    May 31, 2013
    I must simply say " THANK YOU ! " - Gotta love that one doozi that is just plain not intuitive.

  • Anonymous
    June 01, 2013
    Thank you so much. Good Work.

  • Anonymous
    June 03, 2013
    Thanks a lot!

  • Anonymous
    June 06, 2013
    Hi Beththanks a lot. But there is a problem while I've trying to run the SQL. That's the problem, stackoverflow.com/.../how-to-connect-to-local-instance-of-sql-server-2008-expressand solution given by Govardhana Reddy. But, lately discovered that Step 10, I should have checkbox the Connectivity tools too. Which is now making a problem, even while I gave my USERNAME-PC/SQLEXPRESS.Can you please share some idea, whatever it's related problem or not.  

  • Anonymous
    June 10, 2013
    Thank you very much. Very useful!

  • Anonymous
    June 10, 2013
    The comment has been removed

  • Anonymous
    June 12, 2013
    you saved my life. this is the only useful thing I've found on the internet. I dunno why Microsoft makes it so complicated..

  • Anonymous
    June 18, 2013
    Thanks a lot :)

  • Anonymous
    June 23, 2013
    thank you :) it really helps me a lot

  • Anonymous
    June 24, 2013
    You are a wonderful human being and may the computer gods shine down on you! What a dumb installer!!! Talk about not making any sense at all? Your guide was perfect and very helpful. Thanks again!

  • Anonymous
    June 26, 2013
    Thanks very much for this - saved me a major headache!

  • Anonymous
    July 03, 2013
    The comment has been removed

  • Anonymous
    July 03, 2013
    Very helpful! THANK YOU!

  • Anonymous
    July 05, 2013
    Thank you so much. I was getting stuck on "you need to select new installation, NOT add features".

  • Anonymous
    July 08, 2013
    Beth - Thank you for taking the time to break this down... this is fantastic and saved me a bunch of time... I wish I had found it sooner so I'd have less grey hair!Sondel FermerePaiges Design Group, LLCwww.epaiges.com

  • Anonymous
    July 10, 2013
    Thanks for the guide, it helps a lot !

  • Anonymous
    July 11, 2013
    The comment has been removed

  • Anonymous
    July 12, 2013
    Very similar for 2008 R2, thank you very much been racking my brain about this for a week

  • Anonymous
    July 12, 2013
    under installation rules sql server 2005 express tool has been failed.

  • Anonymous
    July 15, 2013
    The comment has been removed

  • Anonymous
    July 16, 2013
    Is SQl Management Studio 2008 requires reboot after installation?

  • Anonymous
    July 22, 2013
    fantastic post.  Microsoft really lost the wizardness of this install.

  • Anonymous
    July 22, 2013
    Thanks, Beth!

  • Anonymous
    July 23, 2013
    The comment has been removed

  • Anonymous
    July 23, 2013
    Amazing helpful... Thanks!!

  • Anonymous
    July 24, 2013
    Thank you!!!

  • Anonymous
    July 24, 2013
    Thnks a lot !! extremely helpful :)

  • Anonymous
    July 25, 2013
    Beth .. thank you ..  "install a new instance", really? I'd have never figured this out on my own.

  • Anonymous
    August 01, 2013
    Great post! That definitely isn't intuitive, and there's no way I could have done it without these instructions. You rock!

  • Anonymous
    August 02, 2013
    It's almost like Microsoft doesn't want you to use their product, isn't it?Whoever wrote this installer should be shot, along with the PM that approved it.Thanks for the help!

  • Anonymous
    August 14, 2013
    Thanks Beth,Really annoyed that what use to take me less than 5 minutes now takes forever

  • Anonymous
    August 17, 2013
    Many thanks.Microsoft seem to delight in making these things so difficult.

  • Anonymous
    August 20, 2013
    Thank you so much for this.  I was stuck at Step 7 saying exactly that "I don't want to install a new instance, just update the one I have."

  • Anonymous
    August 20, 2013
    Thank you Beth. I papped myself going through installation but your guide helped me :)

  • Anonymous
    August 24, 2013
    Thank you very much :)

  • Anonymous
    August 30, 2013
    The comment has been removed

  • Anonymous
    August 31, 2013
    A helpful Post . Thanks a Lot

  • Anonymous
    September 01, 2013
    Excellent explaination  , thanks a lot

  • Anonymous
    September 02, 2013
    thanks , it was really helpful, you saved me.

  • Anonymous
    September 03, 2013
    Extremely helpful!

  • Anonymous
    September 04, 2013
    when i take install sql server 2008 express I resive this message (error 0*80005000)what is the solution and thanks

  • Anonymous
    September 05, 2013
    I love the step by step guide to doing this.  I want to install sql server 2008 to do some training and downloaded the r2 version.  However re-reading the article I see your advice is to use the 2008 version not R2, luckily before I clicked on the button.  Should I get the 2008 version instead and is not possible to install R2 with VS2010?  Many thanks

  • Anonymous
    September 09, 2013
    Thank you for the detailed and easy to understand instructions!  Made the installation very easy!

  • Anonymous
    September 10, 2013
    thanks a lot for this support

  • Anonymous
    September 10, 2013
    Very helpful. Thanks.

  • Anonymous
    September 13, 2013
    Thanks!  I was strggling with this until I looked it up here.

  • Anonymous
    September 16, 2013
    can u pls send me slides how to install Microsoft® SQL Server® 2008 R2 Service Pack 2 in windows 7 (64 bit).

  • Anonymous
    September 17, 2013
    Thank you very much! You saved my day.(The SQL guys back at MS should really take a good look in the mirror)

  • Anonymous
    September 17, 2013
    The comment has been removed

  • Anonymous
    September 18, 2013
    Thank you very much Beth. You cannot believe how long i've been searching how to install this tool.

  • Anonymous
    September 23, 2013
    I have successfully install SQL Server according to these steps but after installation when i opened sql management studio then i needed to enter "SERVER NAME" or "User Name" or "Password".How do i find these require credentials?

  • Anonymous
    September 23, 2013
    Thanks, Beth - I was dead-ending on the installation as well and wondering why it was this impossible to just install SQL Management Studio - it was the 'new' versus 'existing' step that got me as well!

  • Anonymous
    September 25, 2013
    Thank you

  • Anonymous
    September 26, 2013
    Great, very helpful!

  • Anonymous
    October 05, 2013
    thank u very much...........its really help me very much........

  • Anonymous
    October 10, 2013
    Thanks a lot. Really helped me.

  • Anonymous
    October 10, 2013
    Lovely post.

  • Anonymous
    October 12, 2013
    URGENT!!       i have installed exactly with same steps, now i want to connect my database..how would i know what is server name, username or password.Please help its urgent

  • Anonymous
    October 15, 2013
    Thank you thank you thank you

  • Anonymous
    October 17, 2013
    Very helpful,  Thank you so much. It saved me a lot of time. Good work!!

  • Anonymous
    October 19, 2013
    Very useful and clear

  • Anonymous
    October 21, 2013
    Thanx alot...well explained....good job...:)

  • Anonymous
    October 21, 2013
    THIS IS FANTASTIC!!! I love your witticisms too :)  Keep on keepin' on Beth, you just rocked my socks off.

  • Anonymous
    October 22, 2013
    The comment has been removed

  • Anonymous
    October 24, 2013
    Thanks, very usefull article about this tricky installation.

  • Anonymous
    October 24, 2013
    Thanks a lot .. that helped a lot !!

  • Anonymous
    October 25, 2013
    Helpful tutorial...

  • Anonymous
    November 01, 2013
    Thank you very much, Thank you very much Thank you very much thank you very much

  • Anonymous
    November 03, 2013
    Excellent Explanation thks!

  • Anonymous
    November 04, 2013
    it's unbelievable how wrong this product is arranged that even veterans need such a blog to take them by the hand ...

  • Anonymous
    November 05, 2013
    Thank you, good docs..

  • Anonymous
    November 08, 2013
    Still excellent and accurate documentation some two and a half years later. Thank you!

  • Anonymous
    November 11, 2013
    The comment has been removed

  • Anonymous
    November 13, 2013
    Many thanks for this guide and I got it to work for r2 as well.  :)

  • Anonymous
    November 14, 2013
    Great stuff and so so helpful. Easy to follow thanks a mil

  • Anonymous
    November 17, 2013
    The comment has been removed

  • Anonymous
    November 17, 2013
    Thanks so much!!!  Most installs are so simple, this one however is neither easy or intuitive and I was left puzzled when I started the executable download.  Thanks again!!

  • Anonymous
    November 17, 2013
    hi Beth,good tutorial  SQL Server installation step.

  • Anonymous
    November 18, 2013
    Your instructions are very helpful. Thank you very much Beth.

  • Anonymous
    November 18, 2013
    Thanks, you got me with step 7 :D

  • Anonymous
    November 18, 2013
    hello!when i was installing microsoft sql 2008 for my windows7 os-32bit, it shown me the following error.TITLE: SQL Server Setup failure.SQL Server Setup has encountered the following error:Invoke or BeginInvoke cannot be called on a control until the window handle has been created..can u please help me

  • Anonymous
    November 19, 2013
    Thank you so much for writing this! I went through the same frustrating thought process you described before I found your write-up. This is one of the worst installers I have ever seen.

  • Anonymous
    November 21, 2013
    Great help. Thank you.

  • Anonymous
    November 22, 2013
    Thanku so much for giving this brief description...

  • Anonymous
    November 23, 2013
    I had completed with similar steps and trying to connect to my local instance, but it is throwing error

  • Anonymous
    November 25, 2013
    Thank you Beth massi. That was clear, easy to undrerestand and functional.Thank you very much

  • Anonymous
    November 26, 2013
    Great ! Saved my day. Thank you !!

  • Anonymous
    November 27, 2013
    very very useful..perfect screenshots

  • Anonymous
    November 29, 2013
    Thank you for this. I hadn't installed SQL Server tools since 2005 version, was really at lost!

  • Anonymous
    November 30, 2013
    excellent guide !

  • Anonymous
    December 01, 2013
    Great installation steps and comments.Hi Friends,I need SQL Server 2008 standard edition setup for installation, can you please share link for download it from my side. Thanks

  • Anonymous
    December 05, 2013
    They should FIRE the people responsible for this wizzard. It must have cost hundreds of thousands of man-hours all over the world, lol.And they should PAY YOU for putting up this blog.   ;-)  Thanks again, I probably would have lost ANOTHER half day if I wouldn't have found this.

  • Anonymous
    December 05, 2013
    Installed successfully  at first go... Thanks much.

  • Anonymous
    December 07, 2013
    Really really helpful...good one..thanx..I had to re-install SQL Sever several times..In every time, I had to refer this article..So I have a bookmark for this...:)

  • Anonymous
    December 08, 2013
    Awesome stuff, thank you!  This is exactly why I needed.

  • Anonymous
    December 09, 2013
    Thank you so much for sharing this! I've been looking for hours on how to install the Management Studio but could find it due to the troubling user interface of SQL Server Installation. You saved my night.

  • Anonymous
    December 10, 2013
    Thanks for your beneficial blog. May Allah guide you and rectify your affairs.

  • Anonymous
    December 10, 2013
    This is my favorite guide, no joke.

  • Anonymous
    December 10, 2013
    Thanks! Setup program is really weird.

  • Anonymous
    December 11, 2013
    Thank you very much Beth.  Your instructions are very helpful.

  • Anonymous
    December 13, 2013
    very helpful.

  • Anonymous
    December 16, 2013
    STEP 7 is so backward I never would have figured out what went wrong. Thanks for that!

  • Anonymous
    December 19, 2013
    Thank you so much

  • Anonymous
    December 20, 2013
    Your Step-by-step installation helped in installing SQL Server 2008 SP2.. Very Helpful!!

  • Anonymous
    December 27, 2013
    The comment has been removed

  • Anonymous
    January 05, 2014
    THANK YOU VERY MUCH.

  • Anonymous
    January 08, 2014
    Hi Beth,i have windows 7 and the installation is too problematic what should i do

  • Anonymous
    January 12, 2014
    Thanks for your post, the install is confusing with the 'Install new instance'  

  • Anonymous
    January 19, 2014
    Thanks alot!!!This helped me alot :) :) :)

  • Anonymous
    January 24, 2014
    Wonderful article. I just installed sql2008 64bit with help of this. Thanks again.

  • Anonymous
    January 27, 2014
    This is were I got stuck "You need to select new installation, NOT add features. I know I know, totally weird."It seems that Microsoft had a different logic :) thanks for the help!

  • Anonymous
    January 27, 2014
    Very Helpful, Beth.Description with picture very clear idea to installation.Thank you very much

  • Anonymous
    January 31, 2014
    Thanks that really helped me. I was stuck completely on this before.

  • Anonymous
    February 01, 2014
    The comment has been removed

  • Anonymous
    February 04, 2014
    I want to install only SQL 2008 R2 management studio without express edition. do you have step for it.

  • Anonymous
    February 05, 2014
    Amazing - human-readable instructions for a Microsoft installation wizard.Will you marry me?

  • Anonymous
    February 09, 2014
    this blog was really useful thank you so much

  • Anonymous
    February 09, 2014
    Straight and easy, Thanks !!!

  • Anonymous
    February 12, 2014
    Beth,Very, very helpful.Many thanks.Ken

  • Anonymous
    February 13, 2014
    Works like a charm..Thank you very much, looking for this support from so many days, thanks for the post.. :D

  • Anonymous
    February 16, 2014
    Hi brother. It was really help full but i'm getting an error at administrator name...!!!! What did i do now please tell me....???

  • Anonymous
    February 17, 2014
    Fate ridere!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

  • Anonymous
    February 18, 2014
    Where has this article been my entire life.  Thank you so much.

  • Anonymous
    February 21, 2014
    The comment has been removed

  • Anonymous
    February 21, 2014
    hii beth helful but i got error when i open ssmscannot start ssms

  • Anonymous
    February 23, 2014
    I have restart my pc then also restartpc is failed in installation process.

  • Anonymous
    February 28, 2014
    how can solve .net application security problam

  • Anonymous
    March 06, 2014
    You are a life saver! Thank you for step by step guidance.

  • Anonymous
    March 10, 2014
    The comment has been removed

  • Anonymous
    March 16, 2014
    Hello Beth,      Can you please help me in connecting to a server instance? It says cannot connect to MSSQLSERVER

  • Anonymous
    March 24, 2014
    Thanks its really helpfull.Regards

  • Anonymous
    March 26, 2014
    These are very helpful steps to install SQL Server 2008.

  • Anonymous
    March 29, 2014
    Perfectly working..Thank you so much.It saved me a lot of time. Good work!!

  • Anonymous
    March 29, 2014
    Aha! Choosing the new installation to add this 'feature'. That did it for me. Thanx

  • Anonymous
    March 30, 2014
    This introduction for install sql server is better

  • Anonymous
    April 06, 2014
    Hello Sir,I am trying from Couple of days to install SQLServer2008 then aslo i am not able to Install this.When try to install SQL 2008 By using your manual. I am Getting an error can'tfind services{0}.paramerter name: MSSQLServerADHelper 100.Could you please help to sort out this error.Please sir help me.

  • Anonymous
    April 08, 2014
    The comment has been removed

  • Anonymous
    April 14, 2014
    thank you very much...it have really help me

  • Anonymous
    April 15, 2014
    thanks alot. It realy helped

  • Anonymous
    April 19, 2014
    If i followed that above step then i will install sql server 2008 in my pc (os is 32bits).It is ok. My Question is  sql sever is working windows authentication or sql server authentication ?already i installed sqlsever2008 in pc but it is in windows authentication.Now i want run my application in sql sever authentication .How can i change windows authentication to sql sever authentication .plz help me .i need install steps for sql server 2008

  • Anonymous
    April 24, 2014
    what i need to write for server name????

  • Anonymous
    April 25, 2014
    Ohhh this is where Management Studio is hidden, I really don't know why, why Microsoft why?

  • Anonymous
    April 30, 2014
    Even in installing SQL Server 2012 Mgmt Studio, this article was most helpful in guiding me through the confusing steps even though the steps have somewhat change since SQL Server 2008. Thanks.

  • Anonymous
    April 30, 2014
    Great tutorial! Thanks a lot! :)

  • Anonymous
    May 01, 2014
    Thank you, I've worked in the MS development field for years and always dread setting up a new SQL Server on a development computer. I've not got much hair left to pull out, you walk through is a life saver!...

  • Anonymous
    May 01, 2014
    Love U so Much....Very Helpful, Beth

  • Anonymous
    May 01, 2014
    i followed all the steps correctly but now it showing an instance-specific error while connecting.......what should i do now ?????please help me.......server name ?????

  • Anonymous
    May 13, 2014
    Thank you... it was very useful

  • Anonymous
    May 14, 2014
    really helped..thanks a lot

  • Anonymous
    May 15, 2014
    Very useful thanks

  • Anonymous
    May 18, 2014
    Thanks, very helpful ^^

  • Anonymous
    May 18, 2014
    Finally some well written reference material. Well Done!!

  • Anonymous
    May 20, 2014
    Hi, BethGreat work.....Thanks for the guidance.....

  • Anonymous
    May 26, 2014
    Very useful

  • Anonymous
    May 28, 2014
    thank you very much for sharing the knowledgeable ideas with us thank you......

  • Anonymous
    May 30, 2014
    it is so nice installation step thank's

  • Anonymous
    June 02, 2014
    Thanks Nice one.. it help me alot during the installation of SQL Installation on my Dev system.

  • Anonymous
    June 03, 2014
    Thanks, very helpfull!

  • Anonymous
    June 05, 2014
    Thanking you kindly.Very clear and very helpful.

  • Anonymous
    June 09, 2014
    The comment has been removed

  • Anonymous
    June 11, 2014
    Great write up. Some of the install windows were somewhat misleading... sounding like SQL server was going to be installed when really all i needed was the management tools. Thank you!

  • Anonymous
    June 12, 2014
    Thank you so much, it helps me a lot :)

  • Anonymous
    June 16, 2014
    Thank you, why can't Microsoft provide instructions like this in the first place!

  • Anonymous
    June 27, 2014
    I've been through several forums and didn't found these steps... thanks for your steps.. it works... after several weeks of searching...

  • Anonymous
    July 09, 2014
    Thanks Beth, always found your Blogs / Posts very helpful.  If its got your name against it, I know it'll work!!

  • Anonymous
    July 09, 2014
    Thanks for the post.  Appreciate your time to make it.

  • Anonymous
    July 12, 2014
    Hi it is very nice and simply congrats man

  • Anonymous
    July 15, 2014
    This blog post needs to stay on the internet forever. This is the 3rd or 4th time I've installed SQLMS and I can never remember what to select... this article is a lifesaver!

  • Anonymous
    July 17, 2014
    Thank you so much for the post.  This got the job done while our DBA failed

  • Anonymous
    July 18, 2014
    Thanks a lot...:)it really helped me..!!

  • Anonymous
    July 21, 2014
    Thanks, Very Helpful.

  • Anonymous
    July 29, 2014
    Beth, that was fantastic. I've fought with this installer several times till I found your link.Thank you,Greg

  • Anonymous
    August 03, 2014
    Thanks! Your instructions with pictures saved me a lot of time.Best Regards,Ged

  • Anonymous
    August 11, 2014
    how to fix problem prior visual studio 2010 instances requiring update when installing sql server 2012

  • Anonymous
    August 13, 2014
    A million thanks to you!After painstakingly installing 3 sets of clustered SQL servers, I wanted to install SMSS on my desktop and seeing the same installation steps with what I believed is a straight forward process, my mind kept saying what the heck! Luckily, I found your article and it tossed out my curses. Great write-up, I'm sure a lot of aspiring DBA will be driven to this by Google.

  • Anonymous
    August 23, 2014
    Thanks!  Saved a few more gray hairs!  Puts new meaning to the term 'user-hostile', doesn't it?  HeHe!

  • Anonymous
    August 26, 2014
    Very helpful - I was failing at the 'Add Features to an Existing' step & losing what's left of my hair searching for other downloads of 2008 Mgmt Studio

  • Anonymous
    August 27, 2014
    Very useful information. This is exactly what I was looking for.

  • Anonymous
    August 27, 2014
    Hi Beth,  Very helpful instructions, thank you

  • Anonymous
    August 28, 2014
    cannot connect to.....additional information:  A network -related or instance -specific error occurred while establishing a connection to sql server.the server was not found was not accessible.verify that instance name is correct and that sql server is configured to allow remote connection.(povider:Named Pipes Provider,error:40-Could not open a connection to SQL server)(Microsoft SQL Server, Error:2).............................what is this??? how to connect db?? i'm use .(dot) & (Local) in windows Authentication bt not connect & show this msg

  • Anonymous
    August 28, 2014
    Thank you, that was very useful :-)

  • Anonymous
    September 02, 2014
    TITLE: Connect to ServerCannot connect to ./SQLExpress.ADDITIONAL INFORMATION:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 3)For help, click: go.microsoft.com/fwlinkam getting the above error.kindly help me solve this

  • Anonymous
    September 02, 2014
    How can we install the Profiler (Management Tools - Complete) option in SSMS 2008 R2.

  • Anonymous
    September 05, 2014
    Thank you very very much ! you explained everything better than Microsoft !!

  • Anonymous
    September 07, 2014
    Very helpful and self descriptive documentation.Great work!

  • Anonymous
    September 08, 2014
    Very good instructions.  Thank you..

  • Anonymous
    September 11, 2014
    Hi, thanks for that nice stepper!Cheers Martin

  • Anonymous
    September 14, 2014
    Thank you so much. I almost had to drop a course if i couldn't figure this out. You're very good at writing guides.

  • Anonymous
    September 18, 2014
    hey !!!!  Is the any Suggestion to add formatting tools in SQL Server 2008 RTM?????

  • Anonymous
    September 26, 2014
    Please help me i have don't install my sql server in my pc because problem with setup support rules that is show me restart computer failed (A computer restart is required. You must restart this computer before installing SQL Server.) please reply me quickly .

  • Anonymous
    September 28, 2014
    Thanks man, I was stuck at exactly same point. Good article!

  • Anonymous
    October 02, 2014
    TITLE: Microsoft SQL Server 2008 R2 SetupThe following error has occurred:Could not write value  to key SOFTWARE.   Verify that you have sufficient access to that key, or contact your support personnel.

  • Anonymous
    October 09, 2014
    The comment has been removed

  • Anonymous
    October 10, 2014
    I have installed sql server 2008 & created database which i was using on sql 2000 & connected the clients & also created odbc successfully. On using the software at front end i ocasionally receive a message"connection failed:Sql state:'01000'Sql server error:11[microsoft][odbc sql server driver][dbnetlib]connectionRead(recv()).Connection faild:Sqlstate:'08501'Sql server error:11[microsoft][odbc sql server driver][dbnetlib] general network error. Check your network documentation."Pl help

  • Anonymous
    October 12, 2014
    Aha! i was wondering why i am unable to install management studio express. the trick was to select new instance! you made my day Cheers!

  • Anonymous
    October 16, 2014
    Thank you Beth. Your articles are always very welcome.

  • Anonymous
    October 17, 2014
    i'm stuck on step 10. i couldn't check nor uncheck anything and it wouldn't let me to proceed to the next step

  • Anonymous
    October 28, 2014
    Thank you so much !

  • Anonymous
    November 05, 2014
    It is really very helpful.Thank you Beth! :)Regards,Ankit

  • Anonymous
    November 09, 2014
    hai man,Iam totally new to SQL server. Please can u guide me on my dout.Which of the below two should i install. Iam getting similar window on both of them. What is the difference between the two. Can any one answer.SQLEXPR_x64_ENU SQLManagementStudio_x64_ENU  

  • Anonymous
    November 10, 2014
    I really enjoyed this procedure very much, very big thanks to you

  • Anonymous
    November 26, 2014
    What is the Default Login Id and Password??

  • Anonymous
    November 28, 2014
    Hi Beth,Really It was help me to do my work. Since I watched so many videos in the Internet I am unable to find a solution. and unable to install the software. I am so happy . Really you did a good job by helping like this. And it seems like  that you take big effort for give a success solution like this. You use screen shots descriptions even you mention the time duration too.So Thank you very much for the support. Thank you once again.

  • Anonymous
    November 28, 2014
    Beth I only installed Visual Studio 2010 Do I need to install the SQL Server 2008 too..?

  • Anonymous
    November 29, 2014
    Very helpful. Thank you.

  • Anonymous
    November 30, 2014
    I got this error on giving server name as local. Please tell me what i need to do..?TITLE: Connect to ServerCannot connect to local.ADDITIONAL INFORMATION:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)For help, click: go.microsoft.com/fwlinkBUTTONS:OK

  • Anonymous
    November 30, 2014
    When i connect Enterprise manager it shows error that " You must use sql server management studio " i have installed sql server management studio & installed it but it is not working......please help.......

  • Anonymous
    December 03, 2014
    thank u beth.this is very helpful.

  • Anonymous
    December 05, 2014
    It's amazing to me that years later this is still a relevant post.  I used this to navigate through by 2012 install.  However I could really use a similar post - because for the life of me I can't figure out the SP2 upgrade.

  • Anonymous
    December 06, 2014
    Thank you so much,it was really a great help:)

  • Anonymous
    December 06, 2014
    It is very helpful to install the SQL server.Thank you!

  • Anonymous
    December 08, 2014
    very heplfull articles

  • Anonymous
    December 20, 2014
    Nice Article written such way that, even novice users also can install SSMS

  • Anonymous
    January 02, 2015
    dude thanks a lot... because, i honestly couldn't have figured it out on my own, i even pressed on the "... or add features to an existing installation" but stopped just afterwards... it's very NOT intuitive ... the whole experience...Thanks anyway

  • Anonymous
    January 11, 2015
    Oh my goodness, this is amazing. Thank you so much for this. I kept trying to figure out where they heck I was going wrong when I was trying to "add features" rather than do a fresh installation. You're right; it doesn't make any sense!

  • Anonymous
    January 13, 2015
    thanks! the 'new install' option is a killer!

  • Anonymous
    January 14, 2015
    thanks....

  • Anonymous
    January 16, 2015
    Really this step help me.. thanks to you....

  • Anonymous
    January 16, 2015
    very cool

  • Anonymous
    January 18, 2015
    thank you very much

  • Anonymous
    January 20, 2015
    Thank you.  This article explains some of the inordinate problems I've had with this laptop and another workstation, not just in getting the Management Studio to work but in dealing with repeated update failures.  Now, having been given opportunities, through catastrophic hardware failure, to rebuild both, I'm gonna get it right.  

  • Anonymous
    January 21, 2015
    I am facing compatibility issue while installing SQL Management Studio 2008 on Windows 8.1. Kindly assist.I am ready to install everything from scratch. I don't need VS.Thanks

  • Anonymous
    January 24, 2015
    Iam installed sql server 2008 n management studio but im not getting the sql workbench ...plz provide the detail information plzz...#

  • Anonymous
    January 29, 2015
    Very good!

  • Anonymous
    February 01, 2015
    Thank you! You saved a lot of my hair.

  • Anonymous
    February 09, 2015
    Perfect Beth. Thanks.

  • Anonymous
    February 12, 2015
    Dear,very helpful steps shown .pictures make esay instalation

  • Anonymous
    February 16, 2015
    what should I do when my system failed  in step 6

  • Anonymous
    February 17, 2015
    thank u          thank u             thank u            thank u             thank u           thank u          thank u...........  !!!!!!!!!!!

  • Anonymous
    February 17, 2015
    Oh, thank you thank you thank  you for this!  The "new install" trick does not seem easy to find.

  • Anonymous
    February 19, 2015
    Thanks. It was very helpful. I spent half an hour not coming to the idea that I have to select "new installation"

  • Anonymous
    February 22, 2015
    This is very useful for me.I hope post more tutorials and tips

  • Anonymous
    March 01, 2015
    Great post - helped me a lot !Thanks, Beth :)

  • Anonymous
    March 04, 2015
    Very thank you.it is very clear and helpful.

  • Anonymous
    March 07, 2015
    Thank you, thank you, thank you. Was wrestling with this all day yesterday. Very counter intuitive, but that's the great gift of the internet and people willing to help others in our struggles.

  • Anonymous
    March 11, 2015
    Thanks, Beth. Selecting "add features" instead of "new installation" got me this time (probably again). Long time before last installation so tend to forget. What a piece of brainfart installer.

  • Anonymous
    March 12, 2015
    This was really very helpful. Thanks a ton :) :)

  • Anonymous
    March 14, 2015
    yes,its work thank you to sharing this steps .............

  • Anonymous
    March 16, 2015
    Thanks Beth,It is a very simple and useful instructions. Never think the 'Perform a new installation of SQL Server 2008' can install the Management Studio.Save a lot of our time and resources as other mentioned.Tommy

  • Anonymous
    March 18, 2015
    It was good and helped me alot!!!

  • Anonymous
    March 18, 2015
    Very useful, very helpful.Thank you very much Beth.I have tried many times to instal SSMS before but unsuccesfully.Finaly I got it, you are my hero!

  • Anonymous
    March 19, 2015
    Thank you !Very helpfulGreat article !

  • Anonymous
    March 24, 2015
    Hi,   beth i have window-7 with 32 bit & i want to install "SQL Server Management Studio 2008 Express"   What should i do???? means,, how could i get this in my system with 32 bit????   Please do the needfull...

  • Anonymous
    March 24, 2015
    This very useful  to  me

  • Anonymous
    March 31, 2015
    Thank you for the detailed tips, Beth!

  • Anonymous
    April 06, 2015
    Thank you for the post. It helped me to actually get some work done today

  • Anonymous
    April 09, 2015
    after installing sql server 2005 and management studio i cannot create database in  management studio, displaying an warning" cannot create database permission denied in database 'master' "

  • Anonymous
    April 10, 2015
    This was hugely helpful, thanks Beth! I definitely wouldn't have figured this out without instruction. I thought I'd downloaded the wrong thing...

  • Anonymous
    April 12, 2015
    Thanks man !This helped me a lot to install on my PC-window 7.I have gone through many websites, but finally this helped me.Thanks once again :)

  • Anonymous
    April 18, 2015
    thank you very much !

  • Anonymous
    April 22, 2015
    thanks,worked...  :-D

  • Anonymous
    April 22, 2015
    Very helpful, thanks a lot

  • Anonymous
    May 01, 2015
    Thanx it is very helpful

  • Anonymous
    May 06, 2015
    still error in connecting with my PC name :(

  • Anonymous
    May 12, 2015
    Thank you for helping me.

  • Anonymous
    May 15, 2015
    it wants from me password..what to do?

  • Anonymous
    May 18, 2015
    Thanks....very much helpful.....

  • Anonymous
    May 26, 2015
    appreciate your efforts in bringing this up...

  • Anonymous
    May 27, 2015
    Very helpful, could clearly understand all the steps.

  • Anonymous
    June 01, 2015
    This is great, Beth! It saved a lot of time. Thanks

  • Anonymous
    June 03, 2015
    Thank you very much sir .. it realy helps me allotttttttttttt..........Thanks again

  • Anonymous
    June 14, 2015
    Beth, this is fantastic!  I've struggled with this setup before and I always gave up.

  • Anonymous
    June 18, 2015
    The comment has been removed

  • Anonymous
    June 26, 2015
    Really tks

  • Anonymous
    June 27, 2015
    Very very helpful, Many Thanks

  • Anonymous
    June 28, 2015
    thank q so much ................its help me lot

  • Anonymous
    July 01, 2015
    It really helps! =)

  • Anonymous
    July 01, 2015
    Thank you !! This really helped :)

  • Anonymous
    July 01, 2015
    hi guys ! i have a problem with feature selection in sql management studio 2008 both the options in shared features are hidden when i click next so it gives error that there is a validation error on this page what i should do. i am using window 8.1

  • Anonymous
    July 03, 2015
    I am unable to check any of the options on "Feature Selection" and hence unable to proceed. Please help.

  • Anonymous
    July 04, 2015
    provider: Named Pipes Provider,error:40 could not open a connection to SQL Server

  • Anonymous
    July 06, 2015
    Thank you so much. It saved me a lot of time. Good work!

  • Anonymous
    July 12, 2015
    Very useful. I easily install SQL 2008 by this

  • Anonymous
    July 21, 2015
    I ´m trying install SQL Server Management Studio 2008. Every works well, but I need add another local account as Administrator on SQL SERVER 2008. Can you help me? Thanks!

  • Anonymous
    July 23, 2015
    Perfectly described....  

  • Anonymous
    July 26, 2015
    Good job, and thanks a lot ;-)

  • Anonymous
    August 05, 2015
    Your kind step-by-step instruction was really helpful for me to install SQL 2008 Management Studio after having had so many failures to do it. Thank you so much.

  • Anonymous
    August 12, 2015
    Thank you very much for this tutorial!

  • Anonymous
    August 13, 2015
    It was very helpful. Thank you very much.

  • Anonymous
    August 16, 2015
    thank u soo mcuh! great healp

  • Anonymous
    August 16, 2015
    Thank you. It helped me lot.

  • Anonymous
    August 27, 2015
    How to is very good. Sucess total in instalation of ...stuido SQL EXpress

  • Anonymous
    August 31, 2015
    Thank You for this...   but I have  a question if it is Ok with you... in the check rule in windows firewall, you said that it is ok because you used sql server only in your machine. but what if I Installed the MSSQL 2008 not only for my machine but also for others that is connected in my machine??  in a small network...  thank you....

  • Anonymous
    September 03, 2015
    As I was searching a readymade steps for my students to whom I am teaching SQL Server 2008 so it spared my time to type and prepare an installation document/guide for my students.Thanks

  • Anonymous
    September 08, 2015
    great helpful!!thank you so much!

  • Anonymous
    September 09, 2015
    thanks a lot dude..very helpful!!

  • Anonymous
    September 13, 2015
    Thank you for this! It was a lifesaver. You're right about how nonintuitive it was at step 7. :(

  • Anonymous
    September 16, 2015
    i have    downloaded   but  getting   in  installing

  • Anonymous
    October 04, 2015
    very helpful. this is a great example  thanks

  • Anonymous
    October 24, 2015
    it was best procedure for sql server installation.it provided a huge help in installation.thank a lot      to you

  • Anonymous
    November 01, 2015
    I can not find the management tool - basic in the features list during an install of sql manager studio 2008

  • Anonymous
    November 04, 2015
    Great article I can just said it was Excellent. This year I succeed in the intallation at the first round following guidance you provided in this article. Thanks again

  • Anonymous
    November 25, 2015
    Exactly what I was looking for. Very pleased with the contents

  • Anonymous
    December 01, 2015
    i always use this article, i when ever i install sql exp this page is always help full.

  • Anonymous
    January 07, 2016
    I am satisfied this installing sql server managment studio ,just fine

  • Anonymous
    January 10, 2016
    thank you very very very very helpful

  • Anonymous
    January 14, 2016
    I struggled on and off for two weeks thinking I had downloaded the wrong file and that I was about to mess up my server configuration.  Your page helped me understand that it is a really horrible interface and I just needed to plow ahead despite the conflicting messages.   Thanks for taking the time to write it up and convince me that I could get this tool install.  Surprised that Microsoft's installation instructions aren't a little more upfront with the steps.

  • Anonymous
    January 19, 2016
    Dear Sir/Madam Very Good ,SQL server very easy.

  • Anonymous
    January 23, 2016
    Very help full in installation of sql server thnx thnx a lot

  • Anonymous
    January 26, 2016
    I know it's old, but great post and thanks for taking the time!  

    • Anonymous
      March 31, 2016
      This really help. To the author thanks for sharing this manual. Thank you.

  • Anonymous
    February 04, 2016
    The comment has been removed

  • Anonymous
    February 18, 2016
    Thank you.Greate post

  • Anonymous
    February 25, 2016
    this is great and very helpful. a lot... Thanks

  • Anonymous
    March 28, 2016
    HI YOUR POST IS REALLY HELPFULL THANKS

  • Anonymous
    April 01, 2016
    i have installed ms sql server 2008 R2 and it has been installed successfully after a long struggle :( but i can't find SSMS in its files. can anybody plz help me in this regard ?

  • Anonymous
    April 02, 2016
    Thank you so much..............its really helped me lot :)

  • Anonymous
    April 13, 2016
    Thank you. Very helpful.

  • Anonymous
    April 14, 2016
    THANK YOU VERY MUCH BRO ITS VERY USE FULL THANKS AGAIN

  • Anonymous
    April 22, 2016
    Great Article .Simple :-)

  • Anonymous
    April 27, 2016
    Very simple and excellent guide for freshers

  • Anonymous
    April 29, 2016
    I'm confused why you say that if we installed VS 2010, then we want SQL Server 2008, not 2008 R2. Can anyone add more about that? I have a project which started with VS 2008, upgraded to VS 2010, and (I think always) has been using SQL Server 2008 R2. I came here trying to get install steps for a new dev machine for the project, so I'm curious if there is some gotcha I'm not aware of. I was thinking of referring to the steps in this article but installing 2008 R2 not 2008 - this article says that's wrong, but not how/why it's wrong.

  • Anonymous
    May 29, 2016
    Beth, What a fantastic article. Seldom do I see an article on technical issues so well written, in normal humorous human-speak instead of jargon. My attempt at installing stuff failed 4 times in a row, then went 'textbook' - typical!Thanks, though - couldn't have got to operational without you.

  • Anonymous
    June 13, 2016
    Hi there,I followed the exact same steps provided by you to install SQL Server 2008 management studio but when opening studio and trying to connect I am getting Error TITLE: Connect to Server------------------------------Cannot connect to .\SQLExpress.------------------------------ADDITIONAL INFORMATION:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476I am not getting Instance selection option while installing SQL Server. How to solve this error.Also I fire up SQL server Configuration manager to see if SQL server service is running...But I am not getting anything there as well totally blank..Please help me to solve this.I installed SQLManagementStudio_x64_ENU and I just want for learning purpose..Thanks

  • Anonymous
    June 23, 2016
    Hi, Here is my question...i am planning to install a SQL Server on Windows 2012 and install sql mgmt studio on user's desktops.Each user (desktop) can be able to connect to their respective database?doing this i can avoid the more number of sql server licPlease suggest

  • Anonymous
    August 03, 2016
    Beth Thanks for putting this out here. My Cat could follow these instructions. You are great.Thanks

  • Anonymous
    August 20, 2016
    I am unable to see Management tools basic under feature tab Please help

  • Anonymous
    August 24, 2016
    i had a error while Connect the Sql server after successful installation ,, pls help mei got a error like Network instance error

  • Anonymous
    September 21, 2016
    Hi bethI have installed SQL server 2008 on windows 8 but management studio could not be installed its asking for .net framework 3.5(include 3.0 2.0) even 4.5 is already installed on my pc, will you help me solve this problem

  • Anonymous
    November 21, 2016
    After clicking new standalone installation, in the Feature selection menu, they force me to select one Instance Feature along with the automatically selected Shared Features. So after selecting Instance Feature they prompt me it a new menu called Server Configuration please help me with that.

  • Anonymous
    December 28, 2016
    thank you very much for this article. 1 question for Microsoft WHY ?????????WHY ?????????WHY ?????????

  • Anonymous
    January 18, 2017
    The comment has been removed

    • Anonymous
      March 10, 2017
      The comment has been removed
      • Anonymous
        July 24, 2017
        Hi Jim,i was follow your above instruction but it did not work. have your any other way to connect? actually i was trying from last 2-3 months but can't solve it.

  • Anonymous
    February 05, 2017
    Thanks a loti have solved my problem.Thanks :)

  • Anonymous
    February 16, 2017
    It is an excellent tutorial.I am sure, it is very old. It is sql server 2008 and now it is 2017. But it is still good.Thanks.

  • Anonymous
    March 10, 2017
    Thank you so much, Beth!! Yes, this may be an old blog but today I totally missed step 7... and of course, nothing came out right. Spent WAY too much time trying another method (or 6) but now... finally... the ssms is running on this old server and I can begin my transfers. Holy Mother of Pearl... Take care!

    • Anonymous
      May 19, 2017
      thank's

  • Anonymous
    July 16, 2017
    it is showing an error like it is unable to load management tools after installation

  • Anonymous
    July 18, 2017
    The comment has been removed

  • Anonymous
    July 24, 2017
    Your instructions is very useful but i'm facing one more problem. After the SQL Server installation i cannot login Windows Authentication mode. Please advice how can i login.

  • Anonymous
    July 29, 2017
    Hi BethIam still a very new student on Web Development. I have endless problems with SQL servers and Visual Studio.Ive been work with VS 2012 it has been working very well....Untill i start do down load SQL server to do database.The SQL servers somehow make my VS2012 stop working. My vs2012 keeps asks me to repair it, so i have but stillnothing it keeps asking me the same. Then i have Uninstalled the VS 2012 and Re-installed it and still nothing. I end up to Reset my whole computer. So the i have installed VS2012 again. It was working again , until i have installed SQL server again. I have installed SQL 2012 for my VS2012 and it keeps on doing the same over and over again. Now i don't know if its got anything to do with im using windows 10? Or is there any changes i have to do when i installing SQL server. Im not even sure if i download the correct downloads . I use to download sql2012 64x express. Any good advise will be appreciated.

  • Anonymous
    August 09, 2017
    The comment has been removed

  • Anonymous
    December 11, 2017
    Kids toys and games at reduced prices available from ToyShopSale.com

  • Anonymous
    December 12, 2017
    The comment has been removed

  • Anonymous
    December 14, 2017
    After click on "New SQL Server stand-alone installation or add features to an existing installation” it asking for installation folder.so which folder i will select for installation.

    • Anonymous
      January 13, 2018
      in step 10 my selection button is not working . .. what should i do for it???

  • Anonymous
    January 13, 2018
    in step 10 my selection button is not working . .. what should i do for it????

    • Anonymous
      January 13, 2018
      someone reply plz