Why do I get "[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (CreateFile())"

This is a resources issue. Switch to TCP/IP instead of Named Pipes in the Microsoft SQL Server ODBC data source and the problem will go away.