reporting services connection error

I think i've tried everything. I have sql server installed on my machine and vs.net as well. I have the report server on another machine. I've made reports in vs.net and deployed them and they show up in the report manager but when i go to view i get the error:

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'SANDO'. (rsErrorOpeningConnection)
SQL Server does not exist or access denied.

what sort of connection type should i use and can someone tel lme the steps to get this to work right?

any help would be appreciated

thanks so much

Check the definition of the data source 'SANDO'. It seems the SQL server name is invalid, or something is not correctly specified.|||Delete the datasource and all the rdl files from the reportserver and redeploy them again.|||I tried doing the deleting several times and it didn't work.|||How do i check the definisiton of the data source? I know the name is SANDO but is there a different way i should be checking?|||

Hi,

ok, seems that the database server is not reachable from the reporting server. This could be based on various problems:

- Depending on your infrastructure the name of the server cannot be resolved (Solution: Use the IPAdress instead), try to ping the database server name from the reporting server to see if the name can be resolved.
- The IpAdress / the server cannot be reached. (Solution: Find a way to gain access to the database server from your reporting server)
- THe user name you are using to get data from the report server is wrong. Make sure that if you have chosen SQL Server Authentication, that the server accepts this authentication and that the Login Name and password is correct. if you are using Windows Authentication, make sure that if you are using Integrated Authentication, based on wheter the user credentials (The guy that opens up the Report / Report Manager) has access to the Server or if you are using Anonymous Authentication, that the service Account that IIS is running has the appropiate permissions to access the database.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

On the report page (where you see the error), there should be a ""Properties" tab. Click that and a "Data source" tab should show up.

Another way is to open the properties page of the report from SQL server management studio.

If SANDO is a shared data source, you should be able to view/modify its properties as well.