Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 EEK!

Author  Topic 

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2005-03-03 : 06:17:15
I've just put RS evaluation edition on my machine and am trying to create my first report (to be honest am very uncertain what I am doing).

I have a sproc on my SQL server that pulls the data I want to show and I can run that fine (am using SQL authentication)

When I try to preview the report I keep getting

An error has occured during report processing. Cannot create a connection to datasource 'MySource'. Login failed for user 'MySQLUserName'

I can see the data, it's just that every time I mess about to fix this I get back to the same problem.

Does anyone have any clues?

thanks

steve



And how is education supposed to make me feel smarter? Besides, every time I learn something new, it pushes some old stuff out of my brain.

jhermiz

3564 Posts

Posted - 2005-03-03 : 13:06:08
Did you create a data source? RDS file ? The RDS contains the login information and credinationals used to process your request. It looks like you have not specified a user and password for the report.

Make sure you do that. Best thing to do also is to create a role and associate a user to that role specifically for running stored procedures used for reports.

RS is good stuff...sometimes :)

Jon



Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Imperfection living for perfection --
[url]http://jhermiz.blogspot.com/[/url]
Go to Top of Page

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2005-03-04 : 03:04:42
Thanks Jon I'll look into that.

As you may have guessed, I am ok with the SQL server side of things but RS and particularly Visual Studio.NET is new to me. Haven't used Visual Studio much since version 6 was new

steve

And how is education supposed to make me feel smarter? Besides, every time I learn something new, it pushes some old stuff out of my brain.
Go to Top of Page
   

- Advertisement -