MarcyNunns

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

Discussion created by MarcyNunns Employee on Aug 28, 2015
Latest reply on Aug 28, 2015 by BobBrundrett62351981

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.

Outcomes