MSSQL Connection Parameter

The example shows a connection profile with the following values:

•Name: MSSQL,

•Server: MyServer, Database instance: sql2008

•Database: MySQL_Database,

•Database user: MyUsername

•Encrypted password: password123

 

<GeoUserManagementConnection>

<Profile>My MSSQL Profile</Profile>

<Host>MyServer\sql2008</Host>

<DatabaseType>MSSQL</DatabaseType>

<DatabaseName>MySQL_Database</DatabaseName>

<Username>MyUsername</Username>

<Password>KH4yhJLabVaPSxrXOGCb7g==</Password>

<ProviderExtension></ProviderExtension>

<WebOfficeURL></WebOfficeURL>

<WebOfficePassword></WebOfficePassword>

<WebOfficeProjectURL>https://mywebofficeserver.com/WebOffice/synserver?project=</WebOfficeProjectURL>

<KeepLoggingEntriesPeriode>0</KeepLoggingEntriesPeriode>

</GeoUserManagementConnection>

 

icon_comment

Note that connection syntax for connecting with a dedicated port is host\instance,port.

 

Property

Description

Profile

Alias name that will be displayed in the User Management Admin Web list of profiles

Host

TNS entry that is saved in tnsnames.ora

DatabaseType

MSSQL

DatabaseName

Database name

Username

User to be used for connection of User Management Admin Web to the user management database.

icon_comment

This user has to have read and write rights.

Password

Password of the user

icon_comment

The administrator has to encrypt the password with the password.exe application.

icon_cross-reference

See chapter Creating an Encrypted Password for details.

ProviderExtension

Connecting to a  64-bit OLEDB-Client for Oracle and  MSSQL set the value .1'

WebOfficeURL

URL to the WebOffice administration page (SynAdmin): Enables a button in the User Management Admin Web to reload the user management data of the WebOffice application and reset the cache.

WebOfficePassword

Specified in days: If logging entries (of the self-registration) are older than the configured value, these logging entries will be deleted.

WebOfficeProjectURL

URL to the WebOffice project in order to communicate project approvals to users by mail. (e.g. after a group change by the administrator).

WebOfficePassword

Specified in days: If logging entries (of the self-registration) are older than the configured value, these logging entries will be deleted.