March 13, 2008 at 3:03 pm
Can the full version of SQL Server Management Studio be installed anywhere in addition to the SQL Server? Currently we have SQL Server Management Studio Express installed on a couple local PCs to access the db administration -- but it lacks some features of the full version. Can't seem to find any answer as to if the full version can be installed ONLY on the server. Seems like that's the case. Is it??
Thanks,
Ron
March 13, 2008 at 3:38 pm
Can't seem to find any answer as to if the full version can be installed ONLY on the server. Seems like that's the case. Is it??
This depends on your licensing. I would recommend that you install Standard on the server and buy the developer edtion for each of your computers. The developer edition has all the features of Enterprises Edition and only costs $50.00.
March 13, 2008 at 3:48 pm
Not sure if I got it right.
I did install the Client Utility which include SSMS on workstation which is running WinXP SP2. I didn't have problem with that, or may I miss something.
Good luck.
March 13, 2008 at 4:03 pm
It looks like Adam answered a different question than was asked.
You can install the CLIENT TOOLS (SQL Server Management Studio) on a desktop or the server.
You can only install the DATABASE ENGINE on the server, unless it is a version that is permitted to be installed on a desktop.
CLIENT TOOLS do not have to be licensed.
The DATABASE ENGINE install must be properly licensed.
-SQLBill
March 13, 2008 at 5:34 pm
It looks like Adam answered a different question than was asked.
You can install the CLIENT TOOLS (SQL Server Management Studio) on a desktop or the server.
You can only install the DATABASE ENGINE on the server, unless it is a version that is permitted to be installed on a desktop.
CLIENT TOOLS do not have to be licensed.
The DATABASE ENGINE install must be properly licensed.
I have to be honest, I skimmed through the post and read the keywords: SQL Express and lacking features.
SQL Bill, is correct. The client tools are not licenseable, only the database engine. You can install just these components onto your pc.
Thanks.
March 13, 2008 at 7:18 pm
Thanks for the info. I'm quite new to SQL -- where do I find the client tools to install on my desktop?
Thanks,
Ron
March 13, 2008 at 8:24 pm
Put in the SQL Server 2005 disk. The client tools are in the setup and are called workstation components. Install only the workstation components.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply