Connecting Remote 32bit Console's to a SQL 2005 database that is not using port 1433.

Version 5

    Description:

    Remote 32bit Console's can experience database connection problems because they are designed to connect to the default port 1433.

    Usually in this scenario we recommend using an ODBC System DSN connection.  You can view the instructions for this option here:
    http://community.landesk.com/support/docs/DOC-5876

    There is an alternative that has worked in some environments and may simplify setup without having to setup an ODBC connection on every machine running the Remote 32bit Console.  It has NOT been fully tested in all environments but is an option to try.

     

    On the Core Server modify the Database Server setting in Configure Services to connect to the Server using the following connection string format.

    SERVERNAME\INSTANCE, PORT

     

    Example:
    Database settings.jpg