The cannot connect to the configuration database error occurs after the SharePoint host name is modified.

I originally wanted to change the URL of SharePoint, because the URL is the host name, so I want to change the host name, can I automatically change the URL. But later I found this idea silly and naive. After I change the host name, I can use the new host name to connect to the SharePoint site. The following error occurs: cannot connect to the configuration database.

I will use SharePoint 2010 Product Configuration Wizard to reconfigure, first disconnect, connect to the existing SharePoint farm, connect to the local database server, find the sharepoint_config database, and reconfigure successfully. In this case, you can connect again, but you still cannot connect. This is why I remember that the site URL should be in the SharePoint database. I just modified my host name and re-connected to the database. So I changed the host name back to the original host name, and then made it again.SharePoint 2010 Product Configuration Wizard. However, I found that I could not connect to the SharePoint central administration site, and the training schedule site I created was accessible.

One idea is to back up training schedule and reinstall Sharepoint. However, I checked some information and used the administration site to back up the data. Later, I checked some items and used the command line tool to back up them.

I deleted all databases in SQL Server and Sharepoint, and then created a new farm using SharePoint 2010 Product Configuration Wizard. Import the previously backed up site.

Later, I found the following three steps on the Internet to modify the SharePoint site URL, which has not been tested yet.

Step 1: modify "Alternative access ing" in the sharepoint3.0 Management Center ": 1. Go to SharePoint Management Center 2. Select the "operations" tab 3. Click the "Alternative access ing" Link 4. Change the access ing link to the URL with the new server name. Step 2: use the renameserver option in the stsadm command: 1. Enter the command line operation interface (Start Menu ---> RUN ---> cmd ---> press Enter) 2. Enter the Directory: C: \ Program Files \ common files \ microsoft shared \ Web Server Extensions \ 12 \ bin3. Run the following command: stsadm-O renameserver-newservername <newname>-oldservername <oldname>: modify the server name 1. Right-click "my computer" and select "properties" 2. Select "modify" in "computer name" 3. enter a new server name, and restart the server.

 

Step 1: modify "Alternative access ing" in the sharepoint3.0 Management Center ": 1. Go to SharePoint Management Center 2. Select the "operations" tab 3. Click the "Alternative access ing" Link 4. Change the access ing link to the URL with the new server name. Step 2: use the renameserver option in the stsadm command: 1. Enter the command line operation interface (Start Menu ---> RUN ---> cmd ---> press Enter) 2. Enter the Directory: C: \ Program Files \ common files \ microsoft shared \ Web Server Extensions \ 12 \ bin3. Run the following command: stsadm-O renameserver-newservername <newname>-oldservername <oldname>: modify the server name 1. Right-click "my computer" and select "properties" 2. Select "modify" in "computer name" 3. enter a new server name, and restart the server.