Not being a SQL Server connection expert I still do not really understand why there isn't an explicit connection string that works and you have to go round the houses...

No I didn't get around to trying from another machine.

Here's the latest update....

I eventually found someone who could solve this and the answer was to create BOTH 32bit and 64bit System DSNs with the same name to connect to...

Lowell, Thanks for your input. In answer to your questions....

I do not recall changing the remote connection setting but it is definitley set to allow them.

I do not have another...

I've still been hunting for hours on this one with no luck.

I can ping the server, Windows Firewall is off and still I get the same Named Pipes error.

Could...

I still cannot get any errors output to the browser but have found the folowing in the IIS logs.

2012-06-13 15:24:55 W3SVC6 MYSERVERNAME nn.nnn.nnn.nn GET /MyDirectory/mypage.asp|4|80004005|Named_Pipes_Provider:_Could_not_open_a_connection_to_SQL_Server_[53]._ 80 - nn.nnn.nnn.nn HTTP/1.1 Mozilla/5.0+(compatible;+MSIE+9.0;+Windows+NT+6.1;+WOW64;+Trident/5.0)...

Thanks for that suggestion. Have tried that with Client and Server Side debugging enabled and opened ASP page using IE9 on the local machine to IIS. And I get a...

Thanks so much Lowell, replaced the originals with the dlls in the zip and it worked a treat.

Appreciate your help with that one as I had read the thread previously...

Thanks for your response Lowell.

That sounds like it could be the problem as the new installation is 64bit and the encryption toolkit dlls are probably quite a few years old...