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

"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?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.

hmaynordAuthor Commented:
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?
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.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
hmaynordAuthor Commented:
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Server Hardware

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.