title: JDBC connect to MSSQL named instance with non-standard port
body: <p>Hello guys I'm working on a project and I'm trying to connect <a href="http://www.atlassian.com/software/jira/overview" rel="nofollow">JIRA</a> to a MSSQL aliased or named instance. Checkout <a href="http://www.databasejournal.com/features/mssql/article.php/3689846/Using-Non-Standard-Port-for-SQL-Server.htm" rel="nofollow">here</a> if you don't know what i'm talking about.</p>
  
  <p>Under this setup, for example, when you want to connect to a specific DB server, let's say using SQL Studio, you have to use "servername,port" as in the mssql server alias configuration, that reflects the DB instance.</p>
  
  <p>What would be the connection string to use under this circunstances?</p>
  
  <p>I've <a href="http://blogs.msdn.com/b/dataaccesstechnologies/archive/2010/03/03/running-sql-server-default-instance-on-a-non-default-or-non-standard-tcp-port-tips-for-making-application-connectivity-work.aspx" rel="nofollow">read</a> about issues with this kind of setup as I'm using the JDBC driver (JIRA uses it). You can try with <a href="http://squirrel-sql.sourceforge.net/" rel="nofollow">SQuirreL</a> for testing this, as it uses the same driver.</p>
  
  <p>Cheers!</p>