How to give access to SQL 2005 client tools, for power user

Question

Post reply

How to give access to SQL 2005 client tools, for power user

klaur

SSC Veteran

Points: 236
More actions
September 3, 2008 at 12:32 pm

#123297

I have a couple of users who had Enterprise Manager on their desktop. I have now upgraded their network database and server from 2000 to 2005.
What should I install on their desktop, so they can manage their new 2005 database ?
I know I can only install Management Studio from our full version of SQL Server 2005, but do they then take up a license ?
or is a better route to install free SQL Express on their desktop, so they can manage their database that way.
Thank you very much for your input.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Adam Bean One Orange Chip Points: 26631 More actions · Answer 1

You can install the client tools without having to license SQL.

koln SSCrazy Points: 2189 More actions · Answer 2

Thank you...we have the SQL 2005 DVD contents on the network, and I hate to copy the whole thing to a users desktop, only to install Management studio...is there some sort of .msi file I can create, or use ?

Glen SSCertifiable Points: 6737 More actions · Answer 3

Glen

SSCertifiable

Points: 6737

September 3, 2008 at 1:51 pm

#866784

Try SqlRun_Tools.msi in Tools\Setup folder.

klaur SSC Veteran Points: 236 More actions · Answer 4

tried that, but the install did not like just having the .msi file...error msgs that I received were somewhat cryptic, but I believe it was looking for other files as well.

Any other suggestions out there ?...otherwise, it looks like I have to copy the whole DVD over to a users desktop

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 5

You can run the install from the network location where you copied the DVD contents. If that is not an option (bandwidth issues?), then I would recommend copying the install media to a portable USB drive and install from there.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

Ron McCullough SSC Guru Points: 63877 More actions · Answer 6

or is a better route to install free SQL Express on their desktop, so they can manage their database that way.

.

Carefully check SQL Express SSMS it is lacking a great deal of capability, for example can not invoke Import or Export Wizard, be sure the limited capability you are giving them with Express is what they really need.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Glen SSCertifiable Points: 6737 More actions · Answer 7

Cryptic message could be caused by two separate issues:

1. When DVD contents was copied, the folder attributes are still set to "Read only" rights.

2. Network rights of an end user.

It is always recommended to copy msi package locally; check that it is not set to Read only and then run it on the client machine.