CODEWITHSUNDEEP
sql-servert-sqldatabase-administration
bulat makhmutov
bulat makhmutov

Reputation: 27

How to connect to default instance using Non-Standard TCP port

I want to connect to MSSQLSERVER default instance using non-default (non standard) TCP/IP port in connection string. By default we connect to default instance using 1433 port, and put server name in connect string (Server Name field in SQL Studio) for accessing the instance. How to change default port to other one and connect in SQL studio to default instance, without using custom port in connect string, using just server name?

1) Changed Default Port to other port in SQL Native Client 10.0 Configuration > Client Protocols > TCP/IP ---> Restarted instance - failed to connect

2) Changed default Port to other one in SQL Server Client Network Utility > ---> Restarted instance - failed to connect

not applicable

How to change default port to other one and connect in SQL studio to default instance, without using custom port in connect string, using just server name?

Upvotes: 1

Views: 815

Answers (1)

Brian
Brian

Reputation: 1248

If you don't want to put the port number in the connection string explicitly, you have two options:

  • Run the Browser Service
  • Create a SQL Server Alias on all your client machines, using the SQL Server Configuration Manager tool. You'll have to specify the port in the alias, but it won't be in the connection string.

Upvotes: 1

Related Questions