sbs 2008 premium - running sql management tools on a client computer

Posted on 2011-10-02
Last Modified: 2012-05-12
"If you install SQL on the first server then you must install the management tools on another machine."

In a later part of the same MS article that contains the quote above, it states that the tools must run on "another server."
We have 5 users, all running Windows XP SP3.  We must have sql.

I already have the new box for SBS 2008 Premium, and from what I have read, it has has all of the hardware components needed to run all of SBS 2008 premium, including sql, on that one box.  I don't want to purchase any more new hardware.

Question:  can I run the sql management tools on one of the client computers that is running Win XP SP3?
Question by:hmaynord
    LVL 7

    Expert Comment

    Yes you can. You can also run the management tools on the server.

    Management Studio Express 2005 is already installed on the SBS 2008 Premium Server, so unless you install the 2005 tools first you wont be able to install the 2008 tools actually on the server.

    We do this all the time, and its quite safe to do.


    Author Comment

    Thank you, tharsten.  Just to make sure I understand:

    1.  So, on the same box, you end up with all of SBS 2008 (standard), SQL Server 2008 for Small Business, and Management Studio Express 2005; and you use Management Studio Express 2005 to manage SQL Server 2008?

    2.  As far as installing Management Studio Express 2005, is it already there as a part of a normal install of SQL Server 2008 (without the 2008 management tools), or is installing it a separate second step, after a normal install of SQL Server 2008?

    3.  After that, if you want to install the 2008 tools, you can do so, but you could just stay with the 2005 tools and be finished.

    4.  What is MS trying to tell us that we can't do, with the "install the management tools on another machine" business?
    LVL 7

    Accepted Solution

    1) No, you end up with SBS 2008 Standard, SQL Server 2008 for Small Business, and after removing SQL 2005 Express Management studio (ie the tools) you end up with the proper SQL 2008 management studio.

    The only reason the tools/management studio 2005 is installed is to manage the installed instances for sharepoint, monitoring etc. You can use the 2008 studio to manage them if you need to, so its not needed.

    2) Management studio express 2005 is already installed as part of SBS 2008, you can remove these as you dont need them. Once you have removed them, you can install the full SQL 2008 SBS and it will install the SQL 2008 management tools. Id you don't remove the SQL 2005 tools, it will not install the 2008 tools.

    3) No again, you do not need the 2005 tools.

    4) I suppose they don't want people uninstalling the built in 2005 instances by accident.


    Author Closing Comment

    I would have been satsfied with a simple yes to my original question, but you took the time to go beyond that and describe an even better alternative, and I will use it.  Thanks.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    The 6120xp switches seem to have a bug when you create a fiber port channel when you have a UCS fabric interconnects talking to them.  If you follow the Cisco guide for the UCS, the FC Port channel will never come up and it will say that there are n…
    Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
    This video discusses moving either the default database or any database to a new volume.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now