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

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