Contents
Are there any problems with SQL server connection?
The following additional errors can appear with rsErrorOpeningConnection. The user does not have permission to access the data source. If you are using a SQL Server database, verify that the user has a valid database user login.
Are there any performance problems with SQL Server?
Nothing so far indicated performance problems. Only parallel installation of SQL Server reporting services is not recommended. But a glance at the paging file (Paging File%Usage) did reveal a lurking issue. File usage was extremely high. This was caused by the 7GB limit on RAM assigned to SQL Server.
What should I do if my SQL Server is not started?
If it is not started, right-click the service, select Properties, in Startup Type select Automatic, click Apply, click Start, and then click OK. Verify that the report server URL and report server database connection string is correct.
Can a DBA fix all SQL Server problems?
A DBA cannot fix all problems and is also not responsible for their existence. But he should be able to indicate where they are located. It is also imperative that he does not use them merely as justification for ongoing problems, but also seeks to resolve the issue, for instance by collaborating with the vendor.
What does it mean when SQL Server does not exist?
If you get this error during report model generation, and the additional information section includes “SQL Server does not exist or access denied”, you might be encountering the following conditions: The connection string for the data source includes “localhost”. TCP/IP is disabled for the SQL Server service.
What does it mean to have a data source connection error?
This error indicates a data source connection error. You should check the connection string, and verify that you have permission to access the data source. If you are using Windows Authentication to access a data source, you must have permission to access the computer that hosts the data source.
What does rserroropeningconnection mean in SQL Server?
This error appears with a second error message that indicates the underlying cause. The following additional errors can appear with rsErrorOpeningConnection. The user does not have permission to access the data source.