Every now and again (today for example) I’ll get a call that one of our SQL Server instances is down. I’ll try to connect from my machine with no success. Then I’ll remote to the server itself and first check if the server is up, then if it is, try to connect locally. Today is one of those occasions where I was able to connect locally. So now I’m in a bit of a quandary. I can connect locally, but not remotely. There are a number of reasons that this can happen. Below I’ve listed the tests I perform to figure out what’s going on. There certainly may be additional items that can be tested and if you know them I would love to have you add a comment.
After each step if you have changed anything do a test remote connection to see if your problem is resolved.
Note: I’m abbreviating SQL Server Configuration Manager as SSCM
I’ve placed these in a specific order based on experience and ease of test/fix. Feel free to put them in whatever order you feel the most comfortable with.