none
Using DPM 2010 to protect Sharepoint 2010 RRS feed

  • Question

  • We are using Kerberos authentication in our Sharepoint environment. I can run the configuresharepoint.exe command and actually create the protection group, However there are no item level restore points. I have waited more than 24 hours and still nothing. I have had the catalog alerts from DPM  ID 3133. In looking at the wsscmdletswrappercurr.errlog I get the following.

    WARNING --------------------------------------------------
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1282)   WARNING Exception Message   =
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1282)   WARNING Cannot open database "StateService_27d1148bfcb142aabcc06cb781f5b084" requested by the login. The login failed.
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1282)   WARNING Login failed for user 'test\farm_admin'.
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283)   WARNING Exception Stack     =
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283)   WARNING    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283)   WARNING    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283)   WARNING    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283)   WARNING    at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283)   WARNING    at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283)   WARNING    at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283)   WARNING    at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283)   WARNING    at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283)   WARNING    at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283)   WARNING    at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283)   WARNING    at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283)   WARNING    at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283)   WARNING    at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283)   WARNING    at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283)   WARNING    at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283)   WARNING    at System.Data.SqlClient.SqlConnection.Open()
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283)   WARNING    at WSSCmdlets.CDatabase.IsGreaterThanSql2k()
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283)   WARNING    at WSSCmdlets.CDatabase..ctor(SPDatabase spDatabase)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283)   WARNING    at WSSCmdlets.WssSqlAliasHelper.InitializeSqlAliasInstanceNameMappings()
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1284)   WARNING Inner Exception     =
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1285)   WARNING Exception String    =
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1285)   WARNING System.Data.SqlClient.SqlException: Cannot open database "StateService_27d1148bfcb142aabcc06cb781f5b084" requested by the login. The login failed.
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1285)   WARNING Login failed for user 'test\farm_admin'.
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1285)   WARNING    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1285)   WARNING    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1285)   WARNING    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1285)   WARNING    at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1285)   WARNING    at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1285)   WARNING    at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1285)   WARNING    at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1285)   WARNING    at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1285)   WARNING    at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1285)   WARNING    at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1285)   WARNING    at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1285)   WARNING    at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1285)   WARNING    at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1285)   WARNING    at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1285)   WARNING    at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1285)   WARNING    at System.Data.SqlClient.SqlConnection.Open()
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1285)   WARNING    at WSSCmdlets.CDatabase.IsGreaterThanSql2k()
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1285)   WARNING    at WSSCmdlets.CDatabase..ctor(SPDatabase spDatabase)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1285)   WARNING    at WSSCmdlets.WssSqlAliasHelper.InitializeSqlAliasInstanceNameMappings()

     

    Am I getting these errors because of Kerberos authentication or any other ideas?


    Michael Bishop
    • Moved by MarcReynolds Tuesday, January 11, 2011 2:55 PM (From:Data Protection Manager)
    Monday, January 10, 2011 10:40 PM

