Install SQL2005 and then install SQL 2008R2, prompting this computer to install a previous version of Microsoft Visual Studio 2008 and to check if the SQL Server 2005 Express Tool solution is installed

SQL 2005 is installed on the work computer, but SQL 2008R2 is installed on the client computer, sometimes it is inconvenient to connect their library debugging. Then installed a SQL2008 R2, during these two problems, the Internet search for a solution, do not install vs SP1, do not uninstall SQL Server 2005 Express tool, only need to modify the registry.

Tip Error: An earlier version of Microsoft Visual Studio 2008 was installed on this computer. Please upgrade VS2008 to SP1 before installing SQL Server 2008. Workaround: Modify the registry. To run the registry regedit, rename the Hkeylocalmachine/software/microsoft/devdiv. The 64-bit path is hkey_local_machine\software\wow6432node\microsoft\devdiv,

Tip Error: Sql2005ssmsexpressfacet check if the SQL Server 2005 Express tool is installed. Failed, the SQL Server 2005 Express tool has been installed. To continue, remove the SQL Server 2005 Express Tool

Workaround: Modify the Registration Form! Hkeylocalmachine/software/microsoft/microsoft SQL Server/90/tools/shellsem.

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL server\90\tools\shellsem_ Rename

--------------------------------------------------------------------------------------------------------------- -------------------------------

Install SQL2008R2 when the path and instance name can not be the same, the instance name changed to convenient to remember a little, my change to sql2008r2. After installation, use. If you don't log in, you can log in with the computer name \ Instance name. There are several points to note:

After installation SQL2005 and SQL2008R2 two instances coexist but there is a problem when there is only one port of 1433 access (although the general installation SQL2008 R2 will automatically assign an additional).

Directly with SQL2008R2 Enterprise management access to this machine, access to the SQL2005 instance. Need to set the lower port

The port starting from the second instance is a dynamic port, which, if required, is manually specified as a static port, as specified
The second instance is 1434 or a random one such as 2080 port

Click "Start", "Microsoft SQL Server2005", "Configuration Tools", "SQL Server configuration Manager", "at the bottom left of your computer", "Expand Network Configuration" and click " MySQLServer protocol "-double-click the newly installed instance database name on the left--expand, then double-click TCP/IP on the right--and select the address to see the port number.

Step one: First put the above dynamic port number 0, delete.
Step Two: Enter the TCP port: Custom

(PS: Pictures from the network)

Reference Link: http://blog.csdn.net/eric88/article/details/8947558

http://blog.csdn.net/sat472291519/article/details/48174515

Install SQL2005 and then install SQL 2008R2, prompting this computer to install a previous version of Microsoft Visual Studio 2008 and to check if the SQL Server 2005 Express Tool solution is installed