Shulou(Shulou.com)05/31 Report--

Xiaobian to share with you how Sql2000 and Sql2005 coexistence installation, I believe most people do not know how to share this article for your reference, I hope you read this article after a great harvest, let us go to understand it!

Assuming Sql2000 is installed, start installing Sql2005 on the Run CD by selecting Server Components, Tools, Books Online, and Samples. The license agreement is followed by the pre-installation support component installation, scanning the computer configuration In the installation wizard, sqlserver 2005 setup program will perform a configuration check on the system Next enter the registration information; Select the component to be installed. In this process, click "Advanced" to select the installation path. Next, in "Instance Name", this is the key step. If there is no other Sql version on the machine, select the default instance name. However, since Sql2000 is already installed, this step has to select "New Instance Name". Then enter the instance name and then go to the service authentication mode. Select the mixed authentication mode and set the sa password. The rest of the installation are selected default values, all the way "next", the final installation, complete! So far, two versions of the database implementation coexist. * SQL2000 client tools cannot connect to SQL2005,SQL2005 client tools can connect to SQL2000 and SQL 2005 at the same time.* SQL2000 servers always use port 1433, SQL2005 uses dynamic ports. SQL2005 provides a SQL BROWER service. After opening this service, you can query the SQL BROWER service to know which port SQL2005 is using now. Of course, you can also change the dynamic port of SQL2005 to static. The modification process is as follows: Run SQL Configuration Manager, find the protocol under SQL instance name, double-click TCP/IP protocol on the right, and enter the port where SQL runs in the second tab IPALL (note that dynamic port and static port cannot be filled in at the same time, otherwise SQL will not be started next time). Restart SQL service after modification is completed to take effect. * If you still can't connect after modifying the port, you need to open SQL2005 remote login service. In Microsoft SQL Server 2005, remote login is not allowed by default, and an error [provider: SQL network interface, error: 26 -Error locating specified server/instance] will appear. You can open it by the following method: Configuration Tools->SQL Server Peripheral Application Configurator-> Peripheral Application Configurator for Services and Connections-> Open the Database Engine node under MSSQLSERVER node, select "Remote Connection" first, and then select "Use TCP/IP and named pipes at the same time." After confirmation, restart the database service. * If sql2000 (port 1443) and sql2005 (port 1433) are installed at the same time, the application connection string can be accessed by server=127.0.0.1, and sql2000 can be accessed by server= machine name/instance name. The problem lies in: accessing sql 2000 by server=127.0.0.1:1443 is unsuccessful. If remote access to the database home port is as follows: comma separated server=127.0.0.1,1443

The above is "Sql2000 and Sql2005 how to coexist installation" all the contents of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.