Forums / Allocatus Forum (English) / Configure connection to Allocatus database

Configure connection to Allocatus database

2 posts, 1 answered
  1. user
    user avatar
    213 posts
    Registered:
    09 Aug 2015
    11 Aug 2015
    Link to this post

    When I start Allocatus Server configuration and click on Settings/User Settings I receive the following message: Could not load user settings from database.

    How can I change the database connection?

    Last modified on 18 May 2016 20:05 by aniko.erlinger
  2. admin
    admin avatar
    198 posts
    Registered:
    09 Aug 2015
    Answered
    11 Aug 2015 in reply to user
    Link to this post

    SQL needs to be running in Mixed Authentication Mode (SQL Server and Windows Authentication) for Allocatus to run. To change the security authentication mode, complete the following steps.

    1. In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.
    2. On the Security page, under Server authentication, select the new server authentication mode, and then click OK.
    3. In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.
    4. In Object Explorer, right-click your server, and then click Restart. If SQL Server Agent is running, it must also be restarted

    Further information on changing SQL Server Authentication modes can be found at http://msdn.microsoft.com/en-us/library/ms188670.aspx

    If this does not work, please review the information below.

    Please edit the config.xml in the bin folder of the Allocatus ProgramDir (e.g. C:\Program Files\Allocatus\Server\bin) and change the connection string in the tag ConnectionStringAllocatusServerDB according to the SqlConnection.ConnectionString Property.

    Last modified on 30 May 2016 17:05 by aniko.erlinger
2 posts, 1 answered

Search Forum Posts