Configuration of the MS SQL Server follows general database convention.
dataSource { default () { uri = 'jdbc:[jtds:]sqlserver://db_hostname:port[;property=val]' } }
where any number of additional parameters can (and should) consist of:
databaseName
- name of the databaseuser
- username configured to access databasepassword
- password for the above usernameschema
- name of the database schemalastUpdateCount
- 'false' value causes all update counts to be returned, including those returned by server triggers
Example:
dataSource { default () { uri = 'jdbc:sqlserver://hostname:1433;databaseName=tigasedb;user=tigase;password=tigase12;schema=dbo;lastUpdateCount=false' } }