June 22, 2021 at 12:08 am
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.
June 22, 2021 at 2:21 pm
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply