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.