SSAS data connection issues

Issue: Test Connection failure

Symptom:

  • You get the error below when you try to test the connection to a SQL Server Analysis Services (SSAS) database:

    Test failed: Either the user, NT AUTHORITY\NETWORK SERVICE [or the account you're using], does not have access to the [your SSAS db name] database, or the database does not exist.

Resolution:

 


Issue: Unable to connect using Windows Impersonation with Specified credentials

Symptom:

  • You are trying to connect to a SSAS (SQL Sever Analysis Services) database on the same machine as Dundas BI.
  • Test Connection fails with error similar to: Either the user, NT AUTHORITY\NETWORK SERVICE does not have access ...

Resolution:

  • Make sure the Relay Credentials option is unchecked. This option only applies when making outbound network connections, which is not the case in this scenario because you are connecting to a database on the same machine as Dundas BI.

See also

Dundas Data Visualization, Inc.
400-15 Gervais Drive
Toronto, ON, Canada
M3C 1Y8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri