Hi all, I am setting up a log-shipped DR farm. Following the TechNet article, and my content databases are in Standby mode as instructed, with the timer jobs specified disabled. This of course means that the databases are read-only too. When I try to provision the SSP on the DR farm, it fails with a bunch of error 7888 and 5782 in the event logs -- details below, but the gist is that it is trying to update a content db (which is read-only), presumably to tell it that the new SSP is in town. Obviously this doesn't work because of the database's state. I have tried assigning the web application another, dedicated content db (set to read-write), purely to allow the operation to complete, but the provisioning doesn't seem to like it and keeps going back after WSS_Content1. I've also tried setting WSS_Content1 to offline in central admin, to try and force the provisioning to point somewhere else. No dice. Am I doing anything obviously wrong? If not, any thoughts? How are we supposed to provision the SSP if the databases are set to read-only per the instructions? MOSS is SP2 with the Feb CU, and SQL Server is 2008 Enterprise SP1 (in both production and DR); they are on separate machines. Cheers! -- T *********** Errors ************ Event Type: Warning Event Source: Office SharePoint Server Event Category: Office Server Shared Services Event ID: 5782 Date: 04/05/2010 Time: 13:00:56 User: N/A Computer: xxxxxxxxxx Description: Provisioning for Shared Services Provider 'SSP1' has failed and will be retried. Reason: Failed to update database "WSS_Content1" because the database is read-only. Technical Support Details: System.Data.SqlClient.SqlException: Failed to update database "WSS_Content1" because the database is read-only. at System.Data.SqlClient.SqlConnection.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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command) at Microsoft.Office.Server.Data.SqlDatabaseManager.GrantAccess(String user) at Microsoft.Office.Server.Administration.SharedResourceProvider.SynchronizeAccessControl(SharedComponentSecurity sharedApplicationSecurity) at Microsoft.Office.Server.Administration.SharedResourceProvider.Microsoft.Office.Server.Administration.ISharedComponent.Install() at Microsoft.Office.Server.Administration.SharedResourceProvider.Provision() at Microsoft.Office.Server.Administration.SharedResourceProviderJob.Execute(Guid targetInstanceId) For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Event Type: Error Event Source: Office SharePoint Server Event Category: Office Server General Event ID: 7888 Date: 04/05/2010 Time: 13:00:56 User: N/A Computer: xxxxxxxxx Description: A runtime exception was detected. Details follow. Message: Failed to update database "WSS_Content1" because the database is read-only. Techinal Details: System.Data.SqlClient.SqlException: Failed to update database "WSS_Content1" because the database is read-only. at System.Data.SqlClient.SqlConnection.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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command) at Microsoft.Office.Server.Data.SqlDatabaseManager.GrantAccess(String user) at Microsoft.Office.Server.Administration.SharedResourceProvider.SynchronizeAccessControl(SharedComponentSecurity sharedApplicationSecurity) at Microsoft.Office.Server.Administration.SharedResourceProvider.Microsoft.Office.Server.Administration.ISharedComponent.Install() at Microsoft.Office.Server.Administration.SharedResourceProvider.Provision() For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.