====== 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.

{{ ad:add_a_pool_in_iis1.png }}

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

{{ ad:add_a_pool_in_iis2.png }}

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**.

{{ ad:add_a_pool_in_iis3.png }}

===== Ensure MS SQL Server allows connections with Windows Authentication! =====
----

{{ ad:add_a_pool_in_iis4.png }}

Verify the SQL server properties.

===== Add the user in the SQL Server =====
----

{{ ad:add_a_pool_in_iis5.png }}

In the Login name field, add the AD account.

{{ ad:add_a_pool_in_iis6.png }}

In the //User Mapping// tab, tick the "wp_manager" checkbox and add the "db_owner" rights.

{{ ad:add_a_pool_in_iis7.png }}

===== Modifying the NHibernate Configuration File =====
----

Modify the "hibernate.cfg.xml" file as indicated below:

<code xml>
<!-- 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>

</code>

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

===== Restart IIS =====
----

Restart IIS, and enjoy :-)