Install SQL Server 2008 Management prompts for the solution of SQL Server Express

SQL Server The Express tool is not SQL Server management, and you do not need to uninstall SQL Server Management, with a little trick

Install SQL Server 2008 management, prompting an error: Sql2005ssmsexpressfacet check to see if the SQL Server Express tool is installed. Failed, the SQL Server Express tool was installed. To continue, remove the SQL Server Express tool. is SQL Server management and SQL Server 2008 management incompatible? Why is there such a hint?

The answer is that the SQL Server Express tool is not SQL Server management, and you do not need to uninstall SQL Server Management, with a little trick:

Modify the Registry! Hkeylocalmachine/software/microsoft/microsoft SQL Server/90/tools/shellsem.

Some talk on the Internet to delete this folder, I am afraid to delete the SQL Server management can not use, rename, Shellsem to ShellSEM1 to try, the results continue to install SQL Server 2008 Management to display the installation success!

It's no problem to open it. Just because the registry was modified earlier, the SQL Server management could not be started, double-click to open the interface and Flash.

Then open the registry and change ShellSEM1 back to Shellsem, you can open SQL Server Management, OK. Fix the problem with SQL Server 2008 management, SQL Server management, and installation at the same time!

SQL Server Management Studio2008 not connected?

Start--> program-->sql server2008--> Configuration Tool-->sql Server Configuration Manager-->sqlserver Service
In the open window, do the following:
1, to SQL Server (Msssqlserver) Right key, attributes, built-in account set for localsystem--> application
2, to SQL Server (Msssqlserver) right button, start