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 |
|
zolf
Starting Member
15 Posts |
 Posted - 2007-10-16 : 03:11:58
|
| Hello there,I have created a report with MySQL using ODBC connection.It works on my localhost server.then when i deployed it on the production server i get error saying.i checked my data source connection to my localhost and both have the same setting.what could be wrong.please help i am very desperate to make this work.thanks.An error has occurred during report processing.Cannot create a connection to data source 'Payment'.For more information about this error navigate to the report server on the local server machine, or enable remote errors |
|
|
Will H
Yak Posting Veteran
56 Posts |
Posted - 2007-10-16 : 11:19:59
|
| Sounds like your localhost has permissions to the db, but the production server doesnt. Are you authenticating via Windows authentication?? What is the process running on in your local machine vs the production box?? Go to Start-->Sql-->Config Tools-->Report services Configuration and see what the web service or windows service is running as on each box.---------------------------------------------------------SSRS Kills Kittens. |
 |
|
|
zolf
Starting Member
15 Posts |
Posted - 2007-10-17 : 00:22:05
|
| i have the username,password in the connection string.what does windows authentication been here.i get confused between this term and when it says store credentials.what is the difference and which is better |
|
|
|
|
|
|
Cannot open report on Production Server