PI Test Server - AVEVA
Our PI Server only has about 3000 tags, so the PI, AF, and SQL Servers are all on the same machine. We are not using ACE, but I have considered it for some applications in the future. …
AF Edit the database collection security - pisquare.osisoft.com
When the AF Server was installed it created a local group called AFServers on the SQL node and also configured the security in SQL for that particular group via the go.bat script. Also, if a …
Installation and upgrade - AVEVA
Sep 5, 2024 · We're planning to upgrade our SQL server (Windows 2012 R2/ SQL Enterprise 2014). This will be a new server build and not an in place upgrade. We do plan to upgrade the …
Getting data from PI to SQL Database - AVEVA
Like, RKthiresan said, PI RDBMS interface is an easy way of getting data out of PI and into a relational database. Other people might decide to create a SQL Server Job and use SQL …
Upgrade of SQL server - pisquare.osisoft.com
Basically, any new version of SQL is fine (including Express, but I would recommend Standard with AlwaysOn). System requirements for PI AF Server 2023 (aveva.com) Build your new SQL …
What does the Local AFServers group on the SQL Server do?
Jan 30, 2017 · The installation script for the AF PIFD SQL database includes the creation of the local group, a SQL login mapped to this local group, and the setting of the permissions for this …
Failed to connect to SQL Server while trying to install AF …
I have previously install the AF SQL database in the SQL Server machine and the PIFD database is created and running, i use a domain account to run the AF Application Service installation, …
PI integrator for BA - Delete view - AVEVA
Yes, you can delete the view directly in the SQL server, and yes, it is a manual process. The way I do is: · First delete the view through the PI Integrator UI. · Then delete the view in the SQL …
Retreiving Event Frame in SQL Server - AVEVA
Something of note about your use case to use SQL replication to move the PIFD information to a corporate server. Even if you move the PIFD database to another server, using any of our …
How to tell which SQL server contains the PIFD database used by …
Open the AFServer.exe.config file with a text editor. Scroll to connectString in the appSettings sections. You will find both the name of the SQL Server instance as well as the name of the …