{"id":32,"date":"2014-04-30T14:27:26","date_gmt":"2014-04-30T12:27:26","guid":{"rendered":"http:\/\/blog.mvoelkl.de\/?p=32"},"modified":"2014-04-30T14:27:26","modified_gmt":"2014-04-30T12:27:26","slug":"change-sql-server-configuration-like-port-in-a-clustered-environment","status":"publish","type":"post","link":"https:\/\/blog.mvoelkl.de\/?p=32","title":{"rendered":"Change SQL Server Configuration (like Port) in a Clustered Environment"},"content":{"rendered":"<p style=\"color: #666666;\">For SQL 2008:<\/p>\n<p style=\"color: #666666;\">Take SQL Server (XXX) Resource offline:<\/p>\n<p style=\"color: #666666;\">&gt;cluster res &#8220;SQL Server (XXX)&#8221; \/OFFLINE<\/p>\n<p style=\"color: #666666;\">Remove Registry Check:<\/p>\n<p style=\"color: #666666;\">&gt; cluster res &#8220;SQL Network Name (nnnnn)&#8221; \/removecheck:&#8221;SOFTWARE\\Microsoft\\Microsoft SQL Server\\MSSQL10.XXX\\MSSQLServer&#8221;<\/p>\n<p style=\"color: #666666;\">Do whatever you have to configure<\/p>\n<p style=\"color: #666666;\">\n<p style=\"color: #666666;\">Add the Registry Check:<\/p>\n<p style=\"color: #666666;\">cluster res &#8220;SQL Network Name (nnnnn)&#8221; \/addcheck:&#8221;SOFTWARE\\Microsoft\\Microsoft SQL Server\\MSSQL10.XXX\\MSSQLServer&#8221;<\/p>\n<p style=\"color: #666666;\">Take the Resources Online:<\/p>\n<p style=\"color: #666666;\">cluster res &#8220;SQL Server (XXX)&#8221; \/ONLINE<\/p>\n<p style=\"color: #666666;\">cluster res &#8220;SQL Server Agent (XXX)&#8221; \/ONLINE<\/p>\n<p style=\"color: #666666;\">&#8220;SQl Server (XXX)&#8221; is the Name of your SQL Resource in Failover Cluster Management, where XXX is a possible Instancename<\/p>\n","protected":false},"excerpt":{"rendered":"<p>For SQL 2008: Take SQL Server (XXX) Resource offline: &gt;cluster res &#8220;SQL Server (XXX)&#8221; \/OFFLINE Remove Registry Check: &gt; cluster res &#8220;SQL Network Name (nnnnn)&#8221; \/removecheck:&#8221;SOFTWARE\\Microsoft\\Microsoft SQL Server\\MSSQL10.XXX\\MSSQLServer&#8221; Do whatever you have to configure Add the Registry Check: cluster res &#8220;SQL Network Name (nnnnn)&#8221; \/addcheck:&#8221;SOFTWARE\\Microsoft\\Microsoft SQL Server\\MSSQL10.XXX\\MSSQLServer&#8221; Take the Resources Online: cluster res &#8220;SQL Server [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[],"class_list":["post-32","post","type-post","status-publish","format-standard","hentry","category-sqlserver"],"_links":{"self":[{"href":"https:\/\/blog.mvoelkl.de\/index.php?rest_route=\/wp\/v2\/posts\/32","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.mvoelkl.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.mvoelkl.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.mvoelkl.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.mvoelkl.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=32"}],"version-history":[{"count":1,"href":"https:\/\/blog.mvoelkl.de\/index.php?rest_route=\/wp\/v2\/posts\/32\/revisions"}],"predecessor-version":[{"id":33,"href":"https:\/\/blog.mvoelkl.de\/index.php?rest_route=\/wp\/v2\/posts\/32\/revisions\/33"}],"wp:attachment":[{"href":"https:\/\/blog.mvoelkl.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=32"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.mvoelkl.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=32"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.mvoelkl.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=32"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}