ChipPC - Xcalibur W Wiki

For Server 2.14.x & Agent 2.14.x

User Tools

Site Tools


Sidebar

Getting Started

Server Software Installation

Client Software Installation

First Time Use

Enrolling Client Devices


Client Access Licenses

Discovering New Clients

Enrolling Client Devices

Manage Devices

Commands Glossary

Commands to Multiple Devices

Commands to Single Device

Library

Reporting Services

Monitoring and Preventive Maintenance

Automatic Policies

Notification

Manager Options

Plugins

Advanced

installation_guide:server_software_installation:manual_installation:creating_database:configuring_sqlserver_with_ad_authentication

Configuring SQL Server with AD Authentication


Add a Pool in IIS


In the Application Pools section, add the pool XcaliburW, framework 4.0, Mode “Integrated”, checkbox ticked.

On the new XcaliburW pool, go to Advanced Settings and change the Identity value by adding the AD account.

Select the Default Web Site from the tree on the left. Set the parameter Enable 32-Bit Applications to true and change the Application Pool to XcaliburW.

Ensure MS SQL Server allows connections with Windows Authentication!


Verify the SQL server properties.

Add the user in the SQL Server


In the Login name field, add the AD account.

In the User Mapping tab, tick the “wp_manager” checkbox and add the “db_owner” rights.

Modifying the NHibernate Configuration File


Modify the “hibernate.cfg.xml” file as indicated below:

<!-- FOR SQLSERVER -->
    <property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
    <property name="connection.connection_string">Data Source=@SERVER;Initial Catalog=wp_manager;Integrated Security=SSPI;</property>
    <property name="dialect">NHibernate.Dialect.MsSql2008Dialect</property>

@SERVER = [@IP_address_or_host_name]\[SQL_connector_name] example : 192.168.2.79\SQLEXPRESS

Restart IIS


Restart IIS, and enjoy :-)

installation_guide/server_software_installation/manual_installation/creating_database/configuring_sqlserver_with_ad_authentication.txt · Last modified: 2018/02/18 13:37 by guym