Search:     Advanced search

MS SQL Database/Table

Article ID: 291
Last updated: 15 Aug, 2018
Revision: 9
Views: 0

The MS SQL Database/Table monitoring point makes an ODBC connection to the MS SQL Database and checks if the Table is accessible and contains information.

The parameters that are unique to the MS SQL Database/Table include:

Server Name

DNS name of server where the SQL database is located

Database

Database name to check

Tbl Name w/Owner

Table name to check, including table owner

Example: GIS.Roads

userID

User ID with access to the MS SQL Table. If using Windows AD authentication, enter Domain\UserID

Note: userID should be entered as encrypted information

userPW

User PW for access to the MS SQL Table

Note: userPW should be entered as encrypted information

Next, configure the GeoMonCharts UI web.config file with the database information added for this monitoring porting, following the instructions in Editing the Geomonitor UI Web Config for Microsoft Usage Database.

Prev   Next
License Manager Module (New)     MSSQL SDE List Tables