SQL Server instances with slashes in the name?
Brian Donahue
Posts: 6,590 Bronze 1
Hello,
Thanks for your post. You may want to check the server configuration to see if the instance is using a specific TCP port. Normally, you'd connect to a SQL Server on port 1433 and ADO .net would automatically negotiate the instance's port number. If the default instance of the SQL Server is using a port other than 1433 and the instance is using a hard-coded port number, then you'll need to specify the port number in the server dropdown of SQL Compare.
You can specify a port number in the server list by separating the instance name with a comma, then the port number, such as MYSERVER\TEST,1434
Thanks for your post. You may want to check the server configuration to see if the instance is using a specific TCP port. Normally, you'd connect to a SQL Server on port 1433 and ADO .net would automatically negotiate the instance's port number. If the default instance of the SQL Server is using a port other than 1433 and the instance is using a hard-coded port number, then you'll need to specify the port number in the server dropdown of SQL Compare.
You can specify a port number in the server list by separating the instance name with a comma, then the port number, such as MYSERVER\TEST,1434
This discussion has been closed.
