Connection strings after migration from external SQL servers.

Created:

2016-11-16 13:07:56 UTC

Modified:

2017-06-09 09:44:08 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Connection strings after migration from external SQL servers.

Applicable to:

  • Plesk for Windows

Symptoms

Websites are not functioning after migration from Plesk or other product with external or centralized SQL server to Plesk with local or new external SQL server.

Cause

Plesk does not make any changes in the website content and the connection strings are not changed to new location of SQL servers.

Resolution

  • You can search for connection strings in web site content (web.config or CMS config.php e.t.c) and change them manually.

  • Also you can find all connection strings using the following commands:

    cd %plesk_vhosts%\\VHOST_NAME
    findstr /S /I MySQL_SERVER_NAME.TLD *
    findstr /S /I MySQL_SERVER_IP_ADDRESS *
    findstr /S /I MSSQL_SERVER_MAME.TLD *
    findstr /S /I MSSQL_SERVER_IP_ADDRESS *
Have more questions? Submit a request
Please sign in to leave a comment.