SQL Server Data Connection Issues

Issue: Unable to discover database structure

Symptom:

Resolution:

The account you're using to log-on needs to have db_datareader role on the db.

 


Issue: Unable to connect using Specified Windows credentials

Symptom:

  • Your Dundas BI server and SQL Server are on the same machine.
  • When you try to create a new data connector using Specified Windows credentials, you receive an error similar to: Cannot open database 'AdventureWorks2012' requested by the login. The login failed. Login failed for user 'NT AUHTORITY\NETWORK SERVICE'.

Error connecting to SQL database
Error connecting to SQL database

Resolution:

  1. Edit the data connector and go to the Specified Windows credentials section.
  2. Make sure the Relay Credentials option is turned off (uncheck the option). This option only applies when making an outbound network connection, which is not the case in this scenario because you are connecting to a database on the same machine.

Uncheck Relay Credentials option
Uncheck Relay Credentials option

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