Trouble finding Error Code 40 or 53 in BooksOnline

Not all of the errors in sysmessages are in BOL. Some of them are very rare, so Microsoft spends a lot of time on the ones that happen most often or where the message text doesn't explicitly explain the problem. Having said that, as Microsoft receives errors and problems we constantly update Books Online to have not only the information about the error but causes and fixes (where possible).

40 and 53 are generic connection issues, so you'll see them a lot. Unfortunately they can be caused by everything from not typing your login properly to the server or network rejecting your connection. 40 is normally from the Named Pipes provider, so it can be a network name issue. 53 is often associated (but not always) with a port blocking issue or the server not being configured to allow remote connections.

You can find out more about both of them here:

http://blogs.msdn.com/sql_protocols/archive/2005/09/28/474698.aspx

Buck

(If this post helped you out, you can mark it as "answered")

BuckWoody at 2007-10-8 >