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
The database configuration file is located in “C:\inetpub\wwwroot\XcaliburW\bin”. Open it with a text editor, and edit the following lines:
<?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>
Edit the following lines:
<property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
For Microsoft SQL Server 2005:
<property name="dialect">NHibernate.Dialect.MsSql2005Dialect</property>
For Microsoft SQL Server 2008:
<property name="dialect">NHibernate.Dialect.MsSql2008Dialect</property>
For Microsoft SQL Server 2012:
<property name="dialect">NHibernate.Dialect.MsSql2008Dialect</property>
The setup will be different depending on the authentication mode used.
Edit the following line:
<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>
the value “password”refers to the password you chose when you created the wpweb account
Replace the line:
<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>
with:
<property name="connection.connection_string">Data Source=127.0.0.1\SQLEXPRESS;Initial Catalog=wp_manager;Integrated Security=SSPI;</property>