September 5, 2011 at 10:50 am
I have re-installed my SQL and the default instance of SQL 2008. I have restored the databases including the ReportServer and the ReportServerTempDB databases. I have re-installed SSRS 2008. I can access the ReportManager and Report screens but when I try to run a report I get a screen request a name and password. It will not accept any windows login I type including a domain administrator. I get the following screen:
An error occurred during client rendering.
An error has occurred during report processing.
Cannot create a connection to data source 'contacts'.
The ConnectionString property has not been initialized
I am able to access the other databases from my website located on the SQL box but I cannot access the SQL data from another computer on the same domain. This feels like a SQL permissions issue but for the life of me I cannot figure out what it is. Is there a laundry list of things to look for when accessing SQL databases from a web site and accessing SQL databases from SSRS?
Thanks
Chuck
September 6, 2011 at 12:39 am
Chuck 17099 (9/5/2011)
I have re-installed my SQL and the default instance of SQL 2008. I have restored the databases including the ReportServer and the ReportServerTempDB databases. I have re-installed SSRS 2008. I can access the ReportManager and Report screens but when I try to run a report I get a screen request a name and password. It will not accept any windows login I type including a domain administrator. I get the following screen:An error occurred during client rendering.
An error has occurred during report processing.
Cannot create a connection to data source 'contacts'.
The ConnectionString property has not been initialized
I am able to access the other databases from my website located on the SQL box but I cannot access the SQL data from another computer on the same domain. This feels like a SQL permissions issue but for the life of me I cannot figure out what it is. Is there a laundry list of things to look for when accessing SQL databases from a web site and accessing SQL databases from SSRS?
Thanks
Chuck
I ain't an expert in it but get a feeling that you might be getting blocked by some authentication issues. Best way to figure out is to go to the report server directory in your physical drive and you will have a folder called 'LogFiles'. Find the latest log from it and scroll down to the recent timestamp. I always choose to find a keyword called' error' and move to the bottom of the log file. In that portion, you will find some weird stuff written but certainly you will find some reasons giving errors for you. Post that error and then someone can help you in a better way here.
Chandan
September 6, 2011 at 6:34 am
Good morning Chandan,
Thanks for your reply. I checked the SQL server log and there are not entries at the time of the error. I also check the SSRS log and could see nothing I understood.
Chuck
September 6, 2011 at 6:47 am
Chuck 17099 (9/6/2011)
Good morning Chandan,Thanks for your reply. I checked the SQL server log and there are not entries at the time of the error. I also check the SSRS log and could see nothing I understood.
Chuck
good morning. You don't have to go to SQL Server logs.You need to check report server logs. Ok tell me what location in windows explorer did you surf for the log that you saw?
It should be something like:
Drive:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles
Thats why I said. Search for a folder called LogFiles in your reportserver directory. And find the latest log from there.
September 6, 2011 at 7:12 am
Hi Chandan,
The logfile pretty much shows the same thing as the web page plus a bunch of stuff I don't understand. I'll copy it here in case it makes any sense to you.
webserver!ReportServer_0-2!13f0!09/06/2011-07:29:37:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'contacts'. ---> System.InvalidOperationException: The ConnectionString property has not been initialized.
at System.Data.SqlClient.SqlConnection.PermissionDemand()
at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.ReportingServices.DataExtensions.ConnectionExtension.Open()
at Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper.Open()
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.OpenDataExtensionConnection(DataSource dataSourceObj, OnDemandProcessingContext pc, CreateDataExtensionInstance createDataExtensionInstance)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.OpenDataExtensionConnection(DataSource dataSourceObj, OnDemandProcessingContext pc, CreateDataExtensionInstance createDataExtensionInstance)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessingContext.CreateAndSetupDataExtensionInstance(DataSource dataSource, DataSet dataSet, OnDemandProcessingContext pc)
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.OpenConnection(DataSource dataSourceObj, DataSet dataSetObj, OnDemandProcessingContext pc, RunningJobContext jobContext)
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.Process()
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.OnDemandProcessing.OnDemandProcessingContext.AbortHelper.ThrowAbortException(String reportUniqueName)
at Microsoft.ReportingServices.OnDemandProcessing.OnDemandProcessingContext.CheckAndThrowIfAborted()
at Microsoft.ReportingServices.OnDemandProcessing.RetrievalManager.FetchData(Boolean mergeTran)
at Microsoft.ReportingServices.OnDemandProcessing.RetrievalManager.PrefetchData(ReportInstance reportInstance, ParameterInfoCollection parameters, Boolean mergeTran)
at Microsoft.ReportingServices.OnDemandProcessing.Merge.FetchData(ReportInstance reportInstance, Boolean mergeTransaction)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessOdpReport(Report report, OnDemandMetadata odpMetadataFromSnapshot, ProcessingContext pc, Boolean snapshotProcessing, Boolean reprocessSnapshot, Boolean processUserSortFilterEvent, Boolean processWithCachedData, ErrorContext errorContext, DateTime executionTime, IChunkFactory cacheDataChunkFactory, StoreServerParameters storeServerParameters, GlobalIDOwnerCollection globalIDOwnerCollection, SortFilterEventInfoMap oldUserSortInformation, EventInformation newUserSortInformation, String oldUserSortEventSourceUniqueName, ExecutionLogContext executionLogContext, OnDemandProcessingContext& odpContext)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension newRenderer, DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory cacheDataChunkFactory, IChunkFactory yukonCompiledDefinition, Boolean& dataCached)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory yukonCompiledDefinition)
at Microsoft.ReportingServices.Library.RenderLive.CallProcessingAndRendering(ProcessingContext pc, RenderingContext rc, OnDemandProcessingResult& result)
at Microsoft.ReportingServices.Library.RenderStrategyBase.ExecuteStrategy(OnDemandProcessingResult& processingResult)
at Microsoft.ReportingServices.Library.ReportExecutionBase.InternalExecuteReport()
at Microsoft.ReportingServices.Library.ReportExecutionBase.Execute()
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at Microsoft.ReportingServices.Library.ExecutionDisposerProxy.ExecuteReport()
at Microsoft.ReportingServices.Library.RenderReportAction.PerformExecution()
at Microsoft.ReportingServices.Library.RenderReportAction.Render()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
September 6, 2011 at 8:32 am
Chuck 17099 (9/6/2011)
Hi Chandan,The logfile pretty much shows the same thing as the web page plus a bunch of stuff I don't understand. I'll copy it here in case it makes any sense to you.
webserver!ReportServer_0-2!13f0!09/06/2011-07:29:37:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'contacts'. ---> System.InvalidOperationException: The ConnectionString property has not been initialized.
at System.Data.SqlClient.SqlConnection.PermissionDemand()
at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.ReportingServices.DataExtensions.ConnectionExtension.Open()
at Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper.Open()
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.OpenDataExtensionConnection(DataSource dataSourceObj, OnDemandProcessingContext pc, CreateDataExtensionInstance createDataExtensionInstance)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.OpenDataExtensionConnection(DataSource dataSourceObj, OnDemandProcessingContext pc, CreateDataExtensionInstance createDataExtensionInstance)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessingContext.CreateAndSetupDataExtensionInstance(DataSource dataSource, DataSet dataSet, OnDemandProcessingContext pc)
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.OpenConnection(DataSource dataSourceObj, DataSet dataSetObj, OnDemandProcessingContext pc, RunningJobContext jobContext)
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.Process()
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.OnDemandProcessing.OnDemandProcessingContext.AbortHelper.ThrowAbortException(String reportUniqueName)
at Microsoft.ReportingServices.OnDemandProcessing.OnDemandProcessingContext.CheckAndThrowIfAborted()
at Microsoft.ReportingServices.OnDemandProcessing.RetrievalManager.FetchData(Boolean mergeTran)
at Microsoft.ReportingServices.OnDemandProcessing.RetrievalManager.PrefetchData(ReportInstance reportInstance, ParameterInfoCollection parameters, Boolean mergeTran)
at Microsoft.ReportingServices.OnDemandProcessing.Merge.FetchData(ReportInstance reportInstance, Boolean mergeTransaction)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessOdpReport(Report report, OnDemandMetadata odpMetadataFromSnapshot, ProcessingContext pc, Boolean snapshotProcessing, Boolean reprocessSnapshot, Boolean processUserSortFilterEvent, Boolean processWithCachedData, ErrorContext errorContext, DateTime executionTime, IChunkFactory cacheDataChunkFactory, StoreServerParameters storeServerParameters, GlobalIDOwnerCollection globalIDOwnerCollection, SortFilterEventInfoMap oldUserSortInformation, EventInformation newUserSortInformation, String oldUserSortEventSourceUniqueName, ExecutionLogContext executionLogContext, OnDemandProcessingContext& odpContext)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension newRenderer, DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory cacheDataChunkFactory, IChunkFactory yukonCompiledDefinition, Boolean& dataCached)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory yukonCompiledDefinition)
at Microsoft.ReportingServices.Library.RenderLive.CallProcessingAndRendering(ProcessingContext pc, RenderingContext rc, OnDemandProcessingResult& result)
at Microsoft.ReportingServices.Library.RenderStrategyBase.ExecuteStrategy(OnDemandProcessingResult& processingResult)
at Microsoft.ReportingServices.Library.ReportExecutionBase.InternalExecuteReport()
at Microsoft.ReportingServices.Library.ReportExecutionBase.Execute()
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at Microsoft.ReportingServices.Library.ExecutionDisposerProxy.ExecuteReport()
at Microsoft.ReportingServices.Library.RenderReportAction.PerformExecution()
at Microsoft.ReportingServices.Library.RenderReportAction.Render()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Ok.so you enter user name and password on the report page and then it gives an error. Post the error on report page that you get from front end from IE. also before that:
did you note an error in the logs above: Cannot create a connection to data source 'contacts'
Make sure that this data source is proper and do a test connection on it. I think you lost all encrypted content so you need to set up the data source again. Please do so and then we will take it from here.
Thanks
Chandan
September 6, 2011 at 9:12 am
I opened the project in visual studio, created a new connection and assigned the connection to the query. I can run the report in visual studio with either the old or new connection but when I go to deploy the project I am challenged for a login and password. It will not accept either of two domain administrator passwords. Sense I cannot deploy the project I cannot test the new connection.
It's looking more and more like a SQL permissions issue but it shouldn't be. The SQL server is set to window authentication and the two referenced logins are in the sysadmin server role. One of the users is the database owner of the contacts database and the other is in the dbo database role.
I'm lost here.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply