SQL 2005 and SQL 2008R2 also installed on the same computer.

SQL 2005 and SQL 2008R2 also installed on the same computer on the need to pay attention to what? How to modify the default connection to the default instance? Two SQL server port will not conflict, in addition to the default instance and the port, there is no other SQL server file sharing needs attention?
You ask the senior DBA help to sum up, the younger brother in the knelt thanks...

Started by Adolph at February 04, 2016 - 5:28 PM

The port is not conflict. The default case modification during installation.

Posted by Valentine at February 07, 2016 - 5:30 PM

Each installation best when they create an instance name, installed in a different folder.
I is this installation, I have 2005, 2008, 2012 is no problem.

Posted by Rupert at November 13, 2016 - 12:52 PM

SQL browser opens it basically do not consider the port of. You just need to specify the name can be good examples, if multiple instances of that instance name to coexist, identification of certain, otherwise easily with the wrong

Posted by Winston at November 23, 2016 - 1:40 PM

The 05 and 08 ports used what are.?
What should I pay attention to in the procedure call.?
Some time ago I in a 08 R2 test machine installation, connection default or 05, the default connection. To change it?

Posted by Adolph at November 25, 2016 - 2:17 PM

The default is 1433, second will be allocated dynamically, interview notice the use of the machine name \ instance name

Posted by Winston at November 26, 2016 - 2:33 PM

So I say instance name is best identified at the time of installation, such as SQL2005, sql2008, using the program access
Examples of machine \sql2005 can access 2005

Posted by Winston at December 08, 2016 - 2:56 PM

Now the company is like to be a SQL 05 server data transfer to another set of 08 R2, in order to prevent the 05 data unexpected questions in 08 above, to install 05sql 08 R2 in the server, so is it right? 08 using port 1433, 05 dynamic distribution after installation? When the installation is not placed in the same directory, distinguish good instance name, specify the hostname \ instance name program is invoked, theoretically it shouldn't be a problem.?

Posted by Adolph at December 15, 2016 - 3:15 PM

The instance name to distinguish, open the SQL Browser service to sqlserver and find it, even when the sqlserver instance name specified 2005

Posted by Winston at December 29, 2016 - 3:17 PM

Oh, it's going to be all right.

My former company, there are 2 examples of a server, a 2005 example, the instance name is MSSQLSERVER, the port is 14335, you can manually set.

The other one is 2008R2, on port 1433, the instance name is sql08.

Suggest that you directly at the time of connection, the server IP, port:
To connect.

For example:,1433

There will be no problem.

Posted by Irene at December 30, 2016 - 3:50 PM

In general, the name of the first instance, the default is MSSQLSERVER, the port is 1433,

In the installation of second examples, you need to specify the instance name, port is allocated dynamically, but you can specify your own, modify.

This is a very flexible.

Posted by Irene at January 12, 2017 - 4:50 PM

I see, thank you brother!

Posted by Adolph at January 13, 2017 - 5:11 PM