SQL Server Error 258

 

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