====== Configuring MS SQL ======
----

===== Script to Create the Database =====
----

\\ 
<code mysql>
 CREATE DATABASE [wp_manager]
 GO
 USE [master]
 GO
 CREATE LOGIN [wpweb] WITH PASSWORD=N'Password-123', DEFAULT_DATABASE=[wp_manager], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON
 GO
 USE [wp_manager]
 GO
 CREATE USER [wpweb] FOR LOGIN [wpweb]
 GO
 USE [wp_manager]
 GO
 EXEC sp_addrolemember N'db_owner', N'wpweb'
 GO
 ALTER DATABASE wp_manager SET READ_COMMITTED_SNAPSHOT ON
 GO

</code>

===== The Hibernate.cfg.xml File =====
----

The database configuration file is located in "C:\inetpub\wwwroot\XcaliburW\bin". Open it with a text editor, and edit the following lines:

<code xml>
 <?xml version="1.0" encoding="utf-8"?>
 <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
   <!-- an ISessionFactory instance -->
   <session-factory xmlns="urn:nhibernate-configuration-2.2">

     [...here...]

   </session-factory>
 </hibernate-configuration>

</code>

=== Set Up MS SQL ===
----

Edit the following lines:
<code xml>
    <property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
</code>

For Microsoft SQL Server 2005:

<code xml>
    <property name="dialect">NHibernate.Dialect.MsSql2005Dialect</property>
</code>

For Microsoft SQL Server 2008:

<code xml>
    <property name="dialect">NHibernate.Dialect.MsSql2008Dialect</property>
</code>

For Microsoft SQL Server 2012:

<code xml>
    <property name="dialect">NHibernate.Dialect.MsSql2008Dialect</property>
</code>

=== Connection String ===
----

The setup will be different depending on the authentication mode used.

== Connection in SQL Authentication Mode ==
----

Edit the following line:


<code xml>
    <property name="connection.connection_string">Data Source=127.0.0.1\SQLEXPRESS;Initial Catalog=wp_manager;User ID=wpweb;Pwd=password;Trusted_Connection=False;Network Library=DBMSSOCN;Persist Security Info=False;</property>
</code>

the value "password"refers to the password you chose when you created the wpweb account


== Connection in Windows Authentication Mode ==
----

Replace the line:

<code xml>
    <property name="connection.connection_string">Data Source=127.0.0.1\SQLEXPRESS;Initial Catalog=wp_manager;User ID=wpweb;Pwd=password;Trusted_Connection=False;Network Library=DBMSSOCN;Persist Security Info=False;</property>
</code>

with:

<code xml>
  <property name="connection.connection_string">Data Source=127.0.0.1\SQLEXPRESS;Initial Catalog=wp_manager;Integrated Security=SSPI;</property>
</code>