Configure connection to Allocatus database Cancel The title field is required!

1. user

   

   252 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

   

   209 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