i’ve a sharepoint deployment with one SQL Server (operating on VM) internet hosting the config DB and one other SQL Server (Bodily Host as a result of VM was operating out of house) to host the large Content material DBs. I must schedule automated backups of the Content material DBs to a community share. For that i must run the SQL Server Service with an account having permissions to the share as prompt in https://help.microsoft.com/kb/207187?wa=wsignin1.0
I attempted altering the logon as a service account to a site account which has permissions to the Community Share and can be in native Directors group of SQL Server and has “public and sysadmin” roles in SQL Server however that induced a difficulty. the SharePoint Net Utility began displaying a White Display screen so I needed to revert again to the default accounts i.e. NT ServiceSQLSERVERAGENT and NT ServiceMSSQLSERVER. I considered the occasion logs . These are the kinds of error i acquired after altering the logon as a service account to a site account
1) Info Rights Administration (IRM): Retried too many occasions to initialize IRM shopper. Can’t retry extra. Retried occasions is:0x5.
- System
- Supplier
[ Name] Microsoft-SharePoint Merchandise-SharePoint Basis
[ Guid] {6FB7E0CD-52E7-47DD-997A-241563931FC2}
EventID 5148
Model 15
Stage 2
Job 9
Opcode 0
Key phrases 0x4000000000000000 - TimeCreated
[ SystemTime] 2015-02-02T04:46:04.750899500Z
EventRecordID 176477 - Correlation
[ ActivityID] {8FACE59C-1E17-50D0-7135-25FDB824CDBE} -
Execution
[ ProcessID] 6912
[ ThreadID] 8872
Channel Utility
Pc -
Safety
[ UserID] S-1-5-21-876248814-3204482948-604612597-111753 - EventData
hex0 0x5
2) Unknown SQL Exception Zero occurred. Further error data from SQL Server is included under.
The goal principal title is wrong. Can’t generate SSPI context.
- System
- Supplier
[ Name] Microsoft-SharePoint Merchandise-SharePoint Basis
[ Guid] {6FB7E0CD-52E7-47DD-997A-241563931FC2}
EventID 5586
Model 15
Stage 2
Job 3
Opcode 0
Key phrases 0x4000000000000000 - TimeCreated
[ SystemTime] 2015-02-02T07:01:35.843757700Z
EventRecordID 176490 - Correlation
[ ActivityID] {50B4E59C-5E3A-50D0-7135-22AD91909F02} - Execution
[ ProcessID] 6912
[ ThreadID] 5452
Channel Utility
Pc - Safety
[ UserID] S-1-5-17 - EventData
int0 0
string1 The goal principal title is wrong. Can’t generate SSPI context.