MS SQL Server Bamboo 4.0 connect string issue, named instances

[Gretchen Jones]

I’m trying to install bamboo 4.0 and can’t figure out how to specify a named instance in the jdbc connection string for my MS SqlServer database.

The recommended syntax per ms sql doc jdbc:sqlserver:// serverName instanceName :portNumber ;property=value ;property=value

Bamboo documentation example is jdbc:jtds:sqlserver://localhost:1433/<database> which doesn’t allow for a named instance and varies slightly from the MS SQL Server doc example. Using their example I would expect to use ;databaseName=bamboo

Instead of just bamboo.

I’ve tried a couple of different things including jdbc:jtds:sqlserver://MYSERVER-SQL7:1433/bamboo and jdbc:jtds:sqlserver://MYSERVER-SQL7 STAGING:1433/bamboo (where STAGING is our named instance on the MYSERVER-SQL7 server) and I get errors on both

I have verified that my username/password is correct and I have sysadmin rights on my db.

I have also tried using the AD group name in the login group as in DOMAIN myLoginID with my normal network password.

I found reference to a jira.xml document that explains how to configure it in the jira.xml file directly (for a named instance issue like I'm having with Bamboo) but I can’t find anything in the bamboo configs (or I don’t know where to look) to make a similar change.

See: http://forums.atlassian.com/thread.jspa?threadID=46826 for the reference to the jira.xml configuration I'm talking about above that sounds like what I need in bamboo.

[Randy Hentz · Accepted solution]

All the JTDS connect string options are available here, this also should be added to the documentation. http://jtds.sourceforge.net/faq.html another one I use is SSL=require for our secure connections to SQL.

[Gretchen Jones]

This is the connect string I ended up using for this. The database instance is specified at the end of the string.

jdbc:jtds:sqlserver://servername:1433/bamboo;instance=instancename

[Gretchen Jones]

(where bamboo is the database name)

[Randy Hentz]

jdbc:jtds:sqlserver://servername:1433/Bamboo;instance=mssqlnamehere;ssl=require is what I use and it works for every Atlassian product so far.

[James Dumay]

Thanks for that Randy! I've updated our documentation with your answer.