How to specify a port number in SQL Server connection string?

Use a comma to specify a port number with SQL Server:

mycomputer.test.xxx.com,1234

It’s not necessary to specify an instance name when specifying the port.

Lots more examples at http://www.connectionstrings.com/. It’s saved me a few times.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)