TN HistClient101 wwUser errors in .aaTrend file or opening Historian Client Trend directly
- Author: Glenn Yancey
- Published: 03/13/2015
- Applies to: Historian Client 10.0 and higher
When opening up an .aaTrend file on a new install of Historian, user credentials may still include "wwUser" in the user name. wwUser is not a system administrator level and will error out when logging into Historian Client during first time use.
When you open Historian Client, and click Tools > Servers. The Server List Configuration dialog box appears, but you may receive the following error.
This can programmatically done through the Microsoft SQL Query Analyzer in the SQL Management Studio.
GRANT VIEW DEFINITION ON [dbo].[aaManualTagInsert] TO [wwUsers]
GRANT VIEW DEFINITION ON [dbo].[aaManualTagInsert] TO [aaUsers]
GRANT VIEW DEFINITION ON [dbo].[aaManualTagSingleValueInsert] TO [wwUsers]
GRANT VIEW DEFINITION ON [dbo].[aaManualTagSingleValueInsert] TO [aaUsers]
Restart the SQL Server service by right clicking on the name of the Server in the SQL Management Studio.
You can now log in to the Historian Client trend using "wwUser" upon first use for other client connections in your facility.