CODEWITHSUNDEEP
sql-serversql-default-instance
Rainmaker
Rainmaker

Reputation: 321

SQL server default instance with a different port

One of our clients have SQL server default instance running on a non-default port. So, the connection string from our application should be servername,1234.

They don't want to create aliases on the MS SQL server.

Is there any different way our application can connect to it?

It is a default instance, so can I use servername\MSSQLServer

Thank you!

Upvotes: 1

Views: 362

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 88852

SQL Browser does not support connecting to a default instance with

servername\MSSQLServer

They don't want to create aliases on the MS SQL server.

That wouldn't help anyway. Aliases are created on the client computer, not the SQL Server.

See Create or Delete a Server Alias for Use by a Client

Upvotes: 3

Related Questions