Configuring SQL Server and Enterprise Tester to Use a SQL Login

This guide walks through the steps for creating a SQL login and updating the web.config file for Enterprise Tester using the login for authentication.

Create a SQL user name/login on the server you wish to access

  • Open SQL Server Management Studio.

  • Connect to the SQL server.

  • Go to security->logins.

  • Right click, select "New Login".

  • Select SQL Login.

  • Enter the username and password you wish to use.

  • Disable password policy enforcement, and ensure that the login does not expire, and does not require changing on next login.

  • Click on user mappings.

  • Find the Enterprise Tester database.

  • Click the checkbox next to it, to give the new user access.

  • Ensure the new user has either public and db_owner permissions, or public, datareader, datawriter and ddl permissions (as shown in the following screen shot).

  • Click "OK" to save this new user.

Update the web.config file, so it uses the new SQL server login/password 

  • Locate Enterprise Tester's web.config file (normally in C:\Program Files\Catch

  • Limited\Enterprise Tester\Web\web.config).

  • Open the file with a text editor.

  • Locate the <connectionStrings> section in the configuration file.

  • Update the connection string, removing any of the following properties:

    o Integrated Security=True;

    o AttachDbFilename=<path>;

    o Trusted_Connection=Yes;

  • Add the User Id and Password properties, for the login/password you created prior.

  • Save changes to the web.config file.

  • Access the Enterprise Tester website, to ensure the database changes have worked.

  • No labels