5 Replies Latest reply on Oct 18, 2018 7:38 AM by johndy

    (New to PI) PI Vision Connection to SQL Server Problem

    johndy

      Can someone help me how to connect this to my AF-SVR Server?

       

        • Re: (New to PI) PI Vision Connection to SQL Server Problem
          John Messinger

          So a few questions to help understand the actual issue:

           

          1. Is your SQL Server running on the same machine as PI Vision, or a separate server? (From the error it looks like a local connection via named pipes)

           

          2. Is your SQL Server running as the default instance (machine name), or a Named Instance?

           

          3. Does the account you are logged in to PI Vision as have access rights to the SQL Server (needs sysadmin to create the database)

           

          4. Can you connect to the SQL Server instance using SQL Server Management Studio?