August 24, 2005 at 12:36 pm
I'm having an odd problem. Reports work fine with usernameA and usernameB in our alpha environment. Move it to our beta environment, which should be the same. Upon testing, usernameA works fine, however, usernameB fails to run the report with the following error:
Cannot create a connection to data source 'datasource'. (rsErrorOpeningConnection)
Grants and permissions are correct for both usernames in both environments, the procedures are the same, the reports are the same. Any ideas on what this error means?
August 29, 2005 at 8:00 am
This was removed by the editor as SPAM
August 30, 2005 at 6:55 pm
I had the same error once, on a server migration too, but I turned out to be exactly what it says: I did not configured the connection properly.
This problem happens when you just "deploy" the dataset without configuring it for the new server/enviroment. Check your dataset configuration, (double-click the data set in the solution explorer of VS.Net), check the connection settings (re-type the pasword just in case) and then deploy the dataset again.
Hope it helps
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply