Post reply

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

  • 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.

  • September 3, 2008 at 12:33 pm

    #866724

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

  • September 3, 2008 at 1:42 pm

    #866778

    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 ?

  • September 3, 2008 at 2:20 pm

    #866799

    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

  • September 3, 2008 at 2:27 pm

    #866802

    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

  • September 3, 2008 at 2:39 pm

    #866808

    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]

Viewing 6 posts - 1 through 6 (of 6 total)

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