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.