The SQL Server must be configured to allow both SQL Server and Windows authentication.
The Application User must be granted a SQL Server login to the database server that is to be used by Agile Business Suite. The login is case-sensitive and must be in the same case as specified in the Windows Security Accounts Manager database.
Configuring the Default ‘sa’ Account
When SQL Server is installed, by default the ‘sa’ account is created with a blank password. In order to ensure that unauthorized users do not gain access to your server, it is recommended that you assign a password to the ‘sa’ account. If a password is not assigned and an unauthorized user gains access using the ‘sa’ account, they have full control of all databases contained on your server.
Configuring SQL Server for Remote Access
To enable remote access to your model databases, perform the following:
In SQL Server Configuration Manager, enable the following protocols for the SQL Server instance hosting the model databases:
Named Pipes
TCP/IP
In SQL Server Management Studio, give model users permission to access your model databases – you can grant access to users individually or as Windows Groups.
Refer to the Microsoft SQL Server documentation for more information on configuring SQL Server.