Tuesday, June 1, 2010

WCF Hosted in IIS cannot access a SQL Server

WCF Hosted in IIS cannot access a SQL Server. Looks like a WCF Webservice that is hosted in IIS makes a remote connection to a SQL Server, while it looks like it is a local connection.
http://social.msdn.microsoft.com/forums/en-US/wcf/thread/2fdc2490-f29d-41df-bc47-1ff848871996

Probably i have to set the TCP connection to enabled, and allow it through the firewall. To configure SQL Server for various protocols see this link:
http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/

No comments:

Post a Comment