September 27, 2011 at 7:24 am
Hello,
We had a report running for a while, the database location has moved and I just need to change the database location. I do now know much (if anything) about RS. So what I have managed to do is open the report up in visual studio and I have selected tools and the 'connect to database' option. I have added the SQL server and database in the 'Add connection' box. I have yet to press 'ok', but first I just needed to find out if I was even doing the right thing, because if I am not, I wont know how to go backwards and get out of it. I thought I'd change the data source within Report Manager, but perhaps not.
Appreciate the help.
D.
September 27, 2011 at 8:20 am
I would change it in the Report Manger first because that will get your report up and running. Then find the source project and fix it there as well.
September 27, 2011 at 8:38 am
Hi Daniel,
Thank you for getting back, what would I open the source project with? BIDS?
Since my first post, I have created a new data source, opened the report, gone to data source and selected the new data source I created and hit reply. However its not working. Does named pipes need to be available on the SQL Server, currently it is TCP/IP only. The error I am getting is as follows, I notice that it is not using the new data source I created.
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'Not the datasource I created'. (rsErrorOpeningConnection)
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
UPDATE:
I decided to alter the original database and appear to have got a step further, I now get the following error
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'Year'. (rsErrorExecutingCommand)
Invalid object name 'rs_the_name'.
It looks like I have to alter the report in some way.
Thank you for your help.
Regards,
D.
September 27, 2011 at 2:36 pm
If you are working in BIDS, there are several things to check. The first is the data source in the solution explorer. Then the next is the data source of the report, then finally the data source of the dataset of the report. Get those all in line and your report should work in BIDS.
September 28, 2011 at 3:57 am
Thanks for your help Daniel, all working now.
Regards,
D
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply