Tech Tips: MS SQL SERVER when specifying an instanceName in LISA or DEVTEST

[Marcy Nunns]

In the local.properties for Enterprise Dashboard:

 

## ==================================================================================

## MS SQL Server

## ==================================================================================

## lisadb.pool.dradis.driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver

## lisadb.pool.dradis.url=jdbc:sqlserver://[SERVER]:[PORT];instanceName=[INSTANCENAME];databaseName=[DATABASENAME]

## lisadb.pool.dradis.user=[USER]

## lisadb.pool.dradis.password=[PASSWORD]

 

In the site.properties for Registry:

 

## ==================================================================================

## MS SQL Server

## ==================================================================================

## lisadb.pool.common.driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver

## lisadb.pool.common.url=jdbc:sqlserver://[SERVER]:[PORT];instanceName=[INSTANCENAME];databaseName=[DATABASENAME]

## lisadb.pool.common.user=[USER]

## lisadb.pool.common.password=[PASSWORD]

 

Message was edited by: Marcy Nunns Note:  You do not always have to specify an instanceName, but if you do, use this format.

[BobBrundrett62351981]

Good to know!