SQL Server Connection Problems

by Anonymous

I am having SQL Server connection problems.

I get the message "An error has occurred while establishing a connection to the server".

I have definitely got the right login and password, and I can connect OK when I sit at the console.

Please help.

ANSWER:
There are so many possible reasons for an inability to establish a connection, but your error message suggests that invalid credentials are not the problem!

I wrote an article last year about this in which I outlined a methodical approach to tracking down the cause.

Read it here.