Member_2_6492660_1
asked on
Sharepoint 2010 Event Error 3760
Windows 2012 R2 Server
IIS 8.5
SharePoint 2010 Farm SP2
Windows 2008 R2 Server
SQL 2008
Today the problems continue with my User Profile Sync issues first the service is stuck in starting which I have open issue with
And now I am getting this error
Log Name: Application
Source: Microsoft-SharePoint Products-SharePoint Foundation
Date: 7/20/2015 6:00:01 PM
Event ID: 3760
Task Category: Database
Level: Critical
Keywords:
User: mydom\spfarm
Computer: SERV013.FQDN.com
Description:
SQL Database 'User Profile Service Application_SyncDB_5d0b206 05e2e425c8 65e67f0a82 6f73c' on SQL Server instance 'serv010\sharepoint' not found. Additional error information from SQL Server is included below.
Cannot open database "User Profile Service Application_SyncDB_5d0b206 05e2e425c8 65e67f0a82 6f73c" requested by the login. The login failed.
Login failed for user 'mydom\spfarm'.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft-SharePoint Products-SharePoint Foundation" Guid="{6FB7E0CD-52E7-47DD- 997A-24156 3931FC2}" />
<EventID>3760</EventID>
<Version>14</Version>
<Level>1</Level>
<Task>3</Task>
<Opcode>0</Opcode>
<Keywords>0x40000000000000 00</Keywor ds>
<TimeCreated SystemTime="2015-07-20T22: 00:01.8557 69300Z" />
<EventRecordID>34621</Even tRecordID>
<Correlation ActivityID="{5E22266C-69E8 -4F06-B8AA -FFAA8477C 320}" />
<Execution ProcessID="6924" ThreadID="6000" />
<Channel>Application</Chan nel>
<Computer>SERV013.FQDN.com </Computer >
<Security UserID="S-1-5-21-305458857 1-13414595 84-7841283 02-3142" />
</System>
<EventData>
<Data Name="string0">User Profile Service Application_SyncDB_5d0b206 05e2e425c8 65e67f0a82 6f73c</Dat a>
<Data Name="string1">SERV010\sha repoint</D ata>
<Data Name="string2">Cannot open database "User Profile Service Application_SyncDB_5d0b206 05e2e425c8 65e67f0a82 6f73c" requested by the login. The login failed.
Login failed for user 'mydom\spfarm'.</Data>
</EventData>
</Event>
The database is online checked my SQL server
My research only found issue with the content database
How do I fix this?
IIS 8.5
SharePoint 2010 Farm SP2
Windows 2008 R2 Server
SQL 2008
Today the problems continue with my User Profile Sync issues first the service is stuck in starting which I have open issue with
And now I am getting this error
Log Name: Application
Source: Microsoft-SharePoint Products-SharePoint Foundation
Date: 7/20/2015 6:00:01 PM
Event ID: 3760
Task Category: Database
Level: Critical
Keywords:
User: mydom\spfarm
Computer: SERV013.FQDN.com
Description:
SQL Database 'User Profile Service Application_SyncDB_5d0b206
Cannot open database "User Profile Service Application_SyncDB_5d0b206
Login failed for user 'mydom\spfarm'.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft-SharePoint
<EventID>3760</EventID>
<Version>14</Version>
<Level>1</Level>
<Task>3</Task>
<Opcode>0</Opcode>
<Keywords>0x40000000000000
<TimeCreated SystemTime="2015-07-20T22:
<EventRecordID>34621</Even
<Correlation ActivityID="{5E22266C-69E8
<Execution ProcessID="6924" ThreadID="6000" />
<Channel>Application</Chan
<Computer>SERV013.FQDN.com
<Security UserID="S-1-5-21-305458857
</System>
<EventData>
<Data Name="string0">User Profile Service Application_SyncDB_5d0b206
<Data Name="string1">SERV010\sha
<Data Name="string2">Cannot open database "User Profile Service Application_SyncDB_5d0b206
Login failed for user 'mydom\spfarm'.</Data>
</EventData>
</Event>
The database is online checked my SQL server
My research only found issue with the content database
How do I fix this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No idea why. Any service packs or other products recently installed?
Any VM rollbacks or snapshots?
Any VM rollbacks or snapshots?
ASKER
Jamie
No vm
No service packs to sql
Only regular updates to the server
No vm
No service packs to sql
Only regular updates to the server
Usually we can attribute these to one of three things;
A change (software release, patch etc)
A person (changing setting)
A cosmic ray (radiation from space randomly flipping a bit in memory or on disk)
Take your pick. ;)
A change (software release, patch etc)
A person (changing setting)
A cosmic ray (radiation from space randomly flipping a bit in memory or on disk)
Take your pick. ;)
In another article, you mentioned you had run windows updates. Please initiate products and technologies configuration wizard on the server if it says "This wizard will upgrade the product" then go ahead and run it.
ASKER
Mohit
Ran SharePoint 2010 Products Configuration Wizard
It ran thru all 10 steps with no errors
But in the event log I found these two
Log Name: Application
Source: Microsoft-SharePoint Products-SharePoint Foundation
Date: 7/21/2015 3:12:10 PM
Event ID: 5586
Task Category: Database
Level: Error
Keywords:
User: OUR\administrator
Computer: SERVER013.FQDN.com
Description:
Unknown SQL Exception 15023 occurred. Additional error information from SQL Server is included below.
User, group, or role 'WSS_Content_Application_P ools' already exists in the current database.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft-SharePoint Products-SharePoint Foundation" Guid="{6FB7E0CD-52E7-47DD- 997A-24156 3931FC2}" />
<EventID>5586</EventID>
<Version>14</Version>
<Level>2</Level>
<Task>3</Task>
<Opcode>0</Opcode>
<Keywords>0x40000000000000 00</Keywor ds>
<TimeCreated SystemTime="2015-07-21T19: 12:10.1879 00300Z" />
<EventRecordID>37026</Even tRecordID>
<Correlation />
<Execution ProcessID="2016" ThreadID="1004" />
<Channel>Application</Chan nel>
<Computer>SERVER013.FQDN.c om</Comput er>
<Security UserID="S-1-5-21-305458857 1-13414595 84-7841283 02-500" />
</System>
<EventData>
<Data Name="int0">15023</Data>
<Data Name="string1">User, group, or role 'WSS_Content_Application_P ools' already exists in the current database.</Data>
</EventData>
</Event>
Log Name: Application
Source: SharePoint 2010 Products Configuration Wizard
Date: 7/21/2015 3:13:35 PM
Event ID: 107
Task Category: None
Level: Warning
Keywords: Classic
User: N/A
Computer: SERVER013.FQDN.com
Description:
Unable to create a Service Connection Point in the current Active Directory domain. Verify that the SharePoint container exists in the current domain and that you have rights to write to it.
Microsoft.SharePoint.SPExc eption: The object LDAP://CN=Microsoft SharePoint Products,CN=System,DC=our, DC=network ,DC=tgcsne t,DC=com doesn't exist in the directory.
at Microsoft.SharePoint.Admin istration. SPServiceC onnectionP oint.Ensur e(String serviceBindingInformation)
at Microsoft.SharePoint.PostS etupConfig uration.Up gradeTask. Run()
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="SharePoint 2010 Products Configuration Wizard" />
<EventID Qualifiers="0">107</EventI D>
<Level>3</Level>
<Task>0</Task>
<Keywords>0x80000000000000 </Keywords >
<TimeCreated SystemTime="2015-07-21T19: 13:35.0000 00000Z" />
<EventRecordID>37027</Even tRecordID>
<Channel>Application</Chan nel>
<Computer>SERVER013.FQDN.c om</Comput er>
<Security />
</System>
<EventData>
<Data>Unable to create a Service Connection Point in the current Active Directory domain. Verify that the SharePoint container exists in the current domain and that you have rights to write to it.
Microsoft.SharePoint.SPExc eption: The object LDAP://CN=Microsoft SharePoint Products,CN=System,DC=our, DC=network ,DC=tgcsne t,DC=com doesn't exist in the directory.
at Microsoft.SharePoint.Admin istration. SPServiceC onnectionP oint.Ensur e(String serviceBindingInformation)
at Microsoft.SharePoint.PostS etupConfig uration.Up gradeTask. Run()</Dat a>
</EventData>
</Event>
Thoughts
Ran SharePoint 2010 Products Configuration Wizard
It ran thru all 10 steps with no errors
But in the event log I found these two
Log Name: Application
Source: Microsoft-SharePoint Products-SharePoint Foundation
Date: 7/21/2015 3:12:10 PM
Event ID: 5586
Task Category: Database
Level: Error
Keywords:
User: OUR\administrator
Computer: SERVER013.FQDN.com
Description:
Unknown SQL Exception 15023 occurred. Additional error information from SQL Server is included below.
User, group, or role 'WSS_Content_Application_P
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft-SharePoint
<EventID>5586</EventID>
<Version>14</Version>
<Level>2</Level>
<Task>3</Task>
<Opcode>0</Opcode>
<Keywords>0x40000000000000
<TimeCreated SystemTime="2015-07-21T19:
<EventRecordID>37026</Even
<Correlation />
<Execution ProcessID="2016" ThreadID="1004" />
<Channel>Application</Chan
<Computer>SERVER013.FQDN.c
<Security UserID="S-1-5-21-305458857
</System>
<EventData>
<Data Name="int0">15023</Data>
<Data Name="string1">User, group, or role 'WSS_Content_Application_P
</EventData>
</Event>
Log Name: Application
Source: SharePoint 2010 Products Configuration Wizard
Date: 7/21/2015 3:13:35 PM
Event ID: 107
Task Category: None
Level: Warning
Keywords: Classic
User: N/A
Computer: SERVER013.FQDN.com
Description:
Unable to create a Service Connection Point in the current Active Directory domain. Verify that the SharePoint container exists in the current domain and that you have rights to write to it.
Microsoft.SharePoint.SPExc
at Microsoft.SharePoint.Admin
at Microsoft.SharePoint.PostS
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="SharePoint 2010 Products Configuration Wizard" />
<EventID Qualifiers="0">107</EventI
<Level>3</Level>
<Task>0</Task>
<Keywords>0x80000000000000
<TimeCreated SystemTime="2015-07-21T19:
<EventRecordID>37027</Even
<Channel>Application</Chan
<Computer>SERVER013.FQDN.c
<Security />
</System>
<EventData>
<Data>Unable to create a Service Connection Point in the current Active Directory domain. Verify that the SharePoint container exists in the current domain and that you have rights to write to it.
Microsoft.SharePoint.SPExc
at Microsoft.SharePoint.Admin
at Microsoft.SharePoint.PostS
</EventData>
</Event>
Thoughts
ASKER
Have not seen the 3760 Error Since I added SPFARM to the DB permissions.
Will open new question on the other errors after running the SharePoint 2010 Products Configuration Wizard.
Thanks for all the help
Will open new question on the other errors after running the SharePoint 2010 Products Configuration Wizard.
Thanks for all the help
ASKER
Thanks for responding
Yes checked the permissions and they were all gone. No permissions at all.
Any thoughts on how that happened? or what could have caused that?
I gave SPFARM Connect permissions will see what happens next