SharePoint 2010: Malformed Configuration Database Name after Update Causes Exception
Recently, I updated my SharePoint 2010 RTM farm to SharePoint 2010 SP1. I followed the steps touched on here on my WFE. I had a good hour before the June Cumulative rollup would be finished downloading so I figured I'd run the Configuration Wizard on my WFE then go and upgrade my index server.
I was soon presented with the screen that lists the configuration server and database names. I had a feeling things wouldn't go well when I saw the following:
Configuration Database Server "172.20.1.10 " Configuration Database Name SharePoint_Config
Yep, the server name includes 3 extra characters: two quotes and one space. That, of course, isn't a resolvable hostname and I soon encountered the error:
Failed to initiate the upgrade sequence.
An exception of type System.Data.SqlClient.SqlException was thrown. Additional exception information: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Total number of configuration settings run: 2
Ugh. I figured, perhaps, I could fix this using PowerShell, but quickly skimming the available commands, I didn't see anything that may be useful aside from New-SPConfigurationDatabase. That didn't work, of course, because the server was already associated with a Config Database. So then I poked around with psconfig and running psconfig -cmd configdb -connect -server 172.20.1.10 -database SharePoint_Config -passphrase mypp didn't work because I was already connected to a farm.
I finally gave in and disconnected my server from the farm using psconfig -cmd configdb disconnect then I ran the Configuration Wizard again and set myself back up. To finish up the upgrade, I executed psconfig.exe -cmd upgrade -inplace b2b -wait.
My farm worked well until I applied the June Cumulative Rollup, after which I had to just start from scratch. I'm unsure if the FAIL is related.