{"id":6475,"date":"2018-12-11T09:44:34","date_gmt":"2018-12-11T09:44:34","guid":{"rendered":"https:\/\/dbtut.com\/?p=6475"},"modified":"2018-12-21T13:17:57","modified_gmt":"2018-12-21T13:17:57","slug":"sql-server-is-not-startingthe-system-cannot-find-the-path-specified","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/","title":{"rendered":"SQL Server is not Starting(The system cannot find the path specified)"},"content":{"rendered":"<p>&nbsp;<\/p>\n<h3>ERROR MESSAGE:<\/h3>\n<p>Error 3(The system cannot find the path specified.) occurred while opening file &#8216;C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\DATA\\master.mdf&#8217; to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.<\/p>\n<h3>EXPLANATION:<\/h3>\n<p>When you want to start SQL Server, you may receive such an error in Event Viewer.<\/p>\n<p>The reason I encounter this error is that the account used for the SQL Server service did not have sufficient permissions for the path specified in the error.<\/p>\n<p>The SQL Server service account did not have access to the DATA folder in the example.<\/p>\n<p>Note: You may need to check the access rights of all folders related to Instance.<\/p>\n<h3>SOLUTION:<\/h3>\n<p>This problem will be resolved when you grant the necessary access rights to the SQL Server service account.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_6475\" class=\"pvc_stats all  \" data-element-id=\"6475\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; ERROR MESSAGE: Error 3(The system cannot find the path specified.) occurred while opening file &#8216;C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\DATA\\master.mdf&#8217; to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary. EXPLANATION: When you want to start SQL Server, you may &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_6475\" class=\"pvc_stats all  \" data-element-id=\"6475\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":423,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6475","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server is not Starting(The system cannot find the path specified) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"SQL Server is not Starting(The system cannot find the path specified)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server is not Starting(The system cannot find the path specified) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"SQL Server is not Starting(The system cannot find the path specified)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-11T09:44:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-21T13:17:57+00:00\" \/>\n<meta name=\"author\" content=\"Ekrem \u00d6nsoy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ekrem \u00d6nsoy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/\"},\"author\":{\"name\":\"Ekrem \u00d6nsoy\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46\"},\"headline\":\"SQL Server is not Starting(The system cannot find the path specified)\",\"datePublished\":\"2018-12-11T09:44:34+00:00\",\"dateModified\":\"2018-12-21T13:17:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/\"},\"wordCount\":162,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/\",\"name\":\"SQL Server is not Starting(The system cannot find the path specified) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-12-11T09:44:34+00:00\",\"dateModified\":\"2018-12-21T13:17:57+00:00\",\"description\":\"SQL Server is not Starting(The system cannot find the path specified)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server is not Starting(The system cannot find the path specified)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46\",\"name\":\"Ekrem \u00d6nsoy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g\",\"caption\":\"Ekrem \u00d6nsoy\"},\"description\":\"The original article was written in Turkish by Ekrem \u00d6nsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.\",\"url\":\"https:\/\/dbtut.com\/index.php\/author\/ekremonsoy\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server is not Starting(The system cannot find the path specified) - Database Tutorials","description":"SQL Server is not Starting(The system cannot find the path specified)","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:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server is not Starting(The system cannot find the path specified) - Database Tutorials","og_description":"SQL Server is not Starting(The system cannot find the path specified)","og_url":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/","og_site_name":"Database Tutorials","article_published_time":"2018-12-11T09:44:34+00:00","article_modified_time":"2018-12-21T13:17:57+00:00","author":"Ekrem \u00d6nsoy","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ekrem \u00d6nsoy","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/"},"author":{"name":"Ekrem \u00d6nsoy","@id":"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46"},"headline":"SQL Server is not Starting(The system cannot find the path specified)","datePublished":"2018-12-11T09:44:34+00:00","dateModified":"2018-12-21T13:17:57+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/"},"wordCount":162,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/","url":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/","name":"SQL Server is not Starting(The system cannot find the path specified) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-12-11T09:44:34+00:00","dateModified":"2018-12-21T13:17:57+00:00","description":"SQL Server is not Starting(The system cannot find the path specified)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/sql-server-is-not-startingthe-system-cannot-find-the-path-specified\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"SQL Server is not Starting(The system cannot find the path specified)"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46","name":"Ekrem \u00d6nsoy","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g","caption":"Ekrem \u00d6nsoy"},"description":"The original article was written in Turkish by Ekrem \u00d6nsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.","url":"https:\/\/dbtut.com\/index.php\/author\/ekremonsoy\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6475","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/423"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=6475"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6475\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=6475"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=6475"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=6475"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}