ReportServer shuts down after accessing report
Hello, I have an application that accesses a sql server database and it works very well. I added a function to access reports on a report server in the same database and I've found that it opens the report (using the url) as it should, but after closing the report and going back to the application, it will not access the database. After waiting about 8 minutes, the application will again access the database. Appreciate any light anyone can shed on this... I've been looking for the solution for a couple days. Thank You!
October 26th, 2012 2:34pm
Hi FRtracer, From your description, do you mean the database that the custom application accesses and the report server database are in the same database engine? I have tried to reproduce the issue in my test environment, however, everything goes well. Here, I suggest that you manually stop the Reporting Services after closing the report, and then check whether the custom application can access the database immediately. Besides, please post more information about the issue for further analysis. Regards, Mike YinMike Yin TechNet Community Support
October 29th, 2012 9:38pm
Hi Mike, Thank You very much for the reply. I have worked with Sql Server quite a bit, but I am self taught. This is my first experience using Reporting Services. First, yes, the application database and the report server database are in the same database engine. Here are the symptoms: an application button opens an Inventory Form to access the database. The form works as expected, it will access the database without error. I can also close the form and re-open it and it re-opens and works without error. On the form is a button to access the reports by instantiating Report Form with a URL control with the reporting services url set for the url property to open. The URL control works as expected. The reporting services url opens and I can access the reports without error. I can close the reporting service form (which takes me back to the Inventory Form) and I can access the inventory without error. I can even access the Report Form and it opens the url and works without error. However, when I close the Inventory Form, and the focus goes back to the main form, and I try to open the Inventory Form again, I get an error "Cannot open user default database. Login failed. Login failed for user." The error occurs at one of my calls to a this.equipmentTableAdapter.Fill(this.InventoryDataSet.equipment) function call. If I restart the database engine, everything works without error again until I access the Inventory Form, open the Report Form, close the Inventory Form, and then try again to access the Inventory Form. It appears the Report Form is locking the database... Again, I really appreciate your assistance. Also, I did as you said. I stopped Reporting Services after closing the report. The application was not able to access the database. FRtracer
November 1st, 2012 10:32am