Delete local logins and user

When you install the PI AF SQL Server database with the SQL Script Execution feature selected, SQL scripts create and populate the PI AF SQL Server database (typically naming it PIFD) and create local SQL Server logins and AF database users. The PI AF application service is required to run under a domain account that belongs to a domain group; that domain group has a SQL Server login that is mapped to the PIFD database and is assigned specific database roles. As a result, you can delete the local user accounts that the SQL scripts create.

1. Open Microsoft SQL Server Management Studio, and connect to the SQL Server instance that stores the PI AF SQL Server database.

2. Expand Databases > PIFD > Security > Users.

3. Delete the PI AF database user:

   AFServers

   Deleting a user automatically deletes the corresponding schema, if one exists.