SQL 2005, Non Standard Instance, Non Standard Port

SQL 2005, Non Standard Instance, Non Standard Port

  
Hi everyone. This may be of interest to anyone who has a SQL 2005 non standard instance, and a non standard port.

In the configuration tool (4.0) you would specify:

DBMS: Microsoft SQL Server
Server: <servername>\<instancename>,<portnumber> ie: mysqlserver\sql2005,3480
Catalog: Outsystems

This caused me about a half of day searching OS and various MS SQL sites to find the right combination of values. Don't forget you will need to change the SQL connect string in machine.config as well.

I hope this helps someone else.... If not, I know I'll need it again and remember I posted this here.

Ken