Crowd using SQL Server for internal database

[Thomas Douglas]

Hello, I am not sure what to enter on the Crowd installation wizard when I want to connect to a MS Sql Server database. The wizard prompts you for the following. Most fields are auto-filled once I select 'JDBC connection' for the database type.

Type of database: JDBC connection

Database: Microsoft SQL Server

Driver class name: net.sourceforge.jtds.jdbc.Driver

JDBC URL: jdbc:jtds:sqlserver::/localhost:1433/crowd

Username: xxxx

Password: xxxx

Hibernate dialect: org.hibernate.dialect.SQLServerDialect

I am not familiar with the JDBC connection string syntax so I'm sure I'm missing something simple. I am used to a prompt for host server and database, but not sure where that gets entered.

Thanks for any help!

[Thomas Douglas · Accepted solution]

I figured out the syntax for SQL Server. I realized that I could look at my Jira dbconfig file to see a sample URL format. The format below worked for me. 

jdbc:jtds:sqlserver://[SERVERNAME]:[PORTNUMBER];databaseName=[DATABASENAME]

[AnnWorley]

Thanks for following up!

[AnnWorley]

Hi Thomas,

The host server and database are specified in the JDBC URL. We happen to use SQL Server as an example in our doc: Running the Setup Wizard:

for SQL Server, the default URL is jdbc:jtds:sqlserver://localhost:1433/crowd , and if you wish to connect to crowddb instead, modify the URL so that it looks like this: jdbc:jtds:sqlserver://localhost:1433/crowddb

In the JDBC URL above, the host server is "localhost" and the database names are "crowd" and "crowddb".

I look forward to hearing whether you can connect to your MS SQL database during the setup Wizard for Crow now.

Thanks,

Ann