<div>
Yes you can. You can also run the management tools on the server.<br />
<br />
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. <br />
<br />
We do this all the time, and its quite safe to do. <br />
<br />
<br />
<br />

</div>


<div>
Thank you, tharsten. &nbsp;Just to make sure I understand:<br />
<br />
1. &nbsp;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?<br />
<br />
2. &nbsp;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?<br />
<br />
3. &nbsp;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.<br />
<br />
4. &nbsp;What is MS trying to tell us that we can't do, with the &quot;install the management tools on another machine&quot; business?
</div>


<div>
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. &nbsp;Thanks.
</div>


<div>
<div class="content wysiwyg-content">
&quot;If you install SQL on the first server then you must install the management tools on another machine.&quot;<br />
<br />
In a later part of the same MS article that contains the quote above, it states that the tools must run on &quot;another server.&quot;<br />
We have 5 users, all running Windows XP SP3. &nbsp;We must have sql.<br />
<br />
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. &nbsp;I don't want to purchase any more new hardware.<br />
<br />
Question: &nbsp;can I run the sql management tools on one of the client computers that is running Win XP SP3?<br />

</div>
</div>


"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?


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

Servers are computing devices that are similar to desktop computers in that they have the same basic components, but are significantly different in size, configuration and purpose. Servers are usually accessed over a network, and many run unattended, without a computer monitor, input device, audio hardware or USB interfaces. Many servers do not have a graphical user interface (GUI), and are configured and managed remotely. Servers typically include hardware redundancy such as dual power supplies, RAID disk systems, and ECC memory, along with extensive pre-boot memory testing and verification. Critical components might be hot swappable, and to guard against overheating, servers might have more powerful fans or use water cooling.