Website error: The database could not be opened

Created:

2016-11-16 12:41:18 UTC

Modified:

2017-04-24 11:20:15 UTC

1

Was this article helpful?


Have more questions?

Submit a request

Website error: The database could not be opened

Applicable to:

  • Plesk 11.5 for Windows
  • Plesk 9.x and below for Windows

Symptoms

After migration to a new server, a website with remote Microsoft SQL database cannot be opened in a browser with an error:

    The database could not be opened!
Check your config.asp file and set the strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.
Code: 80004005
Error Description:
[DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation._

Cause

Config.asp file contains invalid IP mapping for the remote database server.

Resolution

  1. Locate config.asp in the domain document root "%plesk_vhosts%\\domain.tld\\httpdocs" .
  2. Open up the file for editing and find the string containing information on the remote database server IP. Example:

    strConnString = "Provider=sqloledb;
    Data Source=1.2.3.4,1433;
    Network Library=DBMSSOCN;
    Initial Catalog=lotofus;
    User ID=login;
    Password=password;
  3. Change the IP address to the proepr IP address of the database server.

Have more questions? Submit a request
Please sign in to leave a comment.