Able to connect via local host but not server

I have a page that connects to SQL server. It works fine when running in local host but when I publish to the server, I get the following:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Any ideas on where to start?

Thanks,

Mark

Try these two blog posts:

http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx

http://blogs.msdn.com/sql_protocols/archive/2005/10/29/486861.aspx

A Guide to SQL Server Transactional and Snapshot Replication from Hilary Cotter

Hi all
Can tell me anyone, if the book
A Guide to SQL Server Transactional and Snapshot Replication from
Hilary Cotter, Publish Date June 15/2004
are available?
How and where can I order this book.
http://www.nwsu.com/0974973602.html
Thanks Thomas
It hasn't gone to print yet. It should be going to print early next month.
Then it will take about 25-35 days to print. I'll announce when you can
preorder the book here.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Thomas Hase" <tohas@.freenet.de> wrote in message
news:41088b9f.6019281@.news.t-online.de...
> Hi all
> Can tell me anyone, if the book
> A Guide to SQL Server Transactional and Snapshot Replication from
> Hilary Cotter, Publish Date June 15/2004
> are available?
> How and where can I order this book.
> http://www.nwsu.com/0974973602.html
> Thanks Thomas
|||Hi Hillary,
thanks for fast reply. Currently I am working on an bidirectional
replication migration from 6.5 to 2k.
Additional information would be nice for me, but not absolute needed.
But 30 days are to late for me.
Is it possible to get an (beta) online issue?
Greetings from Germany
On Wed, 28 Jul 2004 08:12:58 -0400, "Hilary Cotter" <hilaryk@.att.net>
wrote:

>It hasn't gone to print yet. It should be going to print early next month.
>Then it will take about 25-35 days to print. I'll announce when you can
>preorder the book here.