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

This article introduces the knowledge of "how to link through ip when sqlserver does not use the default instance". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

SQL Server modifies the default instance

There is a server with two versions of the database, one 2008 (instance name MSSQLSERVER) and one 2017 (instance name MSSQLSERVER01)

Sql server database can install multiple database instances, but there is only one by default. Because 2008 was installed earlier, the default is 2008. Now I need to change the default instance of 2008 to 2017.

One: find the configuration manager of SQL Server. Since my environment is Win 10, I can only find it in the file C:\ Windows\ SysWOW64 because I can't find it in the start menu at all. There are two

One is 2008, the other is 2017, any one is fine. For the convenience of opening it next time, you can attach it to the start menu.

Two: in the SQL server network configuration, disable TCP | IP of 2008, and then open TCP of 2017 | IP

3: modify the TCP | IP port of 2017 to 1433

Four: restart 2017 of the SQL server service

This is the end of the content of "how to link through ip when sqlserver does not use the default instance". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.