{"id":320,"date":"2012-07-22T22:12:18","date_gmt":"2012-07-23T05:12:18","guid":{"rendered":"https:\/\/mmman.itgroove.net\/?p=320"},"modified":"2023-02-24T21:47:01","modified_gmt":"2023-02-24T21:47:01","slug":"setting-up-a-sql-server-alias-with-sharepoint-server-2010","status":"publish","type":"post","link":"https:\/\/regroove.ca\/archive\/2012\/07\/22\/setting-up-a-sql-server-alias-with-sharepoint-server-2010\/","title":{"rendered":"Setting Up a SQL Server Alias with SharePoint Server 2010"},"content":{"rendered":"<p>Using a SQL Server alias, you\u2019ll be able to change the database server in your SharePoint farm.\u00a0 In addition, setting an alias should really be a best practice for most new farm builds.\u00a0 This technique is useful when moving or virtualising your database server, setting up a test environment, or especially when migrating from SQL Server 2008 \/ 2008 R2 to SQL Server 2012.<\/p>\n<p>Repeat the following steps for all your SharePoint Frontend and Application Servers. Important: Only do this on the SharePoint Servers. Don\u2019t do this on the SQL Server!<\/p>\n<p>The steps we\u2019re going to run include the following:<\/p>\n<p>1. Setup the alias using 32-bit config tool.<\/p>\n<p>2. Setup the (same) alias using 64-bit config tool.<\/p>\n<p>Let\u2019s begin\u2026<\/p>\n<h3>1. Run the 32-bit SQL tool.\u00a0 Run the following application, \u201cC:\\\\windows\\\\system32\\\\cliconfg.exe\u201d<\/h3>\n<p>Select the tab \u201cAlias\u201d and click the button \u201cAdd\u201d.<\/p>\n<p><a href=\"https:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2012\/07\/image.png\"><img loading=\"lazy\" decoding=\"async\" style=\"padding-left: 0px;padding-right: 0px;padding-top: 0px;border-width: 0px\" title=\"image\" src=\"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2012\/07\/image_thumb.png\" alt=\"image\" width=\"536\" height=\"344\" border=\"0\" \/><\/a><\/p>\n<p>Select \u201cTCP\/IP\u201d and define the name of your original server (as the alias). Next, fill in the new server name of your database server and select the \u201cDynamically determine port\u201d-checkbox. After that click \u201cOK\u201d.<\/p>\n<p>Note 1: If you know the port, you will actually want to uncheck the \u201cDynamically determine port\u201d, and set the fixed value.<\/p>\n<p>Note 2: If your new (or old) server is using an instance, be sure to include that, for example, something like NewServerName\\INSTANCENAME<\/p>\n<p><a href=\"https:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2012\/07\/image1.png\"><img loading=\"lazy\" decoding=\"async\" style=\"padding-left: 0px;padding-right: 0px;padding-top: 0px;border-width: 0px\" title=\"image\" src=\"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2012\/07\/image_thumb1.png\" alt=\"image\" width=\"592\" height=\"311\" border=\"0\" \/><\/a><\/p>\n<p>Now you have defined your SQL alias name. Click \u201cOK\u201d.<\/p>\n<p><a href=\"https:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2012\/07\/image2.png\"><img loading=\"lazy\" decoding=\"async\" style=\"padding-left: 0px;padding-right: 0px;padding-top: 0px;border-width: 0px\" title=\"image\" src=\"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2012\/07\/image_thumb2.png\" alt=\"image\" width=\"432\" height=\"277\" border=\"0\" \/><\/a><\/p>\n<p>Note: It\u2019s recommended that you should setup an alias for the server name itself, as well as it\u2019s fully qualified name \u2013 for example, setup an alias for \u201cOriginalServerName\u201d, as well as \u201cOriginalServerName.domain.com\u201d.<\/p>\n<h3>2. Run the 64-bit SQL tool. Run the following application, \u201cC:\\\\windows\\\\syswow64\\\\cliconfg.exe\u201d<\/h3>\n<p>Using the 64bit tool, repeat all the same steps you did above.<\/p>\n<p>After you\u2019ve completed steps (1) and (2) <strong>on each SharePoint Server<\/strong>, you can either create your new farm or startup your existing farm, and it should be working again with your new alias.<\/p>\n<p>Original Source: <a title=\"http:\/\/splog.cairo.ag\/2011\/02\/22\/using-sql-server-alias-names-with-sharepoint-server-2010\/\" href=\"http:\/\/splog.cairo.ag\/2011\/02\/22\/using-sql-server-alias-names-with-sharepoint-server-2010\/\">http:\/\/splog.cairo.ag\/2011\/02\/22\/using-sql-server-alias-names-with-sharepoint-server-2010\/<\/a> \u2013 Many thanks!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Using a SQL Server alias, you\u2019ll be able to change the database server in your SharePoint farm.\u00a0 In addition, setting an alias should really be a best practice for most new farm builds.\u00a0 This technique is useful when moving or virtualising your database server, setting up a test environment, or especially when migrating from SQL &hellip; <a href=\"https:\/\/regroove.ca\/archive\/2012\/07\/22\/setting-up-a-sql-server-alias-with-sharepoint-server-2010\/\"><\/a><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[24,7,32,33],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Setting Up a SQL Server Alias with SharePoint Server 2010 - Archive<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/regroove.ca\/archive\/2012\/07\/22\/setting-up-a-sql-server-alias-with-sharepoint-server-2010\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Setting Up a SQL Server Alias with SharePoint Server 2010 - Archive\" \/>\n<meta property=\"og:description\" content=\"Using a SQL Server alias, you\u2019ll be able to change the database server in your SharePoint farm.\u00a0 In addition, setting an alias should really be a best practice for most new farm builds.\u00a0 This technique is useful when moving or virtualising your database server, setting up a test environment, or especially when migrating from SQL &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/regroove.ca\/archive\/2012\/07\/22\/setting-up-a-sql-server-alias-with-sharepoint-server-2010\/\" \/>\n<meta property=\"og:site_name\" content=\"Archive\" \/>\n<meta property=\"article:published_time\" content=\"2012-07-23T05:12:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-24T21:47:01+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2012\/07\/image_thumb.png\" \/>\n<meta name=\"author\" content=\"Colin Phillips (Alumni)\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Colin Phillips (Alumni)\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/regroove.ca\/archive\/2012\/07\/22\/setting-up-a-sql-server-alias-with-sharepoint-server-2010\/\",\"url\":\"https:\/\/regroove.ca\/archive\/2012\/07\/22\/setting-up-a-sql-server-alias-with-sharepoint-server-2010\/\",\"name\":\"Setting Up a SQL Server Alias with SharePoint Server 2010 - Archive\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/archive\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/regroove.ca\/archive\/2012\/07\/22\/setting-up-a-sql-server-alias-with-sharepoint-server-2010\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/regroove.ca\/archive\/2012\/07\/22\/setting-up-a-sql-server-alias-with-sharepoint-server-2010\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2012\/07\/image_thumb.png\",\"datePublished\":\"2012-07-23T05:12:18+00:00\",\"dateModified\":\"2023-02-24T21:47:01+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b\"},\"breadcrumb\":{\"@id\":\"https:\/\/regroove.ca\/archive\/2012\/07\/22\/setting-up-a-sql-server-alias-with-sharepoint-server-2010\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/regroove.ca\/archive\/2012\/07\/22\/setting-up-a-sql-server-alias-with-sharepoint-server-2010\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/archive\/2012\/07\/22\/setting-up-a-sql-server-alias-with-sharepoint-server-2010\/#primaryimage\",\"url\":\"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2012\/07\/image_thumb.png\",\"contentUrl\":\"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2012\/07\/image_thumb.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/regroove.ca\/archive\/2012\/07\/22\/setting-up-a-sql-server-alias-with-sharepoint-server-2010\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog Archive\",\"item\":\"https:\/\/regroove.ca\/archive\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Setting Up a SQL Server Alias with SharePoint Server 2010\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/archive\/#website\",\"url\":\"https:\/\/regroove.ca\/archive\/\",\"name\":\"Archive\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/archive\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b\",\"name\":\"Colin Phillips (Alumni)\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g\",\"caption\":\"Colin Phillips (Alumni)\"},\"url\":\"https:\/\/regroove.ca\/archive\/author\/cphillips\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Setting Up a SQL Server Alias with SharePoint Server 2010 - Archive","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:\/\/regroove.ca\/archive\/2012\/07\/22\/setting-up-a-sql-server-alias-with-sharepoint-server-2010\/","og_locale":"en_US","og_type":"article","og_title":"Setting Up a SQL Server Alias with SharePoint Server 2010 - Archive","og_description":"Using a SQL Server alias, you\u2019ll be able to change the database server in your SharePoint farm.\u00a0 In addition, setting an alias should really be a best practice for most new farm builds.\u00a0 This technique is useful when moving or virtualising your database server, setting up a test environment, or especially when migrating from SQL &hellip;","og_url":"https:\/\/regroove.ca\/archive\/2012\/07\/22\/setting-up-a-sql-server-alias-with-sharepoint-server-2010\/","og_site_name":"Archive","article_published_time":"2012-07-23T05:12:18+00:00","article_modified_time":"2023-02-24T21:47:01+00:00","og_image":[{"url":"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2012\/07\/image_thumb.png"}],"author":"Colin Phillips (Alumni)","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Colin Phillips (Alumni)","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/regroove.ca\/archive\/2012\/07\/22\/setting-up-a-sql-server-alias-with-sharepoint-server-2010\/","url":"https:\/\/regroove.ca\/archive\/2012\/07\/22\/setting-up-a-sql-server-alias-with-sharepoint-server-2010\/","name":"Setting Up a SQL Server Alias with SharePoint Server 2010 - Archive","isPartOf":{"@id":"https:\/\/regroove.ca\/archive\/#website"},"primaryImageOfPage":{"@id":"https:\/\/regroove.ca\/archive\/2012\/07\/22\/setting-up-a-sql-server-alias-with-sharepoint-server-2010\/#primaryimage"},"image":{"@id":"https:\/\/regroove.ca\/archive\/2012\/07\/22\/setting-up-a-sql-server-alias-with-sharepoint-server-2010\/#primaryimage"},"thumbnailUrl":"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2012\/07\/image_thumb.png","datePublished":"2012-07-23T05:12:18+00:00","dateModified":"2023-02-24T21:47:01+00:00","author":{"@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b"},"breadcrumb":{"@id":"https:\/\/regroove.ca\/archive\/2012\/07\/22\/setting-up-a-sql-server-alias-with-sharepoint-server-2010\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/regroove.ca\/archive\/2012\/07\/22\/setting-up-a-sql-server-alias-with-sharepoint-server-2010\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/archive\/2012\/07\/22\/setting-up-a-sql-server-alias-with-sharepoint-server-2010\/#primaryimage","url":"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2012\/07\/image_thumb.png","contentUrl":"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2012\/07\/image_thumb.png"},{"@type":"BreadcrumbList","@id":"https:\/\/regroove.ca\/archive\/2012\/07\/22\/setting-up-a-sql-server-alias-with-sharepoint-server-2010\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Archive","item":"https:\/\/regroove.ca\/archive\/"},{"@type":"ListItem","position":2,"name":"Setting Up a SQL Server Alias with SharePoint Server 2010"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/archive\/#website","url":"https:\/\/regroove.ca\/archive\/","name":"Archive","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/archive\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b","name":"Colin Phillips (Alumni)","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g","caption":"Colin Phillips (Alumni)"},"url":"https:\/\/regroove.ca\/archive\/author\/cphillips\/"}]}},"_links":{"self":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/320"}],"collection":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/comments?post=320"}],"version-history":[{"count":1,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/320\/revisions"}],"predecessor-version":[{"id":1984,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/320\/revisions\/1984"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/media?parent=320"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/categories?post=320"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/tags?post=320"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}