I have a customer running RMS v2 SP3 on a Win XP Pro SP3 system that just started getting this error. The system has the RMS database locally with a fixed IP. They get the error multiple times a day and the systems locks completely. Up until a week ago they had no problems.
Database connection lost, application will be closed. Error #-2147467259
We have:
- reinstalled both RMS v2 sp3 and SQL Express 2005
- In SQL Server 2005 Configuration Tools Client Protocols set Named Pipes as enabled and #1, set TCP/IP as enabled and #2
- SQL Server 2005 Configuration Tools Surface Area Configuration for Services and Connections selected Local & Remote connections using both TCP/IP and Named Pipes is selected
- Turn off Auto_Close for SQL 2005/2008 Express
Does anyone have any other suggestions?