{"id":245,"date":"2013-01-31T15:01:37","date_gmt":"2013-01-31T14:01:37","guid":{"rendered":"http:\/\/www.andreazin.it\/solutions\/?p=245"},"modified":"2013-01-31T15:49:52","modified_gmt":"2013-01-31T14:49:52","slug":"sqlserver-2012-locate-database-files","status":"publish","type":"post","link":"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html","title":{"rendered":"SqlServer 2012 – Cannot access the specified path or file on the server"},"content":{"rendered":"

Avete ricevuto l’errore riportato sotto\u00a0e siete in un ambiente cluster ?
\nAvete modificato i dischi o tolto e rimesso delle risorse al servizio cluster MsSql ?<\/p>\n

TITLE: Locate Database Files<\/strong> – SVDB2012S0<\/em><\/span><\/p>\n

M:\\MSSQL11.MSSQLFF\\MSSQL\\Backup<\/em>
\nCannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists. If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box<\/strong>.<\/span><\/p>\n

Or<\/span><\/p>\n

System.Data.SqlClient.SqlError: Cannot use file for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it. (Microsoft.SqlServer.SmoExtended)<\/strong><\/p>\n

Soluzione:<\/span><\/p>\n

Il problema potrebbero essere le dipendenze. Se guardate nelle risorse del servizio in cluster di SqlServer, vedrete le varie risorse: Server, Network, Storage e SQL Server e SQL Server Agent. Bene, l’errore nel mio caso era scatenato dal fatto che il servizio SQL Server partiva prima dello storage e quindi non riusciva ad accedervi poich\u00e8 non lo vedeva come una risorsa disponibile. Poco importa se partiva un millisecondo dopo e se il sistema operativo host poteva accederci…<\/span><\/p>\n

\"\"<\/a><\/span><\/p>\n

Per sistemare il problema dovete cliccare con il tasto dx sul servizio\u00a0SQL Server e impostare le Dependency aggiungendo i due dischi dello storage.
\nIn questo modo, quando farete partire il cluster di SQLServer, lui far\u00e0 partire prima i dischi dello storage e poi il servizio SQL Server che, questa volta, trover\u00e0 correttamente la disponibilit\u00e0 della risorsa e tutto funzioner\u00e0 correttamente !<\/span><\/p>\n

\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Avete ricevuto l’errore riportato sotto\u00a0e siete in un ambiente cluster ? Avete modificato i dischi o tolto e rimesso delle risorse al servizio cluster MsSql ? TITLE: Locate Database Files – SVDB2012S0 M:\\MSSQL11.MSSQLFF\\MSSQL\\Backup Cannot access the specified path or file … Continua a leggere→<\/span><\/a><\/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":[48],"tags":[51,55,52,53,50,49,75,54],"class_list":["post-245","post","type-post","status-publish","format-standard","hentry","category-sqlserver","tag-cluster","tag-datacenter","tag-error","tag-server","tag-sql","tag-sql-server-2012","tag-sqlserver","tag-windows-2012"],"yoast_head":"\nSql Server - Cannot access the specified path or file on the server<\/title>\n<meta name=\"description\" content=\"Il problema potrebbero essere le dipendenze. Nelle risorse del servizio in cluster di SqlServer: Server, Network, Storage e SQL Server e SQL Server Agent.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sql Server - Cannot access the specified path or file on the server\" \/>\n<meta property=\"og:description\" content=\"Il problema potrebbero essere le dipendenze. Nelle risorse del servizio in cluster di SqlServer: Server, Network, Storage e SQL Server e SQL Server Agent.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html\" \/>\n<meta property=\"og:site_name\" content=\"Note book\" \/>\n<meta property=\"article:published_time\" content=\"2013-01-31T14:01:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-01-31T14:49:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.andreazin.it\/solutions\/wp-content\/uploads\/2013\/01\/sql1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"442\" \/>\n\t<meta property=\"og:image:height\" content=\"434\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Andrea\" \/>\n<meta name=\"twitter:label1\" content=\"Scritto da\" \/>\n\t<meta name=\"twitter:data1\" content=\"Andrea\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html\"},\"author\":{\"name\":\"Andrea\",\"@id\":\"https:\/\/www.andreazin.it\/solutions\/#\/schema\/person\/e47a2b851307c3b969373910264a37ef\"},\"headline\":\"SqlServer 2012 – Cannot access the specified path or file on the server\",\"datePublished\":\"2013-01-31T14:01:37+00:00\",\"dateModified\":\"2013-01-31T14:49:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html\"},\"wordCount\":305,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.andreazin.it\/solutions\/wp-content\/uploads\/2013\/01\/sql1-300x294.jpg\",\"keywords\":[\"Cluster\",\"Datacenter\",\"Error\",\"Server\",\"Sql\",\"Sql Server 2012\",\"SqlServer\",\"Windows 2012\"],\"articleSection\":[\"SqlServer\"],\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html\",\"url\":\"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html\",\"name\":\"Sql Server - Cannot access the specified path or file on the server\",\"isPartOf\":{\"@id\":\"https:\/\/www.andreazin.it\/solutions\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.andreazin.it\/solutions\/wp-content\/uploads\/2013\/01\/sql1-300x294.jpg\",\"datePublished\":\"2013-01-31T14:01:37+00:00\",\"dateModified\":\"2013-01-31T14:49:52+00:00\",\"author\":{\"@id\":\"https:\/\/www.andreazin.it\/solutions\/#\/schema\/person\/e47a2b851307c3b969373910264a37ef\"},\"description\":\"Il problema potrebbero essere le dipendenze. Nelle risorse del servizio in cluster di SqlServer: Server, Network, Storage e SQL Server e SQL Server Agent.\",\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html#primaryimage\",\"url\":\"https:\/\/www.andreazin.it\/solutions\/wp-content\/uploads\/2013\/01\/sql1.jpg\",\"contentUrl\":\"https:\/\/www.andreazin.it\/solutions\/wp-content\/uploads\/2013\/01\/sql1.jpg\",\"width\":\"442\",\"height\":\"434\"},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.andreazin.it\/solutions\/#website\",\"url\":\"https:\/\/www.andreazin.it\/solutions\/\",\"name\":\"Note book\",\"description\":\"Appunti di un ICT Manager\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.andreazin.it\/solutions\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"it-IT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.andreazin.it\/solutions\/#\/schema\/person\/e47a2b851307c3b969373910264a37ef\",\"name\":\"Andrea\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/www.andreazin.it\/solutions\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/14d0a0eb9347c19954bb41ace85b9bbe1cc906c8bf44a99f75896df0e81d154a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/14d0a0eb9347c19954bb41ace85b9bbe1cc906c8bf44a99f75896df0e81d154a?s=96&d=mm&r=g\",\"caption\":\"Andrea\"},\"sameAs\":[\"http:\/\/www.andreazin.it\"],\"url\":\"https:\/\/www.andreazin.it\/solutions\/author\/administrator\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Sql Server - Cannot access the specified path or file on the server","description":"Il problema potrebbero essere le dipendenze. Nelle risorse del servizio in cluster di SqlServer: Server, Network, Storage e SQL Server e SQL Server Agent.","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.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html","og_locale":"it_IT","og_type":"article","og_title":"Sql Server - Cannot access the specified path or file on the server","og_description":"Il problema potrebbero essere le dipendenze. Nelle risorse del servizio in cluster di SqlServer: Server, Network, Storage e SQL Server e SQL Server Agent.","og_url":"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html","og_site_name":"Note book","article_published_time":"2013-01-31T14:01:37+00:00","article_modified_time":"2013-01-31T14:49:52+00:00","og_image":[{"width":442,"height":434,"url":"https:\/\/www.andreazin.it\/solutions\/wp-content\/uploads\/2013\/01\/sql1.jpg","type":"image\/jpeg"}],"author":"Andrea","twitter_misc":{"Scritto da":"Andrea","Tempo di lettura stimato":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html#article","isPartOf":{"@id":"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html"},"author":{"name":"Andrea","@id":"https:\/\/www.andreazin.it\/solutions\/#\/schema\/person\/e47a2b851307c3b969373910264a37ef"},"headline":"SqlServer 2012 – Cannot access the specified path or file on the server","datePublished":"2013-01-31T14:01:37+00:00","dateModified":"2013-01-31T14:49:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html"},"wordCount":305,"commentCount":0,"image":{"@id":"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html#primaryimage"},"thumbnailUrl":"http:\/\/www.andreazin.it\/solutions\/wp-content\/uploads\/2013\/01\/sql1-300x294.jpg","keywords":["Cluster","Datacenter","Error","Server","Sql","Sql Server 2012","SqlServer","Windows 2012"],"articleSection":["SqlServer"],"inLanguage":"it-IT","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html","url":"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html","name":"Sql Server - Cannot access the specified path or file on the server","isPartOf":{"@id":"https:\/\/www.andreazin.it\/solutions\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html#primaryimage"},"image":{"@id":"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html#primaryimage"},"thumbnailUrl":"http:\/\/www.andreazin.it\/solutions\/wp-content\/uploads\/2013\/01\/sql1-300x294.jpg","datePublished":"2013-01-31T14:01:37+00:00","dateModified":"2013-01-31T14:49:52+00:00","author":{"@id":"https:\/\/www.andreazin.it\/solutions\/#\/schema\/person\/e47a2b851307c3b969373910264a37ef"},"description":"Il problema potrebbero essere le dipendenze. Nelle risorse del servizio in cluster di SqlServer: Server, Network, Storage e SQL Server e SQL Server Agent.","inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html"]}]},{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/www.andreazin.it\/solutions\/sqlserver-2012-locate-database-files.html#primaryimage","url":"https:\/\/www.andreazin.it\/solutions\/wp-content\/uploads\/2013\/01\/sql1.jpg","contentUrl":"https:\/\/www.andreazin.it\/solutions\/wp-content\/uploads\/2013\/01\/sql1.jpg","width":"442","height":"434"},{"@type":"WebSite","@id":"https:\/\/www.andreazin.it\/solutions\/#website","url":"https:\/\/www.andreazin.it\/solutions\/","name":"Note book","description":"Appunti di un ICT Manager","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.andreazin.it\/solutions\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"it-IT"},{"@type":"Person","@id":"https:\/\/www.andreazin.it\/solutions\/#\/schema\/person\/e47a2b851307c3b969373910264a37ef","name":"Andrea","image":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/www.andreazin.it\/solutions\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/14d0a0eb9347c19954bb41ace85b9bbe1cc906c8bf44a99f75896df0e81d154a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/14d0a0eb9347c19954bb41ace85b9bbe1cc906c8bf44a99f75896df0e81d154a?s=96&d=mm&r=g","caption":"Andrea"},"sameAs":["http:\/\/www.andreazin.it"],"url":"https:\/\/www.andreazin.it\/solutions\/author\/administrator"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6bwSK-3X","_links":{"self":[{"href":"https:\/\/www.andreazin.it\/solutions\/wp-json\/wp\/v2\/posts\/245","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.andreazin.it\/solutions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.andreazin.it\/solutions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.andreazin.it\/solutions\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.andreazin.it\/solutions\/wp-json\/wp\/v2\/comments?post=245"}],"version-history":[{"count":7,"href":"https:\/\/www.andreazin.it\/solutions\/wp-json\/wp\/v2\/posts\/245\/revisions"}],"predecessor-version":[{"id":255,"href":"https:\/\/www.andreazin.it\/solutions\/wp-json\/wp\/v2\/posts\/245\/revisions\/255"}],"wp:attachment":[{"href":"https:\/\/www.andreazin.it\/solutions\/wp-json\/wp\/v2\/media?parent=245"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.andreazin.it\/solutions\/wp-json\/wp\/v2\/categories?post=245"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.andreazin.it\/solutions\/wp-json\/wp\/v2\/tags?post=245"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}