TN HistClient101 wwUser errors in .aaTrend file or opening Historian Client Trend directly

Description

• 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.

Details

This can programmatically done through the Microsoft SQL Query Analyzer in the SQL Management Studio.

USE Runtime
GO
GRANT VIEW DEFINITION ON [dbo].[aaManualTagInsert] TO [wwUsers]
GO
GRANT VIEW DEFINITION ON [dbo].[aaManualTagInsert] TO [aaUsers]
GO
GRANT VIEW DEFINITION ON [dbo].[aaManualTagSingleValueInsert] TO [wwUsers]
GO
GRANT VIEW DEFINITION ON [dbo].[aaManualTagSingleValueInsert] TO [aaUsers]
GO

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.