locked
sql state s1t00 error windows 10 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    I'm having a problem with Access now that I upgraded to Windows 10. Looks like there is an issue with connectivity with the new SQL Server driver that was installed with the upgrade. My access database is on the public drive. No one else in the company is experiencing this problem. All other clients are on Window 7. Only seems to be with my workstation. Any suggestions?
    Tuesday, September 15, 2015 7:43 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Roysito,

    First of all, please ensure the machine has got the latest updates.

    For the error " s1t00 ", it usually means "Timeout expired".There may be something wrong with the connection, or the the query is getting blocked by some other process.
    Please try to ping the server both with the ip address and the name to have a check.
    We could run the following command line to reset the TCP/IP stack to have a check.
    ipconfig /flushdns (Clear the dns cache)
    nbtstat -RR (release and refesh NetBIOS names)
    netsh int ip reset (reset ip settings)
    netsh winsock reset (Reset Winsock Catalog)
    Reboot

    In addition, please turn off the firewall and the antivirus software temporarily to have a troubleshoot.
    Considering this issue is related to the SQL server, we also could try to ask for help from our SQL server forum.
    SQL server
    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlgetstarted
    Best regards

    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Wednesday, September 16, 2015 9:31 AM