Is it possible to use another DB instance than the root instance on the database server for LiveTime (MS SQL) What is the syntax for the database connection ?

Version 1

    Details

    Is it possible to use another DB instance than the root instance on the database server for Absolute Service (MS SQL)

    What is the syntax for the database connection ?


    Resolution

    The way to do this, is to to configure them to listen on a different port.

    In SQL Server 2005 and 2008, this can be configured using the SQL Server Configuration Manager, under SQL Server Network Configuration > Protocols for [Instance name].

    The TCP/IP option needs to be enabled and right clicked on to configure the properties. The 'IPAll' (last IP address option listed) and/or individual IP addresses need to be set to a different port number to that of the other instances running on the server. IPAll can just be set on it's own, but the IP address in question needs to be Active and Enabled.

    On SQL Server 2005, the Surface Area Configuration tool may also need to be used to ensure the instance is allowing TCP/IP connections, under [Instance name] > Database Engine > Remote Connections.

    Following this, the SQL Server service (for that instance) may need to be restarted. If the SQL Server Browser service is in use, it may need restarting too.

    Absolute Service then just needs to be configured to point to the SQL Server listening IP address and the allocated port number to speak directly to that SQL Server instance.