Windows 2008 R2 Server
SQL 2008 Enterprise
Have a SharePoint SQL User Profile Service SyncDB the other day my SharePoint had errors. After research I found that the Farm Account was missing from the Database Security Users.
So I added the account back in and added connect permissions and the SharePoint server started working.
I have other issues and I came back to SQL and found that my Security Users may not be correct.
I compared to my other SharePoint databases. The Users are displayed differently I posted a screen image.
I ran this on the SQL instance "exec sp_change_users_login 'Report' that produced no records.
The account SPFARM is in the Security Logins section
Other Databases have the same account and accounts listed.
No matter how I try to add the accounts back to this database it just does not look right and I think that is why I am having other issues,
Is the Database corrupted?
Any help would be appreciated.
Thanks in advance