Service Virtualization

Expand all | Collapse all

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

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

    Posted 08-28-2015 09:57 AM

    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.



  • 2.  Re: Tech Tips: MS SQL SERVER when specifying an instanceName in LISA or DEVTEST

    Posted 08-28-2015 10:07 AM

    Good to know!