I recently encountered an issue with a customer connecting to Microsoft Dynamics SL via Terminal Services. The administrative user on the server could login to Dynamics SL but the non-admin users received an error message SQL Server Error 258: Unable to complete login due to timeout.
We tested changing access rights in SQL for the non-admin users and added the non-admin users to the local administrator group on the Terminal Server. No change. We rebooted the Terminal Server and the SQL Server. No change. I read a blog post about the TCP/IP Listener becoming hung up and decided to disable and enable the TPC/IP protocol for SQL Server.
Solution: Disable TCP/IP via SQL Configuration Manager. Reboot the SQL Server and enable TCP/IP. Have the user login to Dynamics SL.
Issue Resolved! Go figure. I hope this saves you some brain cycles if you encounter a similar issue.
0 Comments