?
Solved

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

Posted on 2008-10-24
4
Medium Priority
?
788 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 400 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 400 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 1600 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

588 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