I actually created a new instance and I was given additional the 2 Management Tools options in the installation, as mentioned by mrdenny.
Sql management studio 2008 r2 developer manual#
If you cant do it using the Control Panel then I wrote up some tips for manual removal here. I installed SQL Server 2008 Standard on Windows 2008 Server R2, and according to SQL Server Configuration Manager, I've got two instances: OFFICESERVERS (for SharePoint) and MSSQLSERVER. If you have SQL Server 2008 R2 Management Studio RTM installed on a computer that is running Visual Studio 2010 SP1, you may experience a compatibility issue between Microsoft SQL Server 2008 R2 Management Studio (SSMS 2008 R2) and the Transact-SQL Language Service that is included in Visual Studio 2010 SP1. Uninstall the Evaluation Edition of 2008 or 2008 R2 completely. However, according to the installation I already have Management Tools - Basic installed. I'm not a database administrator I'm a developer - and I'm having trouble with SQL Server Management Studio. Developers Description By Microsoft Microsoft SQL Server 2008 Management Studio Express (64-bit) is an integrated environment for accessing, configuring, managing, administering, and developing. The latest version of Microsoft SQL Server 2008 R2 (64-bit) is, released on. It was checked for updates 848 times by the users of our client application UpdateStar during the last month. I have downloaded SQL Server 2008 R2 Developer (x86, 圆4, ia64) - DVD (English) from MSDN. Microsoft SQL Server 2008 R2 (64-bit) is a Shareware software in the category Miscellaneous developed by ® 2006 Microsoft Corporation. I don't mind if I have to remove everything services, instances, management studios, etc. I ultimately want to have SQL Profiler at the end of the day.
Sql management studio 2008 r2 developer install#
How can I tell which instance this is running against?Īlso, have the Express Edition completely removed and install either the Developer / Enterprise edition of SQL Server with the Management Studio interface. What I would like to accomplish here is to maintain the databases I have in (local).
I just noticed that I have the following services running: However, according to the installation I already have Management Tools - Basic. I would like to move from SQL Server 2008 R2 Express to SQL Server 2008 R2 Developer or Enterprise. SQL Server Management Studio SQL Profiler Edit: I have downloaded SQL Server 2008 R2 Developer (x86, 圆4, ia64) - DVD (English) from MSDN.