Sharepoint 2010 - move all databases results in "Could not connect to the configuration database"
-
vendredi 15 juin 2012 11:46
Hi,
Following these posts, recently I tired to move all sharepoint 2010 databases to another server.
http://www.stuartroberts.net/index.php/2011/09/02/move-sharepoint-database/
http://technet.microsoft.com/en-us/library/cc512725.aspx
But, when the step-by-step procedure were done, the following error is appeared: "Could not connect to the configuration database".
I successfully attach all databases in new DB server, and I use the following parameters for creating the Alias in sharepoint server:
Alias Name: MSSQLSERVER (name of both previous and current database instance)
Port: (blank), using netstat command I see that the TCP/IP port of SQL instance is 1433.
Protocol: TCP/IP
Server: win2008-SQLR2 (server name of new DB server)
I can successfully ping the new DB server from the Sharepoint server (Application Server).
I am so confused and I do not know how can I debug this issue.
--Regards
Mhhe
Toutes les réponses
-
vendredi 15 juin 2012 14:17
-
vendredi 15 juin 2012 21:43
Hi,
Config database movement is not supported by Microsoft.
The best workaround is to create SQL alias as same as at new SQl server and then after try for the migration.
I had done these type of migration, Let me know if you have any issues. I will provide you the document.
Many Thanks
-
vendredi 15 juin 2012 22:04
Hi,
Config database movement is not supported by Microsoft.
I'd say that's not correct since config database movement is mentioned as a supported option in the technet article mhhe has linked to. The same article describes a procedure with lots of complex steps, so I'd recommend to retry it and make sure the steps are completed in a thorough manner
Kind Regards Bjoern
Blog- Modifié Bjoern H RappMicrosoft Community Contributor vendredi 15 juin 2012 23:24
-
samedi 16 juin 2012 04:23
Thanks for your response.
I thinks the main problem is regarded to the created alias.
When I traverse the sharepoint log the connection string is pointed to the old database server.
How can I check that the alias really works?
Thanks
-
samedi 16 juin 2012 06:29
Hi everybody,
The problem resolved.
The main issue was about the alias, where I should enter the IP address of original server instead on its name!!
Regards
- Marqué comme réponse Rock Wang– MSFT jeudi 21 juin 2012 07:18
.png)
