I can't connect the LLBLGen 5 designer to the Azure SQL Database. Always get a Login fail. But If I use the MS SQL Manager 18, it connects fine.

eirizarry wrote:

I can't connect the LLBLGen 5 designer to the Azure SQL Database. Always get a Login fail. But If I use the MS SQL Manager 18, it connects fine.

Hi there!

What LLBLGen version are you using? In older versions you had to connect to a normal MSSQL instance, and then in runtime you could change the connecction string. Howerver in newer versions you can connect directly to Azure. See this note in the documentation:

If you're connecting to an Azure SQL Server instance using Azure Active Directory, be sure to check the checkbox 'Use azure active directory' in the database connection information dialog when connecting to the database. You can then use 'WindowsAuthentication' for Azure AD integrated connections and 'DatabaseSpecificAuthentication' for Azure AD Password connections.

Is version 5.0.5

eirizarry wrote:

Is version 5.0.5

The feature David refers to has been added in v5.6.1, so v5.0.5 won't work indeed, unless you use native SQL Server credentials. Windows credentials require Azure AD and that requires a different connection string v5.0.5 can't create