Windows Authentication - connecting to a Data Source as a Windows user

Applies to Infiniti v8.1 or later
 

In some circumstances, it may be required to use a "Windows User" for database access instead of the standard SQL Authentication. In this instance, please carry out the following steps:
 

In IIS

Update the Application Pool of the Infiniti Instance to use the "Windows user":

  1. Launch the IIS Manager
  2. Go to "Sites" and locate the relevant Infiniti instance. Right click on the Infiniti Instance
  3. Go to "Manage Applications" and "Advanced settings"; Note the name of the "Application Pool"
  4. Just above "Sites" in the "IIS Manager", locate the "Applications Pool" tab
  5. Select this tab and then locate the "Application Pool" identified in Step 3
  6. Under "Process Model", select "Identity"
  7. Select the pulldown for "Application Pool" and change this to a "Custom Account"
  8. Enter the "Windows user" details for this application pool and save the changes

In the Web.Config file

The default user credentials of the web.config files for Manage, Produce and the Infiniti Scheduler need to be removed.

Update the connection string in the relevant web.config file to this format:

<add name="ConnectionString" connectionString="Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog={{DATABASE_NAME}};Data Source={{DATABSE_URL}};Integrated Security=SSPI;" providerName="System.Data.OleDb" />

where {{DATABASE_NAME}} and {{DATABASE_URL}} are replaced with the relevant name and SQL server.

 

Related Articles

 

 

Keywords

 

windows authentication connect data source user application pool custom account sql process model