SQL Server Tools Setup?

Question

Hi,

I've been asked to give an outside entity access to my SQL server database.  We use Citrix and I thought I should be able to install the SSMS on the Citrix server and give them access that way.  I did some reading on installing the SSMS and tried running the sqlrun_tools.msi but I get an error message, it reads:

0:Watson 1:1807 2:StreamSupportFiles
3:getBootStrapDirectory 4:3
5:t:\yukon\sql\setup\drawin\sqlcastub\catarget.cpp 6:100
7:sqlcastub.dll 8:sqlrun.msi

When I hit the Ok button I get the following message:

A valid destination folder for the install could not be determined.

Any idea what any of this means?  Normally MS installs allow you to set the destination folder but this install doesn't get this far.

Any other suggestions?

Thanks in advance,

Linn

Answer 1

Have performed more testing and have found that I can successfully install the express edition of SSMS or SSMSE I guess.  I'm wondering now if there is a standalone installation of the client tools for SQL server 2005?  I searched Microsoft's download section but didn't see anything like it.

Any thoughts?  I'm testing on Windows XP Pro sp3 and Windows 2003 Server sp2.

Thanks,

Linn

Answer 2

If you have media for SQL Server setup, you can choose to install **management tools** by running setup.

Otherwise, besides management studio for SQL express there is no other published download available over the internet only for management studio for SQL server

 

 

Answer 3

There is not a standalone installation package for the normal edition of SSMS. It is included in the SQL Server setup CD. There are two folders in the CD, Servers and Tools. Basically Tools folder contains what is SSMS. However, it is not supported to install from only the Tools folder. When you install, you need to make sure both folders present. You then can run the setup and choose to install workstation components.

Answer 4

I'd guess this is long ago solved for the OP, but if anyone else has problems with this, make sure IIS is installed on the target prior to installing the SqlRun_Tools.msi.

The issue I had was with installing the SQL 2008 Management Studio on a PC, but installing only the SQL 2005 BIDS - we have a SQL 2005 Reporting Services installation and the 2008 BIDS won't work with it.

On XP, make sure you disable SMTP unless you really want a mail server working on the target as well!