Get your server issues fixed by our experts for a price starting at just 25 USD/Hour. Click here to register and open a ticket with us now!

Author Topic: Database could not be opened error after migration  (Read 2913 times)

0 Members and 1 Guest are viewing this topic.

jominj

  • Guest
Database could not be opened error after migration
« on: March 03, 2014, 06:34:53 am »
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._


This error is due to config.asp file contains invalid IP mapping for the remote database server.


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:

   
Code: [Select]
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.