Management Studio on client
I have an instance of SQL Server 2005 running on a server. I know that Management Studio is available to me on the server through Programs.
What do I need on my client computer used for development to access the instance on the server? Is it as simple as a shortcut to the server Management Studio exe? Do I access it through Internet Explorer? Or what do I have to install on the client to be able to manager the server DB's?
Apparently this must be very easy because I've looked all over and can't find the answer. Thank you in advance.
[560 byte] By [
koknc] at [2007-12-23]
Use the SQL Server installation CD, and choose the "Install Client Tools" options. At least you'll need to install client connectivity, and if you want the query editor, and other development tools, then you'll need the Management Studio.
I don't think it's just as simple as creating a shortcut link to the management studio EXE file on your server, you're best off installing it properly.
installed client components, as per description, client connectivity but there is no management studio only 2 tools: 'Surface Area Configuration' and '...Configueation Manager' - it doesn't realy help!
I'd like to have the management studio on client ... how can I get it?