We help IT Professionals succeed at work.

Remote Desktop Session disconnecting

Tim
Tim asked
on
45 Views
Last Modified: 2020-04-02
On Tuesday we had a power outage that lasted about 30 minutes but during that time all our servers shut down. When all the services came back up the network seemed OK however when my users started using our Terminal Server to connect to our ERP system DB it would work for a while then the user would get an SQLDBCode: 999 Select error: SQLSTATE = 08S01.

I have restarted all the servers and looked through the Event logs but I don't see anything that stands out. This all seems like the terminal session hiccups and the ERP system on the terminal server loses the connection to the database.

How do I troubleshoot/fix this issue?
Comment
Watch Question

CERTIFIED EXPERT

Commented:
If this wasn't happening prior to your power failure then I would probably look at the switchport that the server is connected to. Check the logs, there could be something happening to that port that is causing it to shutdown due to STP protection or another error.

That error is a communication break to the server or the connection. This is probably where I would start then work my way out from there.
David FavorFractional CTO
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Along the lines of the ITguy565 comment.

If all your gear was on UPS systems, then likely all their state was saved, so after power was restored all was well.

Any device not on a UPS with volatile state (no persistent storage for state/setup info) will likely have to be reconfigured.

These days almost every device maintains setup/state/config data across power cycles, so look at your entire infrastructure for any really old devices, for a good starting point for communication problems.

A common problem of old devices is ports reset to some slow speed + half duplex.

If this occurs, when connecting gear is set to something like 1G full duplex, then you'll see odd communication problems.
Technical Architect - HA/Compute/Storage
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.