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_5d0b20605e2e425c865e67f0a826f73c' 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_5d0b20605e2e425c865e67f0a826f73c" 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-241563931FC2}" />
    <EventID>3760</EventID>
    <Version>14</Version>
    <Level>1</Level>
    <Task>3</Task>
    <Opcode>0</Opcode>
    <Keywords>0x4000000000000000</Keywords>
    <TimeCreated SystemTime="2015-07-20T22:00:01.855769300Z" />
    <EventRecordID>34621</EventRecordID>
    <Correlation ActivityID="{5E22266C-69E8-4F06-B8AA-FFAA8477C320}" />
    <Execution ProcessID="6924" ThreadID="6000" />
    <Channel>Application</Channel>
    <Computer>SERV013.FQDN.com</Computer>
    <Security UserID="S-1-5-21-3054588571-1341459584-784128302-3142" />
  </System>
  <EventData>
    <Data Name="string0">User Profile Service Application_SyncDB_5d0b20605e2e425c865e67f0a826f73c</Data>
    <Data Name="string1">SERV010\sharepoint</Data>
    <Data Name="string2">Cannot open database "User Profile Service Application_SyncDB_5d0b20605e2e425c865e67f0a826f73c" 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?
LVL 23
Thomas GrassiSystems AdministratorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jamie McAllister MVPSharePoint ConsultantCommented:
Have a look at the UPS Sync DB database properties -> permissions.

What permissions does the farm account have? I would expect it to have 'Connect'.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Thomas GrassiSystems AdministratorAuthor Commented:
Jamie

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
Jamie McAllister MVPSharePoint ConsultantCommented:
No idea why. Any service packs or other products recently installed?

Any VM rollbacks or snapshots?
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Thomas GrassiSystems AdministratorAuthor Commented:
Jamie

No vm

No service packs to sql

Only regular updates to the server
Jamie McAllister MVPSharePoint ConsultantCommented:
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. ;)
Mohit NairSenior AssociateCommented:
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.
Thomas GrassiSystems AdministratorAuthor Commented:
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_Pools' 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-241563931FC2}" />
    <EventID>5586</EventID>
    <Version>14</Version>
    <Level>2</Level>
    <Task>3</Task>
    <Opcode>0</Opcode>
    <Keywords>0x4000000000000000</Keywords>
    <TimeCreated SystemTime="2015-07-21T19:12:10.187900300Z" />
    <EventRecordID>37026</EventRecordID>
    <Correlation />
    <Execution ProcessID="2016" ThreadID="1004" />
    <Channel>Application</Channel>
    <Computer>SERVER013.FQDN.com</Computer>
    <Security UserID="S-1-5-21-3054588571-1341459584-784128302-500" />
  </System>
  <EventData>
    <Data Name="int0">15023</Data>
    <Data Name="string1">User, group, or role 'WSS_Content_Application_Pools' 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.SPException: The object LDAP://CN=Microsoft SharePoint Products,CN=System,DC=our,DC=network,DC=tgcsnet,DC=com doesn't exist in the directory.
   at Microsoft.SharePoint.Administration.SPServiceConnectionPoint.Ensure(String serviceBindingInformation)
   at Microsoft.SharePoint.PostSetupConfiguration.UpgradeTask.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</EventID>
    <Level>3</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2015-07-21T19:13:35.000000000Z" />
    <EventRecordID>37027</EventRecordID>
    <Channel>Application</Channel>
    <Computer>SERVER013.FQDN.com</Computer>
    <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.SPException: The object LDAP://CN=Microsoft SharePoint Products,CN=System,DC=our,DC=network,DC=tgcsnet,DC=com doesn't exist in the directory.
   at Microsoft.SharePoint.Administration.SPServiceConnectionPoint.Ensure(String serviceBindingInformation)
   at Microsoft.SharePoint.PostSetupConfiguration.UpgradeTask.Run()</Data>
  </EventData>
</Event>



Thoughts
Thomas GrassiSystems AdministratorAuthor Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.