Emergency: online -- the database connection error

2008R2, Originally before the database to create a new instance name, yesterday introduced a 2000 database, the results are now connected default into the connection of 2000 instead of 2008, I was also not host name after solid example access, but in the host itself solid example can access to the original 08 database, please how can I change it back

Started by Zebulon at November 22, 2016 - 5:41 AM

Coupled with the port connection.

Posted by Nancy at December 02, 2016 - 6:23 AM

Is it right? Into the wrong ah?

Posted by Daisy at December 11, 2016 - 6:32 AM

I'm in the database host two can be see
I access error in machine added with my name

Posted by Zebulon at December 20, 2016 - 6:33 AM

Not practical example can access to 2000 of the

Posted by Zebulon at December 30, 2016 - 7:04 AM

In this case, you do not use the host name and instance name.,

This method, in the host is possible, but if it is your own machine, to remote host, not

You can use this method :

Access 2008
The host of the IP, the sqlserver2008 port


Access 2000
The host of the IP, the sqlserver2000 port

Posted by Josie at January 01, 2017 - 7:23 AM

For example, the remote host IP is 192.168.1.16, then you try to access the remote machine, now not sure port 1433 is 2008 in 2000, or in use, first try:

192.168.1.16,1433

You have a look can be connected to the 2000, or 2008

Posted by Josie at January 05, 2017 - 7:37 AM

The problem has been resolved, the 1433 port default has occupied 2000 examples, dynamic port SQL 2008 configuration 1041 communications, the server test 1041 can be connected to 08 examples, then the firewall to port 1041 plus inbound rules, the client can connect.

Posted by Zebulon at January 08, 2017 - 8:47 AM

You are advised to take dynamic port 2008 instead of 1041 as a static port, otherwise the next time the connection, the port may change.

Posted by Josie at January 13, 2017 - 8:22 AM

Recommendation 1433 port default also get rid of, to prevent the attacks

Posted by Angelo at January 15, 2017 - 9:42 AM