By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,635 Members | 1,703 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,635 IT Pros & Developers. It's quick & easy.

Not connceting to remote sqlserver through IIS

P: n/a
When I create an websit in VS2005 and run it then it is running on the port
and it is connecting to remote sqlserver. But when I create Virtual directory
in IIS and try to run my website it is not connecting to remote sqlserver. i
am getting the following error.

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)

Can any one help me in this?
Jan 29 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi Reddy,

Are you connecting to IIS hosting ASP.NET 2005 and SQL Server 2000 ????

--
Thanks,
Sanket Sirotiya
(sa*************@yahoo.com)

"Reddy" <Re***@discussions.microsoft.comwrote in message
news:71**********************************@microsof t.com...
When I create an websit in VS2005 and run it then it is running on the
port
and it is connecting to remote sqlserver. But when I create Virtual
directory
in IIS and try to run my website it is not connecting to remote sqlserver.
i
am getting the following error.

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)

Can any one help me in this?

Jan 29 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.