Navigation:  Installation & General Information > Installation > WebOffice usermanagement (Application Server) > Configure the File web.config >

MSSQL Connection Parameter

 Previous pageReturn to chapter overviewNext page

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>

 

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 Usermanagement 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 Usermanagement Admin Web to the Usermanagement database.

Note: This user has to have read and write rights.

Password

Password of the user

Note: The administrator has to encrypt the password with the password.exe application. 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 UserManagement Admin Web to reload the UserManagement 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.