André Åsheim

PI Vision - Azure SQL - Azure AD

Discussion created by André Åsheim Champion on Mar 27, 2020
Latest reply on Sep 16, 2020 by André Åsheim


I have an issue trying to connect PI Vison to a Azure SQL server that users Azure Integrated Security.


Error while testing for SQL Server connectivity: Windows logins are not supported in this version of SQL Server.


I've googled arround and found some exaples on how to connect to Azure SQL using Azure Integraded Security but I had no success with this yet.


My (current) Connection string

<add name="PIVisionConnectionString"
Initial Catalog=Coresight;
Authentication=Active Directory Integrated;
Application Name=&quot;PI Visualization Web Service&quot;"

providerName="System.Data.SqlClient" />