I am facing an issue on SQL Server, i am getting this error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2). But error is not coming everytime i connect. It gives me error sometime.
I have enabled all services added exception on firewall, disabled firewall.
Os is windows server 2008 r2, and SQL server 2208 r2 is database.
Server gives me following error:
Error: 18456, Severity: 14, State: 8.
Error: 18456, Severity: 14, State: 5.: Login failed for user 'sa'. Reason: Password did not match that for the login provided.