Installing SQL Server 2008 Management prompts you to install SQL Server Express for Solution _mssql

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 the ShellSEM1 back to Shellsem to 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
performs the following actions in an open window:
1, For SQL Server (Msssqlserver) Right key, properties, built-in account set to localsystem--> apply
2, to SQL Server (Msssqlserver) right, start