Support and Training
Follow

Database Links Do Not Connect After SQL Server Restart

PROBLEM

When restarting Microsoft SQL Server (located on a server separate from the MetaCommunications Application Server), the database links do not restart. The database links appear to be started in the Database Links window found under the Activity menu but no connection can be made to the database from the client applications.


CAUSE

When Microsoft SQL Server and the MetaCommunications Application Server are located on the same physical server, there is a dependency between the two services. When the Microsoft SQL Server service is stopped, the MetaCommunications Application Server service also stops. This dependency does NOT exist in situations where the MetaCommunications Application Server and the Microsoft SQL Server reside on separate servers. Therefore, the database links do not restart when the Microsoft SQL Server service is restarted.


RESOLUTION

After a restart of the Microsoft SQL Server service, restart the MetaCommunications Application Server service. The database links will reconnect to the databases and users will be able to log into the databases.

To restart the MetaCommunication Application Server service do the following:

  1. Open the MetaCommunications Application Server Shell program. (Start->Programs->MetaCommunications->Application Server Shell)
  2. Choose Stop from the Server menu. This will stop the MetaCommunications Application Server service.
  3. Choose the Start option from the Server menu once it becomes available. This will restart the Application Server.

 

 

 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments