André Åsheim

PI Vision - Azure SQL - Azure AD

Discussion created by André Åsheim Champion on Mar 27, 2020

Hi,

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

Error:

Error while testing for SQL Server sql-XXXXXXX.database.windows.net 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

<connectionStrings>
<add name="PIVisionConnectionString"
connectionString="Data Source=sql-XXXXXXXX.database.windows.net;
Initial Catalog=Coresight;
Authentication=Active Directory Integrated;
Application Name=&quot;PI Visualization Web Service&quot;"

providerName="System.Data.SqlClient" />

</connectionStrings>

Outcomes