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.
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?thankssteveAnd 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] |
|
|
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 newsteveAnd 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. |
|
|
|
|
|