ChipPC - Xcalibur W Wiki

For Server 2.12.x & Agent 2.12.x

User Tools

Site Tools

A PCRE internal error occured. This might be caused by a faulty plugin

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

installation_guide/server_software_installation/manual_installation/creating_database/configuring_sqlserver.txt · Last modified: 2021/07/29 13:11 (external edit)