Check security credentials and connections

To ensure that you have the required access permissions and that you can connect to each SQL Server in the collective, follow these steps:

1. Using the Windows credentials that you will use to create the collective, login to the workstation from which you will create the collective (do not do this on the SQL Server computer) and connect to each PI AF server that will be part of the collective.

2. On the same workstation, verify that you can perform a simple file share access to each SQL Server:

   1. Select Start > Run.

   2. Enter \\SQL_Server_computer_name for each SQL server.

      This ensures that your credentials authenticate to each SQL Server at the Windows level.

3. Establish a connection to each SQL Server via SQL Server Management Studio (SSMS) or sqlcmd.exe.

4. Once connected, run the following query:

   SELECT IS_SRVROLEMEMBER ('sysadmin') "is sysadmin", CURRENT_USER "connected as", SYSTEM_USER "login user" ;

   where

   "is sysadmin" returns 1=true, 0=false

   "connected as" returns "dbo"

   "login user" returns the user’s Windows user principal

   Note: Do not proceed until the connection and query succeeds for each SQL Server that will be part of your PI AF collective.