Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I need to connect to a named instance of SQL Server. How can I enter the instance name with port number?

April 26, 2017Connect enter instance named port SQL Server

0

10 Posted

I need to connect to a named instance of SQL Server. How can I enter the instance name with port number?

1 Answer

0

10 Posted

To connect to the named instance of SQL Server it is enough to point the SERVER_NAME\INSTANCE_NAME, for example: PEARL\SQLEXPRESS It is possible also to specify the server IP address with the port number or instance name with the port number: 127.0.0.1,4444 or PEARL\SQLEXPRESS,4444 To add the server name with the port number to SQL Server management list please: • Open Login tab in Comparison Wizard. • Press the button right to Server combobox. • In SQL Server List Management dialog click on Add New button. • Type the server name or IP-address and a port number.