Posted by xx75vulcan on 06/19/07 13:21

On Jun 18, 4:34 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> xx75vulcan (xx75vul...@gmail.com) writes:
> > If I write ASP scripts to run from the first Win 2003 Web server,
> > trying to connect to the second box actually running the SQL Server it
> > gives an error:
> > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> > [Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not
> > exist or access denied.
>
> Maybe this article can give some clues?http://support.microsoft.com/default.aspx?scid=KB;EN-US;q328306.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

I've read that particular article somewhere before, and I believe I
have the settings/common problems correct.
I'm wondering, do I need to setup a "Linked Server" between the SQL
box and the web box not running SQL?

It appears that "linked servers" provide OLE DB providers and OLE DB
data sources?

[Back to original message]