SSRS 2016 data source - Azure SQL DB not working

  • Hello!

    I am trying to create data source to connect to Azure SQL DB in SSRS 2016 ( SQL 2016 RTM version ), but getting this error message:

     

    ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source ''. ---> System.AggregateException: One or more errors occurred. ---> System.AggregateException: One or more errors occurred. ---> AdalException: The server name could not be resolved.

    at ADALNativeWrapper.ADALGetAccessToken(String username, IntPtr password, String stsURL, String servicePrincipalName, ValueType correlationId, String clientId, Boolean* fWindowsIntegrated, Int64& fileTime)occurred. --->

    Thanks in advance.

     

     

  • So, "server name could not be resolved" could be that you simply have the connection string wrong. However, more often is the fact that the IP address that the service is running under must have access to your Azure database through it's firewall. This is default behavior. Check there first.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply