Original server installed sql2000, recently need to upgrade, but 2000 cannot normal unloading, and directly installed 2008 specified instance, loaded the normal operation of the database, but baidu said even so, still in use the default 2000 examples, I use baidu IP add specific instance directly, but is even not the database, and a great god advice please...

CodePudding user response:

What are you doubt is:
1. You are using is 2000 or 2008?
2. How to connect to the database?
1 or 2?

2008 if you normal use,
Can continuous to refer to the following approach:

https://blog.csdn.net/yenange/article/details/50853083

Connection 2008 normal after 2000, the service is set to disabled, so that 2000 won't be a memory

CodePudding user response:

You need to specify the port with IP connection

CodePudding user response:

When installation using the named instance, when use this specific instance: computer name or IP address/instance name

CodePudding user response:

After the instance name can't log in

CodePudding user response:

Still use the old 2000, server name add I installed 2008 even the specified instance

CodePudding user response:

refer to the fifth floor black raw response:

2000, still use the old server name add I installed 2008 specified instance even not

Don't use any instance name, direct use IP, port, according to my # 1
https://blog.csdn.net/yenange/article/details/50853083

The article to operate,

Application of the connection string, if the port is 2433, writing for the similar:
192.168.1.108, 2433
117.43.25.168, 2433
Can,

CodePudding user response:

Multiple words, another can only specify the instance

CodePudding user response:

I installed the sql2000, sql2008R2 and sql2014, non-interference in each other