Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jun 25, 2010 08:17 AM by firstname.lastname@example.org
Jun 24, 2010 05:44 PM|LINK
Seems silly, but I can't preview anything in any of my reports. I enter that parameter prompted for (or in some reports, no parameter required) and always get the response
An error occurred during local report processing
An error occurred during local processing
Cannot create a connection to data source 'datasourcename'
Login failed for user 'username'
Can't see what I'm doing wrong. Any ideas?
Jun 25, 2010 08:17 AM|LINK
1: select the Report and click on View Menu and click on Report data.
2: It will display the dataset fields and dataset name, top dataset, there will be shared data source, right click on that and select Datasource properties and click EDIT button, it will display datasource connection string and click on edit button, now
it will prompt the window with server name and database name. Also authentication Window/SQL server click on Test connection. Check whether you have permissions to logon into database server and able to connect the database.
If not then you don't have access to database and can't create connection.