Im at a new workplace that has a sql server setup where all the office computers can access and modify a database through an application.
A few days ago, the application stopped working on all the computers except the one where the database is located. I get the “error 08001 unable to complete login process due to delay establishing connection with server.
Ive confirmed the sql server instance is up and running. Ive confirmed the application works locally in the machine the database is at. Ive checked the network and all the computers have access to the machine where the database is located (they just cant use the application). Ive checked the tcp/ip ports, changed the dynamic ports to the default 1433. Ive changed the firewall settings on the client computers so all the ports that sql uses are open. Ive extended the timeout from 600 to 1500.
And still i keep getting the same error.
Does anyone have any idea what the problem could be? It was working before, so the setup was fine at one point. What could have changed?