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?
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