ChipPC - Xcalibur W Wiki

For Server 2.14.x & Agent 2.14.x

User Tools

Site Tools


Sidebar

installation_guide:server_software_installation:manual_installation:creating_database:configuring_sqlserver

Configuring MS SQL


Script to Create the Database



 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 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:

 <?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>

Set Up MS SQL


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>

Connection String


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

Connection in SQL Authentication Mode

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

Connection in Windows Authentication Mode

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>
installation_guide/server_software_installation/manual_installation/creating_database/configuring_sqlserver.txt · Last modified: 2018/02/18 12:49 by guym