Can't preview in SSRS RSS

• • Reply
  

  dotnetdev02

  Member

  74 Points

  101 Posts

  Can't preview in SSRS

  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?

  Thanks 

• • Reply
  

  beharavenkat...

  Contributor

  2799 Points

  448 Posts

  Re: Can't preview in SSRS

  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.

  
  

  Please 'Mark as Answer' if my reply helped you..
  Nanda
  • Marked as answer by dotnetdev02 on Jun 28, 2010 05:27 PM