All replies

  • Kerberos authentication could be causing the problem but DPM shouldn’t care if you are using Kerberos or NTLM.  You need to perform additional steps to create and configure Service Principal names in AD for SharePoint to use Kerberos authentication.  There are steps that outline how to “Configure Kerberos authentication (SharePoint Server 2010)” at http://technet.microsoft.com/en-us/library/ee806870.aspx including how to verify that the SPN’s are configured and how to check if Kerberos authentication is working.

    You can also force the cataloging to run outside the normal nightly run time.  Follow the steps below to start the catalog job and report back with the alert DPM receives if the job fails.

     

     

    First we need to get the protection group for SharePoint by pulling all of the protection groups on the server (for this, the DPM server will be DPM01 protecting SharePoint farm on server SharePoint01):

     

    PS C:\Program Files\Microsoft DPM\DPM\bin> $PG = Get-ProtectionGroup -DPMServerName DPM01


    Now we will see what protection groups are available so we can choose the one we need:

     

    PS C:\Program Files\Microsoft DPM\DPM\bin> $PG


    Name    Protection method
    ----    -----------------
    V14-Sharepoint   Short-term using disk
    Exchange-2010-DAG1  Short-term using disk
    clients   Short-term using disk
    SQL PROTECTION on DC1  Short-term using disk

     

    In this case, the protection group we need is V14-Sharepoint, so we need to pull that datasource from the protection group list:


    PS C:\Program Files\Microsoft DPM\DPM\bin> $ds = get-datasource $PG[0]

     

    Note: The 0 in $PG[0] was based on the list returned.  We start counting with 0.  If our SharePoint protection group was “clients”, then we would have used $PG[2].  If there is only one protection group, then you would use $PG and not have to specify a number.

     

     

    To be sure we have the correct datasource, we can list what we have for $ds


    PS C:\Program Files\Microsoft DPM\DPM\bin> $ds

    Computer   Name     Type
    --------   ----     ----
    SharePoint01  Sharepoint Farm\SharePo... SharePoint Farm

     

    Once we have confirmed the datasource is in fact a SharePoint protection on the SharePoint server we want to affect, we can run the command to start the incremental catalog.

     

    PS C:\Program Files\Microsoft DPM\DPM\bin> Start-CreateCatalog -datasource $ds

     

    JobCategory   Status  HasCompleted
    -----------   ------  ------------
    SharePointCatalog  InProgress  False


     

     

    Wednesday, January 12, 2011 10:27 PM
    Moderator
  • I followed all the steps mentioned above and i am still getting following message in the DPM console monitor tab. Could this be problem with my rights on the sharepoint farm.

     

    Affected area:    Sharepoint Farm\SPS\SharePoint_Config
    Occurred since:    1/24/2011 4:02:50 PM
    Description:    DPM failed to gather item level catalog for 1 database(s) of the SharePoint Farm Sharepoint Farm\SPS\SharePoint_Config on . Some of the recovery points for these databases in the farm would be associated with an earlier successful catalog. (ID 3133)
        More information
    Recommended action:    
        To re-run the catalog job manually for the farm, run Start-CreateCatalog command in PowerShell.
    Resolution:    DPM automatically changes this alert's status to inactive 10 days after it is issued.To dismiss the alert, click below
        Inactivate alert

    Monday, January 24, 2011 9:28 PM
  • Check to see if the registry key HKLM\Software\Microsoft\Shared Tools\Web Server Extensions\12.0 is present.  A third party product could have added this key.  There is a feature in Windows server 2008 R2 which creates the very same key HKLM\Software\Microsoft\Shared Tools\Web Server Extensions\12.0.  The feature is called "Windows TIFF IFilter"

    If the HKLM\Software\Microsoft\Shared Tools\Web Server Extensions\12.0 is present - export that key then delete it.

     

    Monday, February 7, 2011 9:12 PM
    Moderator
  • Hi, I am getting the same error "DPM failed to gather item level catalog for 6 database(s) of the SharePoint Farm Sharepoint Farm\sql2k8\SharePoint_Config.........". The moss box was a 2007 which I upgraded to 2010. I had the hive 12 which I deleted from registry.

    I execute the code indicated, My Moss protection grp is the first one , when I issue $ds, I get several lines where there are all my DBs as follows .

    Computer                        Name                            Type
    --------                        ----                            ----
    SQL2K8                          SQL2K8\SPDiagTest               SQL Server 2008 database
    SQL2K8                          SQL2K8\AdventureWorksDW2008     SQL Server 2008 database
    SQL2K8                          SQL2K8\msdb                     SQL Server 2008 database
    SQL2K8                          SQL2K8\SS1_DB                   SQL Server 2008 database
    SQL2K8                          SQL2K8\SessionStateService_d... SQL Server 2008 database
    SQL2K8                          SQL2K8\SS1 - Search Service_... SQL Server 2008 database
    SQL2K8                          SQL2K8\ReportServerTempDB       SQL Server 2008 database
    SQL2K8                          SQL2K8\ServiceBRepository       SQL Server 2008 database
    SQL2K8                          SQL2K8\BusinessServiceReposi... SQL Server 2008 database
    SQL2K8                          SQL2K8\WSS_WebAnalytic_Repor... SQL Server 2008 database
    SQL2K8                          SQL2K8\SS1_UserProfile_a8f13... SQL Server 2008 database
    SQL2K8                          SQL2K8\SS1_Search_DB            SQL Server 2008 database
    SQL2K8                          SQL2K8\WSS_Content_TFS2010      SQL Server 2008 database
    SQL2K8                          SQL2K8\STS_Config_TFS           SQL Server 2008 database
    SQL2K8                          SQL2K8\ReportServerSPSTempDB    SQL Server 2008 database
    SQL2K8                          SQL2K8\Tfs_Configuration        SQL Server 2008 database
    SQL2K8                          SQL2K8\Secure_Store_Service_... SQL Server 2008 database
    SQL2K8                          SQL2K8\ConfigurationManagement  SQL Server 2008 database
    SQL2K8                          SQL2K8\ReportServer             SQL Server 2008 database
    SQL2K8                          SQL2K8\ServiceARepository       SQL Server 2008 database
    SQL2K8                          SQL2K8\WSS_Search_MOSS_c17f1... SQL Server 2008 database
    SQL2K8                          SQL2K8\SS1_UserProfile_ddb78... SQL Server 2008 database
    MOSS                            Computer\System Protection      System Protection
    SQL2K8                          SQL2K8\WCFPersistence           SQL Server 2008 database
    MOSS                            Sharepoint Farm\sql2k8\Share... SharePoint Farm
    SQL2K8                          SQL2K8\ReportServerSPS          SQL Server 2008 database
    SQL2K8                          SQL2K8\PPSServiceApp1_447e56... SQL Server 2008 database
    SQL2K8                          SQL2K8\MarketIndexData          SQL Server 2008 database
    SQL2K8                          SQL2K8\STS_Content_TFS          SQL Server 2008 database

     

    However, when I issue the command : Start-CreateCatalog -datasource $ds

    I get the following error :

    PS C:\Program Files\Microsoft DPM\DPM\bin> Start-CreateCatalog -datasource $ds


    Start-CreateCatalog : Cannot convert 'System.Object[]' to the type 'Microsoft.Internal.Enterpr
    iseStorage.Dls.UI.ObjectModel.OMCommon.Datasource' required by parameter 'Datasource'. Specified method is not supported.
    At line:1 char:32
    + Start-CreateCatalog -datasource <<<<  $ds
        + CategoryInfo          : InvalidArgument: (:) [Start-CreateCatalog], ParameterBindingException
        + FullyQualifiedErrorId : CannotConvertArgument,Microsoft.Internal.EnterpriseStorage.Dls.UI.Cmdlet.ProtectionCmdLets.CreateCatalogCmdlet

    Sunday, June 5, 2011 9:58 AM
  • To PSBMichaelB - The errorlog says an access denied issue for test\farm_admin. Can you connect to the specified database using the specified login from SQL Management Studio?

    WARNING Cannot open database "StateService_27d1148bfcb142aabcc06cb781f5b084" requested by the login. The login failed.
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1282) WARNING Login failed for user 'test\farm_admin'.
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283) WARNING Exception Stack =
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283) WARNING at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283) WARNING at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
    0EA8 0494 01/10 21:17:05.271 31 WSSCmdlets.cs(1283) WARNING at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

    To Elissal - The Cmdlet is valid only for SharePoint datasources. In your case it is the datasource on server MOSS with name SharePoint Farm\sql2k8\.... Thus in your case the command would look like Start-CreateCatalog - datasource $ds[24].

     


    Regards, Deepan [This posting is provided "AS IS" with no warranties, and confers no rights.] [P.S. If the post answers your question or guides you about what you're looking for, please mark it as answered.]
    Monday, June 6, 2011 5:25 AM
    Moderator