{"id":648,"date":"2010-07-14T13:59:46","date_gmt":"2010-07-14T12:59:46","guid":{"rendered":"http:\/\/www.tsls.co.uk\/?p=648"},"modified":"2010-07-14T13:59:46","modified_gmt":"2010-07-14T12:59:46","slug":"fim-forefront-identity-manager-failed-to-connect-to-sql-server","status":"publish","type":"post","link":"https:\/\/www.tsls.co.uk\/index.php\/2010\/07\/14\/fim-forefront-identity-manager-failed-to-connect-to-sql-server\/","title":{"rendered":"FIM \u2013 Forefront Identity Manager Failed to Connect to SQL Server"},"content":{"rendered":"<p>FIM \u2013 Forefront Identity Manager Failed to Connect to SQL Server<\/p>\n<p>ISSUE<br \/>\n=====<br \/>\nSharePoint 2010 connects to a SQL Instance<br \/>\nIn SharePoint 2010 FIM is used for importing and synchronising user profiles by the User Profile Service Application. Starting the User Profile Synchronising Service (from Central Admin \u2013 System Settings \u2013 Mange Service on Server) Fail\u2019s. Reviewing the Event log you receive the following error message:<\/p>\n<p>Log Name:\u00a0\u00a0\u00a0\u00a0\u00a0 Application<br \/>\nSource:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FIMSynchronizationService<br \/>\nDate:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 13\/07\/2010 15:19:37<br \/>\nEvent ID:\u00a0\u00a0\u00a0\u00a0\u00a0 6324<br \/>\nTask Category: Server<br \/>\nLevel:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Error<br \/>\nKeywords:\u00a0\u00a0\u00a0\u00a0\u00a0 Classic<br \/>\nUser:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 N\/A<br \/>\nComputer:\u00a0\u00a0\u00a0\u00a0\u00a0 &lt;SP2010NAMEE&gt;.&lt;DOMAINNAME&gt;<br \/>\nDescription:<br \/>\nThe server encountered an unexpected error and stopped.<br \/>\n\ufffd<br \/>\n\u00a0&#8220;ERR: MMS(1804): sql.cpp(5580): Query (CSession::Open()) performed with error<br \/>\nERR: MMS(1804): sql.cpp(5601): Error retrieving error<br \/>\nBAIL: MMS(1804): sql.cpp(568): 0x80230406 (An error has occurred at the store)<br \/>\nBAIL: MMS(1804): sql.cpp(384): 0x80230406 (An error has occurred at the store)<br \/>\nBAIL: MMS(1804): sql.cpp(256): 0x80230406 (An error has occurred at the store)<br \/>\nBAIL: MMS(1804): storeimp.cpp(272): 0x80230406 (An error has occurred at the store)<br \/>\nERR: MMS(1804): server.cpp(294): Failed to connect to the database User Profile Service Application_SyncDB_2404860889364cf2a021eccb509327fd on &lt;SQLSERVERNAME&gt;<br \/>\nBAIL: MMS(1804): server.cpp(295): 0x80230406 (An error has occurred at the store)<br \/>\nBAIL: MMS(1804): server.cpp(3518): 0x80230406 (An error has occurred at the store)<br \/>\nBAIL: MMS(1804): service.cpp(1528): 0x80230406 (An error has occurred at the store)<br \/>\nERR: MMS(1804): service.cpp(977): Error creating com objects. Error code: -2145188858. This is retry number 0.<br \/>\nERR: MMS(1804): sql.cpp(5580): Query (CSession::Open()) performed with error<br \/>\nERR: MMS(1804): sql.cpp(5601): Error retrieving error<br \/>\nBAIL: MMS(1804): sql.cpp(568): 0x80230406 (An error has occurred at the store)<br \/>\nBAIL: MMS(1804): sql.cpp(384): 0x80230406 (An error has occurred at the store)<br \/>\nBAIL: MMS(1804): sql.cpp(256): 0x80230406 (An error has occurred at the store)<br \/>\nBAIL: MMS(1804): storeimp.cpp(272): 0x80230406 (An error has occurred at the store)<br \/>\nERR: MMS(1804): server.cpp(294): Failed to connect to the database User Profile Service Application_SyncDB_2404860889364cf2a021eccb509327fd on &lt;SQLSERVERNAME&gt;<br \/>\nBAIL: MMS(1804): server.cpp(295): 0x80230406 (An error has occurred at the store)<br \/>\nBAIL: MMS(1804): server.cpp(3518): 0x80230406 (An error has occurred at the store)<br \/>\nBAIL: MMS(1804): service.cpp(1528): 0x80230406 (An error has occurred at the store)<br \/>\nERR: MMS(1804): service.cpp(977): Error creating com objects. Error code: -2145188858. This is retry number 1.<br \/>\nERR: MMS(1804): sql.cpp(5580): Query (CSession::Open()) performed with error<br \/>\nERR: MMS(1804): sql.cpp(5601): Error retrieving error<br \/>\nBAIL: MMS(1804): sql.cpp(568): 0x80230406 (An error has occurred at the store)<br \/>\nBAIL: MMS(1804): sql.cpp(384): 0x80230406 (An error has occurred at the store)<br \/>\nBAIL: MMS(1804): sql.cpp(256): 0x80230406 (An error has occurred at the store)<br \/>\nBAIL: MMS(1804): storeimp.cpp(272): 0x80230406 (An error has occurred at the store)<br \/>\nERR: MMS(1804): server.cpp(294): Failed to connect to the database User Profile Service Application_SyncDB_2404860889364cf2a021eccb509327fd on &lt;SQLSERVERNAME&gt;<br \/>\nBAIL: MMS(1804): server.cpp(295): 0x80230406 (An error has occurred at the store)<br \/>\nBAIL: MMS(1804): server.cpp(3518): 0x80230406 (An error has occurred at the store)<br \/>\nBAIL: MMS(1804): service.cpp(1528): 0x80230406 (An error has occurred at the store)<br \/>\nERR: MMS(1804): service.cpp(977): Error creating com objects. Error code: -2145188858. This is retry number 2.<br \/>\nERR: MMS(1804): sql.cpp(5580): Query (CSession::Open()) performed with error<br \/>\nERR: MMS(1804): sql.cpp(5601): Error retrieving error<br \/>\nBAIL: MMS(1804): sql.cpp(568): 0x80230406 (An error has occurred at the store)<br \/>\nBAIL: MMS(1804): sql.cpp(384): 0x80230406 (An error has occurred at the store)<br \/>\nBAIL: MMS(1804): sql.cpp(256): 0x80230406 (An error has occurred at the store)<br \/>\nBAIL: MMS(1804): storeimp.cpp(272): 0x80230406 (An error has occurred at the store)<br \/>\nERR: MMS(1804): server.cpp(294): Failed to connect to the database User Profile Service Application_SyncDB_2404860889364cf2a021eccb509327fd on &lt;SQLSERVERNAME&gt;<br \/>\nBAIL: MMS(1804): server.cpp(295): 0x80230406 (An error has occurred at the store)<br \/>\nBAIL: MMS(1804): server.cpp(3518): 0x80230406 (An error has occurred at the store)<br \/>\nBAIL: MMS(1804): service.cpp(1528): 0x80230406 (An error has occurred at the store)<br \/>\nERR: MMS(1804): service.cpp(977): Error creating com objects. Error code: -2145188858. This is retry number 3.<br \/>\nBAIL: MMS(1804): service.cpp(991): 0x80230406 (An error has occurred at the store)<br \/>\nForefront Identity Manager 4.0.2450.5&#8221;<\/p>\n<p>Resolution<br \/>\n=========<\/p>\n<p>Somehow the SQL Instance information for the FIM Synchronising Service is missing<\/p>\n<p>To resolve the issue add the SQLInstance name to the following Reg key:<\/p>\n<p>Windows Registry Editor Version 5.00<\/p>\n<p><code>[HKEY_LOCAL_MACHINESYSTEMControlSet001servicesFIMSynchronizationServiceParameters]<br \/>\n\"SQLInstance\"=\"&lt;InstanceName&gt;\"<\/code><\/p>\n<p><code><a href=\"http:\/\/www.tsls.co.uk\/wp-content\/uploads\/2010\/07\/FIMSyncIssue.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-650 colorbox-648\" title=\"FIMSyncIssue\" src=\"http:\/\/www.tsls.co.uk\/wp-content\/uploads\/2010\/07\/FIMSyncIssue-300x144.png\" alt=\"\" width=\"300\" height=\"144\" \/><\/a><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>FIM \u2013 Forefront Identity Manager Failed to Connect to SQL Server ISSUE ===== SharePoint 2010 connects to a SQL Instance In SharePoint 2010 FIM is used for importing and synchronising user profiles by the User<\/p>\n","protected":false},"author":11,"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_newsletter_tier_id":0,"footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[21],"tags":[1861,2231],"class_list":["post-648","post","type-post","status-publish","format-standard","hentry","category-microsoft","tag-sharepoint-2010","tag-user-profile-service"],"jetpack_publicize_connections":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>FIM \u2013 Forefront Identity Manager Failed to Connect to SQL Server - TSLS - Luke Smith<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.tsls.co.uk\/index.php\/2010\/07\/14\/fim-forefront-identity-manager-failed-to-connect-to-sql-server\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_GB\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"FIM \u2013 Forefront Identity Manager Failed to Connect to SQL Server - TSLS - Luke Smith\" \/>\r\n<meta property=\"og:description\" content=\"FIM \u2013 Forefront Identity Manager Failed to Connect to SQL Server ISSUE ===== SharePoint 2010 connects to a SQL Instance In SharePoint 2010 FIM is used for importing and synchronising user profiles by the User\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.tsls.co.uk\/index.php\/2010\/07\/14\/fim-forefront-identity-manager-failed-to-connect-to-sql-server\/\" \/>\r\n<meta property=\"og:site_name\" content=\"TSLS - Luke Smith\" \/>\r\n<meta property=\"article:published_time\" content=\"2010-07-14T12:59:46+00:00\" \/>\r\n<meta property=\"og:image\" content=\"http:\/\/www.tsls.co.uk\/wp-content\/uploads\/2010\/07\/FIMSyncIssue-300x144.png\" \/>\r\n<meta name=\"author\" content=\"Luke Smith\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Luke Smith\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.tsls.co.uk\/index.php\/2010\/07\/14\/fim-forefront-identity-manager-failed-to-connect-to-sql-server\/\",\"url\":\"https:\/\/www.tsls.co.uk\/index.php\/2010\/07\/14\/fim-forefront-identity-manager-failed-to-connect-to-sql-server\/\",\"name\":\"FIM \u2013 Forefront Identity Manager Failed to Connect to SQL Server - TSLS - Luke Smith\",\"isPartOf\":{\"@id\":\"https:\/\/www.tsls.co.uk\/#website\"},\"datePublished\":\"2010-07-14T12:59:46+00:00\",\"dateModified\":\"2010-07-14T12:59:46+00:00\",\"author\":{\"@id\":\"https:\/\/www.tsls.co.uk\/#\/schema\/person\/e4d7dac4fe1b3f8df31f3857bb3ebda7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.tsls.co.uk\/index.php\/2010\/07\/14\/fim-forefront-identity-manager-failed-to-connect-to-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.tsls.co.uk\/index.php\/2010\/07\/14\/fim-forefront-identity-manager-failed-to-connect-to-sql-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.tsls.co.uk\/index.php\/2010\/07\/14\/fim-forefront-identity-manager-failed-to-connect-to-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.tsls.co.uk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"FIM \u2013 Forefront Identity Manager Failed to Connect to SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.tsls.co.uk\/#website\",\"url\":\"https:\/\/www.tsls.co.uk\/\",\"name\":\"TSLS - Luke Smith\",\"description\":\"- Knowledge - Thoughts - Microsoft -\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.tsls.co.uk\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.tsls.co.uk\/#\/schema\/person\/e4d7dac4fe1b3f8df31f3857bb3ebda7\",\"name\":\"Luke Smith\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.tsls.co.uk\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/29abc50f07a4ebe68cb4f31981884f89b2157d7e4ed63b09631d40c0717faa94?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/29abc50f07a4ebe68cb4f31981884f89b2157d7e4ed63b09631d40c0717faa94?s=96&d=mm&r=g\",\"caption\":\"Luke Smith\"},\"description\":\"I\u2019ve been working with Microsoft Technologies for over 20 years, my main focus now being Microsoft Online Services. I manage the Cloud Services at ElysianIT Limited and as a P-SELLER at Microsoft. I have worked with many organisations from SMC to Enterprise. I\u2019ve been working with Microsoft Technologies since DOS 5.0, to date I have been working on Microsoft\u2019s latest cloud technology Windows Azure, Windows 10 Office 365 and Microsoft SharePoint\",\"sameAs\":[\"http:\/\/www.tsls.co.uk\"],\"url\":\"https:\/\/www.tsls.co.uk\/index.php\/author\/luke\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"FIM \u2013 Forefront Identity Manager Failed to Connect to SQL Server - TSLS - Luke Smith","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.tsls.co.uk\/index.php\/2010\/07\/14\/fim-forefront-identity-manager-failed-to-connect-to-sql-server\/","og_locale":"en_GB","og_type":"article","og_title":"FIM \u2013 Forefront Identity Manager Failed to Connect to SQL Server - TSLS - Luke Smith","og_description":"FIM \u2013 Forefront Identity Manager Failed to Connect to SQL Server ISSUE ===== SharePoint 2010 connects to a SQL Instance In SharePoint 2010 FIM is used for importing and synchronising user profiles by the User","og_url":"https:\/\/www.tsls.co.uk\/index.php\/2010\/07\/14\/fim-forefront-identity-manager-failed-to-connect-to-sql-server\/","og_site_name":"TSLS - Luke Smith","article_published_time":"2010-07-14T12:59:46+00:00","og_image":[{"url":"http:\/\/www.tsls.co.uk\/wp-content\/uploads\/2010\/07\/FIMSyncIssue-300x144.png"}],"author":"Luke Smith","twitter_misc":{"Written by":"Luke Smith","Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.tsls.co.uk\/index.php\/2010\/07\/14\/fim-forefront-identity-manager-failed-to-connect-to-sql-server\/","url":"https:\/\/www.tsls.co.uk\/index.php\/2010\/07\/14\/fim-forefront-identity-manager-failed-to-connect-to-sql-server\/","name":"FIM \u2013 Forefront Identity Manager Failed to Connect to SQL Server - TSLS - Luke Smith","isPartOf":{"@id":"https:\/\/www.tsls.co.uk\/#website"},"datePublished":"2010-07-14T12:59:46+00:00","dateModified":"2010-07-14T12:59:46+00:00","author":{"@id":"https:\/\/www.tsls.co.uk\/#\/schema\/person\/e4d7dac4fe1b3f8df31f3857bb3ebda7"},"breadcrumb":{"@id":"https:\/\/www.tsls.co.uk\/index.php\/2010\/07\/14\/fim-forefront-identity-manager-failed-to-connect-to-sql-server\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.tsls.co.uk\/index.php\/2010\/07\/14\/fim-forefront-identity-manager-failed-to-connect-to-sql-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.tsls.co.uk\/index.php\/2010\/07\/14\/fim-forefront-identity-manager-failed-to-connect-to-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.tsls.co.uk\/"},{"@type":"ListItem","position":2,"name":"FIM \u2013 Forefront Identity Manager Failed to Connect to SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.tsls.co.uk\/#website","url":"https:\/\/www.tsls.co.uk\/","name":"TSLS - Luke Smith","description":"- Knowledge - Thoughts - Microsoft -","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.tsls.co.uk\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.tsls.co.uk\/#\/schema\/person\/e4d7dac4fe1b3f8df31f3857bb3ebda7","name":"Luke Smith","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.tsls.co.uk\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/29abc50f07a4ebe68cb4f31981884f89b2157d7e4ed63b09631d40c0717faa94?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/29abc50f07a4ebe68cb4f31981884f89b2157d7e4ed63b09631d40c0717faa94?s=96&d=mm&r=g","caption":"Luke Smith"},"description":"I\u2019ve been working with Microsoft Technologies for over 20 years, my main focus now being Microsoft Online Services. I manage the Cloud Services at ElysianIT Limited and as a P-SELLER at Microsoft. I have worked with many organisations from SMC to Enterprise. I\u2019ve been working with Microsoft Technologies since DOS 5.0, to date I have been working on Microsoft\u2019s latest cloud technology Windows Azure, Windows 10 Office 365 and Microsoft SharePoint","sameAs":["http:\/\/www.tsls.co.uk"],"url":"https:\/\/www.tsls.co.uk\/index.php\/author\/luke\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2gf1k-as","_links":{"self":[{"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/648","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/comments?post=648"}],"version-history":[{"count":0,"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/648\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/media?parent=648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/categories?post=648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/tags?post=648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}