When I started to work with SharePoint 2010 I’ve noticed that there are alot of issues regarding the User Profile Synchronization. Alot of people mentioned the following event viewer problems:<\/p>\n
\nMicrosoft.ResourceManagement.ServiceHealthSource
\nEvent ID: 22
\nLevel: Error<\/p>\nThe Forefront Identity Manager Service cannot connect to the SQL Database Server. <\/p>\n
The SQL Server could not be contacted. The connection failure may be due to a network failure, firewall configuration error, or other connection issue. Additionally, the SQL Server connection information could be configured incorrectly. <\/p>\n
Verify that the SQL Server is reachable from the Forefront Identity Manager Service computer. Ensure that SQL Server is running, that the network connection is active, and that the firewall is configured properly. Last, verify the connection information has been configured properly. This configuration is stored in the Windows Registry.\n<\/p><\/blockquote>\n
\nILM Web Service Configuration
\nEvent ID: 234
\nLevel: Warning<\/p>\nILM Certificate could not be created: netsh http error:netsh http add urlacl url=http:\/\/+:5726\/ user=MSSDEVIA\\MSSFARM sddl=D:(A;;GA;;;S-1-5-21-3647457175-3930976156-3381717532-1106)\n<\/p><\/blockquote>\n
\nForeFront Identity Manager
\nEvent ID: 3
\nLevel: Error<\/p>\n.Net SqlClient Data Provider: System.Data.SqlClient.SqlException: Cannot open database “User Profile Service Application_SyncDB_1d4b979635654411b18ce834c5c0a76a” requested by the login. The login failed.
\nLogin failed for user ‘MSSDEVIA\\mssfarm’.
\n at Microsoft.ResourceManagement.Data.Exception.DataAccessExceptionManager.ThrowException(SqlException innerException)
\n at Microsoft.ResourceManagement.Data.DatabaseConnection.Open(SqlConnection connection)
\n at Microsoft.ResourceManagement.Data.DatabaseConnection.Open(DataStore store)
\n at Microsoft.ResourceManagement.Data.TransactionAndConnectionScope..ctor(Boolean createTransaction, IsolationLevel isolationLevel, DataStore dataStore)
\n at Microsoft.ResourceManagement.Data.TransactionAndConnectionScope..ctor(Boolean createTransaction)
\n at Microsoft.ResourceManagement.Data.DataAccess.RegisterService(String hostName)
\n at Microsoft.ResourceManagement.Workflow.Hosting.HostActivator.RegisterService(String hostName)
\n at Microsoft.ResourceManagement.Workflow.Hosting.HostActivator.Initialize()
\n at Microsoft.ResourceManagement.WebServices.ResourceManagementServiceHostFactory.CreateServiceHost(String constructorString, Uri[] baseAddresses)
\n at Microsoft.ResourceManagement.WindowsHostService.OnStart(String[] args)\n<\/p><\/blockquote>\n\nForeFront Identity Manager
\nEvent ID: 3
\nLevel: Error<\/p>\n.Net SqlClient Data Provider: System.Data.SqlClient.SqlException: HostId is not registered
\n at Microsoft.ResourceManagement.Data.Exception.DataAccessExceptionManager.ThrowException(SqlException innerException)
\n at Microsoft.ResourceManagement.Data.DataAccess.RetrieveWorkflowDataForHostActivator(Int16 hostId, Int16 pingIntervalSecs, Int32 activeHostedWorkflowDefinitionsSequenceNumber, Int16 workflowControlMessagesMaxPerMinute, Int16 requestRecoveryMaxPerMinute, Int16 requestCleanupMaxPerMinute, Boolean runRequestRecoveryScan, Boolean& doPolicyApplicationDispatch, ReadOnlyCollection`1& activeHostedWorkflowDefinitions, ReadOnlyCollection`1& workflowControlMessages, List`1& requestsToRedispatch)
\n at Microsoft.ResourceManagement.Workflow.Hosting.HostActivator.RetrieveWorkflowDataForHostActivator()
\n at Microsoft.ResourceManagement.Workflow.Hosting.HostActivator.ActivateHosts(Object source, ElapsedEventArgs e)\n<\/p><\/blockquote>\nOf course I’ve watched the different blog posts from different MVP’s and others. But there still seems to be alot of different issues regarding the UPS of SharePoint 2010. Yet, I’ve found out that there are more issues as they speak of.
\nIn my case the scenario was alot different then rights on the local machine or on the domain. The users had all the rights to perform Replicate Directory Changes on the domain, and yet I’ve had these errors.<\/p>\nI’d Visual Studio 2010 installed and it came up with the Jit-In-Time debugger with errors. <\/p>\n
An unhandled exception (‘System.ServiceModel.ProtocolException’) occurred in OWSTIMER.exe [5630]<\/p>\n
\nApplication Error
\nEvent ID: 1000
\nLevel: Error<\/p>\nFaulting Application name: OWSTIMER.exe, version: 14.0.4762.1000, time stamp: 0x4bad920c
\nFaulting module name: KERNELBASE.dll, version: 6.1.7600.16385, time stamp: 04xa5bdfe0
\nException code: 0xe0434f4d
\nFault offset: 0x000000000aa7d
\nFaulting Process id: 0xa58
\nFaulting application start time: 0x01cb2cacfed18e83
\nFaulting application path: C:\\Program Files\\Common Files\\Microsoft shared\\Web Server Extensions\\14\\Bin\\OWSTIMER.exe
\nFaulting module path: C:\\Windows\\System32\\KERNELBASE.dll
\nReport id: f3b92d5f-98a3-11df-b4fd-000c29240fea
\n<\/BlockQuote><\/p>\nSo, I’ve opened a new instance of Visual Studio 2010 Debugger, and it came up that the internal Proxy Server needed authentication. I did get a 407: Proxy Authentication Required.<\/p>\n
If you think you’ve done everything to the different blog posts you’ve writtend, and you can’t find any issues, it can be that something else blocking your way to use the different SharePoint Application Services.<\/p>\n
MS is not helping you with these kind of issues, but when you need some help, try to use Visual Studio on your application server, or server that is going to host the UPS service to identify which errors it comes up with.<\/p>\n
If you can’t use Visual Studio because it’s a production environment, try to get a test environment in the same environment your production environment is in, and install there Visual Studio.<\/p>\n","protected":false},"excerpt":{"rendered":"
When I started to work with SharePoint 2010 I’ve noticed that there are alot of issues regarding the User Profile Synchronization. Alot of people mentioned the following event viewer problems: Microsoft.ResourceManagement.ServiceHealthSource Event ID: 22 Level: Error The Forefront Identity Manager Service cannot connect to the SQL Database Server. The SQL Server could not be contacted. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[238,247,224,246,16,248,249],"tags":[256,253,254,250,251,255,360,258,260,259,218,257,261,52,356,359,252,361],"class_list":["post-131","post","type-post","status-publish","format-standard","hentry","category-active-directory","category-forefront-identity-manager","category-sharepoint-2010","category-sharepoint-foundation","category-sql-server","category-user-profile-services","category-visual-studio-2010","tag-application-error","tag-event-id-22","tag-event-id-234","tag-event-id-3","tag-fim","tag-forefront","tag-forefront-identity-manager","tag-ilm","tag-ilm-certificate","tag-ilm-web-service-configuration","tag-mss-2010","tag-owstimer","tag-sf","tag-sharepoint","tag-sharepoint-2010","tag-sharepoint-foundation","tag-ups","tag-user-profile-services"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pe1EH-27","_links":{"self":[{"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=\/wp\/v2\/posts\/131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=131"}],"version-history":[{"count":2,"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=\/wp\/v2\/posts\/131\/revisions"}],"predecessor-version":[{"id":133,"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=\/wp\/v2\/posts\/131\/revisions\/133"}],"wp:attachment":[{"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=131"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mysticslayer.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}