{"id":299,"date":"2011-10-25T11:02:09","date_gmt":"2011-10-25T16:02:09","guid":{"rendered":"http:\/\/www.ryanbelanger.com\/?p=299"},"modified":"2011-10-25T11:02:09","modified_gmt":"2011-10-25T16:02:09","slug":"sharepoint-2010-fix-changing-computer-name","status":"publish","type":"post","link":"https:\/\/ryanbelanger.com\/?p=299","title":{"rendered":"SharePoint 2010 – fix changing computer name"},"content":{"rendered":"

If you have a SharePoint installation and for some reason you changed the name of the machine on which the SQLServer instance is running, SharePoint won’t be able to connect to the database server anymore. The reason is because SharePoint stores the computer name (netbios name) in many places in its configuration database.\u00a0 In order to fix this issue, you must reconfigure SharePoint to let it know the new SQL Server location.<\/p>\n

On my developer machine (Windows 7), I installed SharePoint as suggested by Microsoft for developer computers so this creates a separate instance for SharePoint on the local SQL Server.\u00a0 It is not required to enter the instance name when you configure the server, only the computer name will be enough.<\/p>\n

The following steps are based on Pinal Dave’s procedure he posted on his blog<\/a>: http:\/\/www.sqlauthority.com<\/a>. Great blog by the way, go take a look!<\/p>\n

1- Start SharePoint 2010 Management Shell (Run as administrator)\"\"<\/p>\n

2- Run the following command:<\/p>\n

stsadm -o setconfigdb -databaseserver myComputer -farmuser myDomain\\myUser -farmpassword myPassword<\/pre>\n
NOTE: This might take several minutes to complete.<\/strong><\/p>\n
\"\"<\/p>\n
3- Go into Internet Information Services Manager
\n\"\"<\/p>\n
4-\u00a0Remove the SharePoint Central Administration v4 site. It will be re-created automatically later.
\n\"\"<\/a><\/p>\n
5- Run the SharePoint 2010 Products Configuration Wizard
\n\"\"<\/p>\n
6- Click Next > on the Welcome Screen.\u00a0 NOTE: You might need to run the SharePoint Configuration Wizard twice if the removed administration site is not created the first time<\/strong>.
\n\"\"<\/p>\n
7- You’re done, you should now be able to connect to your SharePoint Central Administration website.<\/p>\n
\"\"<\/p>\n
Next time you configure your SharePoint server, do it with database aliases<\/strong> <\/a>instead of server names.<\/p>\n","protected":false},"excerpt":{"rendered":"
If you have a SharePoint installation and for some reason you changed the name of the machine on which the SQLServer instance is running, SharePoint won’t be able to connect to the database server anymore. The reason is because SharePoint stores the computer name (netbios name) in many places in its configuration database.\u00a0 In order […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-299","post","type-post","status-publish","format-standard","hentry","category-tips"],"_links":{"self":[{"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=\/wp\/v2\/posts\/299","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=299"}],"version-history":[{"count":0,"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=\/wp\/v2\/posts\/299\/revisions"}],"wp:attachment":[{"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=299"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=299"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=299"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}