Question

My SQL Server is running on a non-default port (1433 is the default), so how can I get the installer to recognize it? I've tried the following:

• 192.168.10.10 (the ip of the sql server)
• 192.168.10.10\INSTANCE (adding the instance name)
• 192.168.10.10:55612 (which is the port)

None of these work, is there something I missed?

Answer 1

Strangely enough, MS-SQL uses a comma in the connection string to indicate a port for a server. The following should work just fine:

192.168.10.10,55612