Posted on: 5/14/2011 6:54:50 PM | Views : 356

Hello SQL Express Forum,
I had a proper installation of SQL Express 2008 R2 (x64) with Management Studio (x86). I installed it with the default instance name of MSSQLSERVER, all was going well and how please I was with this set up. In the Sql Server Configuration Manager I had the following SQL Server Services;
SQL Server (MSSQLSERVER)
SQL Server Browser (MSSQLSERVER)
SQL Server Full-text Filter Daemon Launcher (MSSQLSERVER)
SQL Server Agent (MSSQLSERVER)
 
A few days ago I installed Visual Studio 2010 Professional with Service Pack 1, amazed by the installer not allowing to deselect SQL Express with this version, I continued with the installation. All still works but I now have some anomalies;
1) I now have 2 SQL instances, MSSQLSERVER which is the one I still use, and another one named, SQLEXPRESS which appeared after the VS 2010 SP 1 installation.
2)  In the Sql Server Configuration Mana ...

Go to the complete details ...