{"id":3993,"date":"2006-03-29T21:34:00","date_gmt":"2006-03-29T21:34:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/buckh\/2006\/03\/29\/diy-running-tfs-using-a-named-instance-in-sql\/"},"modified":"2006-03-29T21:34:00","modified_gmt":"2006-03-29T21:34:00","slug":"diy-running-tfs-using-a-named-instance-in-sql","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/buckh\/diy-running-tfs-using-a-named-instance-in-sql\/","title":{"rendered":"DIY:  Running TFS using a named instance in SQL"},"content":{"rendered":"<p>The question about using a named instance with TFS has come up several times, and it came up again today on an internal mailing list.&nbsp; As to why we don&#8217;t support it in V1, <a href=\"http:\/\/blog.msdn.com\/bharry\">Brian Harry<\/a> states that it was the time to get it into setup and the additional testing that led to the decision to postpone it to a future version.<\/p>\n<p>However, for those of you who want to try it, there is a &#8220;do it yourself&#8221; approach.&nbsp; Bill Essary posted the outline of how to do it in the following <a href=\"http:\/\/forums.microsoft.com\/MSDN\/ShowPost.aspx?PostID=281516&amp;SiteID=1\">forum post<\/a>.&nbsp; I&#8217;ve copied the answer below, and added some links to the <a href=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms253088(VS.80).aspx\">TFS admin utilities<\/a> and SQL&nbsp;docs.&nbsp; Keep in mind this is not a supported and tested setup.<\/p>\n<blockquote>\n<p>TFS only supports operation on the default SQL instance in V1.&nbsp; If you are determined to try move TFS to a non-default instance, you might have better luck experimenting with a SQL native client alias.&nbsp; This allows you to map a non-standard port for a server name in a connection string without actually introducing the port number into the connection string itself. <\/p>\n<p>Here is how you create an alias:<\/p>\n<p>1) Open <a href=\"http:\/\/msdn2.microsoft.com\/en-US\/library\/ms174212.aspx\">SQL Server Configuration Manager<\/a> on the TFS application tier machine<\/p>\n<p>2) Expand the <a href=\"http:\/\/msdn2.microsoft.com\/en-US\/library\/ms191187(SQL.90).aspx\">SQL Native Client Configuration<\/a> node <\/p>\n<p>3) Right click on Aliases and select <a href=\"http:\/\/msdn2.microsoft.com\/en-US\/library\/ms188635(SQL.90).aspx\">New Alias&#8230;<\/a><\/p>\n<p>4) Enter an alias name and a SQL port number for that alias<\/p>\n<p>Use <a href=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms253176.aspx\">tfsreg<\/a> and <a href=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms252443.aspx\">renamedt<\/a> to replace the SQL Server name with the name of the alias.&nbsp; Alternately, reinstall the TFS AT using the alias instead of the real SQL Server name.<\/p>\n<\/blockquote>\n<p dir=\"ltr\">If you have questions, be sure to post them in the <a href=\"http:\/\/forums.microsoft.com\/msdn\/showforum.aspx?forumid=22&amp;siteid=1\">Visual Studio Team Foundation Forum<\/a>.<\/p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The question about using a named instance with TFS has come up several times, and it came up again today on an internal mailing list.&nbsp; As to why we don&#8217;t support it in V1, Brian Harry states that it was the time to get it into setup and the additional testing that led to the [&hellip;]<\/p>\n","protected":false},"author":94,"featured_media":10268,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[6,8],"class_list":["post-3993","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-source-control","tag-team-foundation"],"acf":[],"blog_post_summary":"<p>The question about using a named instance with TFS has come up several times, and it came up again today on an internal mailing list.&nbsp; As to why we don&#8217;t support it in V1, Brian Harry states that it was the time to get it into setup and the additional testing that led to the [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/posts\/3993","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/users\/94"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/comments?post=3993"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/posts\/3993\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/media\/10268"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/media?parent=3993"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/categories?post=3993"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/tags?post=3993"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}