deploy management studio to users

22 Oct 2006 4:26 PM

vision

is there a way to deploy only the workstation tools? Can I create an msi or
sms package to install only the tools I need for users to have? Can I lock
down the interface so all options are greyed out other than workstation tools?

23 Oct 2006 10:46 PM

Warren Brunk

There are several different ways that you can do this all made super easy by
SQL 2005.

I dont need to waste my time writing the steps since someone wrote a really
nice blog...

http://www.databasejournal.com/features/mssql/article.php/3611426

--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
Tech Blog - www.technologyis.com
*/

Show quote

"vision" <vis***@discussions.microsoft.com> wrote in message
news:9A3263B3-DA01-4DF8-B23A-142B6094F095@microsoft.com...
> is there a way to deploy only the workstation tools? Can I create an msi
> or
> sms package to install only the tools I need for users to have? Can I
> lock
> down the interface so all options are greyed out other than workstation
> tools?
>
>

2 Nov 2006 11:17 PM

vision

thanks, I found that and followed the steps. the only thing is it also
installs configuration manager. we only want to install management studio.
I tried removing all except for sql tools and still the same result

thanks for your time.

Show quote

"Warren Brunk" wrote:

> There are several different ways that you can do this all made super easy by
> SQL 2005.
>
> I dont need to waste my time writing the steps since someone wrote a really
> nice blog...
>
> http://www.databasejournal.com/features/mssql/article.php/3611426
>
>
>
>
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> Tech Blog - www.technologyis.com
> */
>
>
> "vision" <vis***@discussions.microsoft.com> wrote in message
> news:9A3263B3-DA01-4DF8-B23A-142B6094F095@microsoft.com...
> > is there a way to deploy only the workstation tools? Can I create an msi
> > or
> > sms package to install only the tools I need for users to have? Can I
> > lock
> > down the interface so all options are greyed out other than workstation
> > tools?
> >
> >
>
>
>