AnsweredAssumed Answered

AF on Azure SQL

Question asked by Roger Palmen on May 26, 2016
Latest reply on Mar 14, 2018 by abrodskiy

Before digging into this, has anyone tried to install AF (PIFD database) on an Azure SQL database? And succeeded? So not a SQL Instance manually installed in a VM, but Azure SQL.

 

Using AF2016, manual PIFD install procedure, i get the following error:

et -Q "PRINT GETDATE( );"
HResult 0x9E53, Level 20, State 1
Server name cannot be determined.  It must appear as the first segment of the se
rver's dns name (servername.database.windows.net).  Some libraries do not send t
he server name, in which case the server name must be included as part of the us
er name (username@servername).  In addition, if both formats are used, the serve
r names must match.
"SQL Server 2008 (or later) is required."

 

Yes, i know it's not supported, but sometimes one must check where the limits are...

Outcomes