Unable to access the Azure Analysis services from Visual studio application

Question

Hello All,

I have deployed an Azure Analysis Service and enabled the firewall and Power BI. Users are able to access the Azure Analysis Service from Power BI, but they are unable to access it via Visual Studio from their desktops, receiving a network connection error.

Can you please suggest the sloution steps to fix the issue.

Error message:

mssql: Error 53: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Answer 1

Hi saravanan vaithilingam prasad,

Thanks for reaching out to Microsoft Q&A.

Check Firewall Settings:

• Ensure that the firewall settings on Azure Analysis Services allow connections from the IP addresses of the desktops trying to connect via Visual Studio.
• Add the necessary IP ranges or specific IP addresses to the Azure Analysis Services firewall rules.

Verify Server Name:

• Make sure that the server name being used in Visual Studio is correct. The server name should be in the format: asazure://<region>.asazure.windows.net/<server-name>.
• Double check that there are no typos or incorrect characters.

Ensure Remote Connections are Enabled:

• Verify that Azure Analysis Services is configured to accept remote connections. This is usually not an issue with AAS, but it's worth double-checking in the settings.

Check Visual Studio Configuration:

• Ensure that Visual Studio is up to date and that the correct extensions for Analysis Services are installed. Check that the connection type in Visual Studio is set to Analysis Services and not to SQL Server.

Test the Connection Using SQL Server Management Studio (SSMS):

• Try connecting to Azure Analysis Services using SSMS to determine if the issue is specific to Visual Studio or a broader connectivity issue. If SSMS connects successfully, the problem may be with Visual Studio configuration.

Check for Named Pipes Configuration:

• The error message references the Named Pipes Provider, which is typically used with SQL Server but not with Azure Analysis Services.
• Ensure that the connection settings in Visual Studio are not mistakenly configured to use Named Pipes. Instead, it should be set to connect via TCP/IP.

Network Configuration on Client Machines:

• Make sure that there are no network restrictions (e.g., corporate firewall, proxy settings) on the client machines that might block the connection to Azure Analysis Services.

Test from Different Networks:

• If possible, test the connection from a different network (e.g., a mobile hotspot) to rule out network-specific issues.

Review and Update AAS Role Assignments:

• Ensure that the users trying to connect via Visual Studio have the appropriate permissions assigned in Azure Analysis Services. If needed, review the role assignments in the AAS server.

Check Diagnostic Logs:

• Review the Azure Analysis Services diagnostic logs to see if there are any specific errors or warnings that might provide more insight into the connection issue.

Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.