April 30, 2020 at 9:05 pm
We have application stopped allowing connections. After digging into, nothing i could find on the database side. Guys do you think this would be related to app issue? I haven't checked with app team about what app log says. It doesn't look like to me a database or network issue. Any thoughts?
April 30, 2020 at 9:12 pm
Without a bit more information it is impossible to say.
What does it mean by "stopped allowing connections"? It could be account lockouts, could be your SQL is not doing authentication properly, could be account is locked, could be network issues, could be application issues...
Things I'd check are the logs you have access to. Check your SQL logs, check the windows server logs, check the client machine logs, check the application logs, check the EXACT wording of the error message, etc. If the error message has useful error messages (which I hope it does), that should tell you where to start looking.
Does the application work when ran for you or a user account that is known good on the database side? is it broken for everyone or just one user? Were updates done on the server or application prior to it breaking? Any firewall rules pushed out to the server or clients that may block the connection?
With SUCH little information, it is impossible to say if this is application, database, client, server, network, firewall, or solar flares...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply