June 26, 2008 at 12:05 pm
Hi,
I am attempting to create a silent install of the SQL 2005 Tools for end users who need to access databases. All that is needed is the Management Studio. I have created an silent command line, but this installs all tools. I do not want tools like Analysis services, the configuration tools and others.
One solution I had hoped would work was using the Management Studio Express version. This was very promising, however one major component/feature is not available. My users need the ability to import/export from the GUI. BCP is not a good option for the users that need this feature.
So, is there a more granular way to install the SQL tools to only include Mgmt Studio?
Thanks in advance for any help.
Brian
June 26, 2008 at 12:14 pm
I know how to do it from within installation wizard, but haven't looked into a command line for it. But since it can be done from the installation wizard, there probably is a way to do what you're trying.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 26, 2008 at 12:26 pm
How do you do that through the GUI? The options that I see to install the Management tools includes unwanted things, such as SQL Profiler and SQL Server Configuration Manager. I want only the Mgmt Studio, the users getting the tools are application support groups. They don't need anything but access to the tables, plus the ability to Import/Export via the GUI.
thanks,
Brian
June 26, 2008 at 12:41 pm
The only way to dummy-proof SSMS is, well to keep the dummies away from it. There are lots of scarier things that SQL profiler in SSMS (like all of those things you can get to using right-click).
I suppose you could some custom add-in that would disable all of the feature you don't want. Not sure it's worth it, since you can pretty much control what they can do with just some good security settings.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
June 26, 2008 at 12:47 pm
You are preaching to the choir...I would prefer to not give it out. The Express version is almost perfect...all it needs is the import/export option and it would be the perfect solution. I totally agree about the permissions, however the smaller the footprint the less chance there is to exploit something. Also we have to deal with vendor apps for most of the DB's I support. In many cases this limits the amount of security changes I can make.
Installing all the extra tools that really have no use except for the DBA's seems like a poor decision on MS's part. What possible use could there be to install the Surface area config tool with all installs of Mgmt Studio?
So far it is looking like I am stuck, if so that is how it is.
thanks,
Brian
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply