July 11, 2016 at 7:09 am
I am using Windows Server 2008 R2 and SQL Server 2008 R2. I had applied the latest update from Microsoft a few days back. Whenever the user connects to SQL Server and remains idle for some time the front end system (Microsoft Access) gets hanged or I get the following message and I have to restart the system. If the user works continuously there is no issue. The error message is as follows:
Connection failed:
SQL State "08001"
SQL Server Error 26
I have been using the same platform for the last five years. It is after applying the latest automatic updates, I am getting the above error message.
July 12, 2016 at 12:38 am
Disable firewall from Start > All programs > Microsoft SQL server > Configuration Tools > SQL server configuration manager> SQL server network configuration > Select protocol
> Enable TCP\IP
> Restart SQL service
For more, visit: http://stackoverflow.com/questions/13405208/diagnosing-connection-to-sql-server
> Create an empty file called test.udl using a text editor
> Double click the file test.udl, then specify your connection properties
> Hit the "Test Connection" button.
For more, visit: http://www.sqlserverlogexplorer.com/fix-error-code-26/ [/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply