I have an odd problem. The company has used an ODBC connection for a desktop MDB program to connect to SQL Server. The ODBC connects using a SQL Server account to authenticate. It has worked without issue in the past.
Recently, it appears any new domain account does not connect. They always fail for an connection timeout error. I've tried creating brand new account, I've tried creating an account by "Copy as" and they still get a timeout error.
One additional twist, the first time I discovered this error, last week, was when I was moving a user to a different computer. The ODBC connection worked on her old computer but when logging on the new one, it timed out but still worked on her old computer. I also tried logging the user in on MY computer and her profile does a timeout.
I've tried rebooting the Domain Controller as well as the SQL Server. No changes on the network or any server.
2 Answers 2
I found a solution to the problem, but not sure why it works. I added an inbound Windows Firewall rule on the server, for port 1433 and the users in question can connect. Not sure why this affected a couple users and not 20 others, but at least it gets the spotlight off me! Thanks for everyone's input.
I had similar issue when a computer was upgraded. The default timeout had been 60 for the query in Access and worked, but I had to extend the timeout to 200.
Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=13497; handshake=14491; (.Net SqlClient Data Provider)