Error: "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."

Version 6

    Verified Product Versions

    LANDESK Management Suite 9.5LANDESK Management Suite 9.6

    Issue

     

    During a Core Server setup or an in-place upgrade process, the Upgrading database action fails showing a pop-up window with the error

     

    [DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection. Invalid connection string attribute

     

    During a Core Server setup or an in-place upgrade process, the Upgrading database action fails showing a pop-up window with the error

     

    [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied

     

    During the setup of LANDESK Management Suite 9.5, the installation stops during the Configuring Datamart action, a pop-up window appears reporting the following error messages:

     

             Invalid authorization specification
              Invalid connection string attribute

     

    Resolution

     

    1. Do not close the LANDESK installation window
    2. Open the registry editor
    3. If you are setting up a Management Suite 9.5, go to HKLM\SOFTWARE\Wow6432Node\LANDesk\ManagementSuite\Core\Connections\Local
    4. If you are setting up a Management Suite 9.6, go to HKLM\SOFTWARE\LANDESK\ManagementSuite\Core\Connections\Local
    5. Edit the value Server.
      The string value should contain the name of your SQL server, if you're using the default port that is all that will be set. Sometimes the SQL server will still require the connection port to be specified. You can edit the value to include the default port 1433.
      So the value will end up looking like 'SQLServername,1433' or if you use the IP address 'SQLServerIP,1433'
      If you are using a custom port instead, specify the correct one according to your SQL Server configuration.

     

    Other resources

     

    Invalid Authorization Specification - Invalid Connection String Attribute