Moved Sharepoint databases, need to update connection string
Posted on 2012-09-02
I split a single Team Foundation Server into 2 tiers and put the SQL data on its own server. This works fine except Sharepoint (WSS 3.0) is filling up the event logs with the following error when SQL services are stopped on the old server, we'll call OLDSERVER:
Cannot connect to SQL Server. OLDSERVER not found. Additional error information from SQL Server is included below.
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
But I don't want it to connect to OLDSERVER, I want it to connect to the new SQL server. I ran the Sharepoint Products and Technologies Configuration Wizard and it says it's getting WSS_Config and content from NEWSERVER, not OLDSERVER.
If I start SQL services on OLDSERVER I get an "access denied" error when connection to SQL in the event log.
So if Sharepoint config wizard says it's pointing to NEWSERVER, and the content database from Central Administration says it's pointing to NEWSERVER, then why is it still trying to connect to OLDSERVER?