Error trying to connect database to WorldServer

 We are currently trying to host our instance of WorldServer (release 11.8.3), and have run into the issue shown in the image below when trying to connect.

Do you know what the problem may be here? The database has been pre-created, the user has db_owner role on it, from terminal we don't see any problems with connection, we could also easily connect using SQLMS but the application doesn't want to accept it.

Screenshot of Microsoft SQL Server Authentication window for WorldServer with fields for Server, Database, User, and Password filled out. An error message 'Incorrect SQL connection details' is displayed at the bottom.



Generated Image Alt-Text
[edited by: RWS Community AI at 1:13 PM (GMT 1) on 8 Aug 2024]
emoji
Parents
  • Hi Cecilia,

    This generic SQL error appears when the connection to the database is not successful.
    Even if the database was already created, the installer will still check for a successful connection as long as "Skip database settings" is not checked.

    What you can do:
    - Not sure if the terminal in the screenshot is from the same environment where you try to install WorldServer, please try from the same environment otherwise and make sure the connection is successful.
    - You can try specifying the SQL Server IP instead of domain/name if possible.
    - Make sure the port 1433 is opened and the communication is not blocked by some security rules.
    - You can try skipping the database settings entirely: in this case, the installer will proceed without checking the database connection and will install WorldServer instance. After installation, you will need to follow these steps for specifying the connection string settings: docs.rws.com/.../mandatory-configurations (database connection string section). A restart of the WorldServer instance will be required after changing the configuration file.

    Hope this information helps you and you will soon have a successfully installed WorldServer!

    Thank you,
    Anca

    emoji
  • Thanks! We are not getting a new error about Microsoft SQL Server version not being supported. We are using Microsoft SQL Server 2022 (RTM). Do you know what version is expected? I didn't find that in the documentation.

    Error dialog box titled 'Invalid SQL Connection' with a warning icon and message 'Not supported Microsoft SQL Server Version' and an 'OK' button.

    emoji


    Generated Image Alt-Text
    [edited by: RWS Community AI at 12:16 PM (GMT 1) on 13 Aug 2024]
Reply Children