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 AUTHORITHY\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 AUTHORITHY\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.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

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