error

Im trying to use reporting services. I have the sql server running on my maching, ssn-1919, and i installed reporting services on my machine as well but the report server is on a different server which is ssn-002-007. I am running windows xp on my machine. I made the report with visual studio.net and it deploys fine. do i have t omake a data source as well? so when i go to view the report i get the errors:

An error has occurred during report processing. (rsProcessingAborted)Get Online Help

Cannot create a connection to data source 'SANDO'. (rsErrorOpeningConnection)Get Online HelpSQL Server does not exist or access denied.

I've been trying forever to figure this out and I can't...any ideas would be greatly appreciated

Like do I have to create a data source from visual studio also?|||Mary,

Is your datasource on the reportserver? You should be able to see it in the report manager.|||yes i do see that there. but i still get that error|||Does ASPNET user exist on your sql server? You have to give it permissions to the specific database the datasource is connecting to.

When you run it in development, it uses the current users' credentials.

When you run it in deployment, it runs under ASPNET, so you have to give that user account permission.

Please let me know if this helped|||how do i figure out if aspnet exists on my sql server? i checked under security if the user is specified and it is...i am using credentials as well.
and how do i run it under aspnet? thanks~!|||Mary,

Are you running a web program or windows program?

If you are using a asp application, when you deploy a web project, the IIS server runs the application under the ASPNET user.

To check your user credentials, right click on the database -> properties -> permissions and check to see if your server/ASPNET user is in there. If it isn't, then you have to add it, and give it the correct permissions.