Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Is MS Visual Studio 2005 part of MS SQL Server 2005 installation?

Posted on 2008-10-24
4
779 Views
Last Modified: 2008-10-28
Hi,

Is MS Visual Studio 2005 part of MS SQL Server 2005 installation?
Is it safe to UNINSTALL  the MS Visual Studio 2005 running on Windows Server 2003 SBS with MS SQL 2005 Server?

thanks.

Czar
0
Comment
Question by:czarbapora
  • 2
4 Comments
 

Assisted Solution

by:birbilis
birbilis earned 100 total points
ID: 22796242
No, I don't think it's part of SQL Server 2005. It's safe to uninstall, since it installs SQL Server Express edition (formerly called MSDE), not the full one (it can coexist with the full version). Also at uninstall, you can select which features to uninstall. Mind you at Add/Remove programs you'll see several items installed separately by Visual Studio which you should uninstall one-by-one if you don't need them (usually VS uninstaller prompts you at its end on what other items VS has installed that you might also want to uninstall)
0
 

Author Comment

by:czarbapora
ID: 22796468
The server don't have SQL Server Express installed but it has Microsoft SQL Server Desktop Engine(SBSMonitoring) and (SHAREPOINT), do you still think that it is safe to unininstall the Visual Studio 2005?

thanks.
0
 

Assisted Solution

by:birbilis
birbilis earned 100 total points
ID: 22797148
The Desktop Engine is what I call SQL Server Express. SBS (Small Business Server) installs that version of SQL Server which has performance cut-off built-in when multiple users access it simultaneously, since it's for Small Business. It still is safe to uninstall VS2005, just make sure you select custom uninstall and double-check there to make sure. After all if you look at Add/Remove programs, the SQL Server is separate uninstall item from VS2005.
Of course first step should always be to backup your system (can use Norton Ghost or similar tool) so that you can restore it in case anything goes bad (you know what the Murfy laws say).
0
 
LVL 10

Accepted Solution

by:
Marcjev earned 400 total points
ID: 22799946
The visual studio IDE is installed as a component of the SQL 2005 installation. If you install reporting services it's the UI you use to define reports. Also analysis services projects and integration services projects can be edited in this environment.

If you run the management studio and visual studio on another workplace and not directly on the server you can uninstall the visual studio 2005 environment. If you want to be able to edit report definitions, or cubes or integration services projects made in the vs2005 environment on the server (maybe in emergency situations only) you should leave it installed. It only ;-) takes a 185MB when installed by SQL 2005.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A quick step-by-step overview of installing and configuring Carbonite Server Backup.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question