Adding new SSRS server to the existing scale-out deployment.
Adding new SSRS server to the existing scale-out deployment.
------------------------------
Report Server 10.0.2531.0
Hello,
We have two SSRS servers in our scale-out deployment. We need to add third server. But when I try (using Reporting Services Configuration manager) to make the new server use existing SSRS database in the scale-out deployment, the last screen of Report
Server Database Configuration Wizard having completed first two steps (Verifying database sku and Applying connection rights) is trying during about 20 min. to complete the last step (Applying connection rights) and always fails with the following error:
System.Data.SqlClient.SqlException: Timeout expired.
The timeout period elapsed prior to completion of the operation or the server is not responding.
Changed database context to 'ReportServer$SSRS01'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(SqlConnection conn, String script, ICommandWrapperFactory commandWrapper)
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)
What could be the reason and what should be done to avoid it?
Thank you,
Alex
October 27th, 2010 2:39pm
Can you run a profiler trace to see what is happening at the SQL end to see whether the SQL Connection is timed out or command time out?
Suresh
http://skamie.wordpress.com
Free Windows Admin Tool Kit Click here and download it now
October 28th, 2010 2:29am