Rockwell Automation FactoryTalk Historian SE 4.0 Installation and Configuration Guide - Manual (Page 142)

Appendix B Configuring the Advanced Server Components
142 Rockwell Automation Publication HSE-IN025A-EN-E–September 2013
In this section you will learn about the following:
• Verify the SQL Data Access Server Status (page 142)
• Connect to the AF and Historian Servers with PI SQL
Commander (page 142)
For detailed information on the SQL Data Access Server and SQL
queries, refer to the PI SQL Query Compendium.
The compendium is available on the toolbar of the SQL
Commander.
To verify the SQL Data Access Server status:
1. Go to Start > Administrative Tools > Services. The Services
dialog box appears.
2. In the right pane, find the PI SQL Data Access Server service.
3. Make sure that its status reads Started.
For detailed information on JDBC, refer to the JDBC Administrator
Guide. The document is available in the following location:
<HistorianInstallationDirectory>\PIPC\JDBC\Doc\
For detailed information on Notifications, refer to FT Historian SE
Notifications User Guide.pdf.
Configuring SQL Data Access
Server
Verify the SQL Data Access
Server Status
Configuring JDBC
Configuring Notifications