Authentication Problem in Silverlight - Cannot connect to SQL Server

Posted by Johann on Stack Overflow See other posts from Stack Overflow or by Johann
Published on 2010-05-13T08:59:56Z Indexed on 2010/05/13 14:44 UTC
Read the original article Hit count: 218

Hi All,

At the moment, when I try to register a user using the default Business Template in Silverlight, I am getting an error. Basically I am following a tutorial found on Channel 9 on how to build a business app with Silverlight.

"An error has occurred while establishing a connection to the server.

(provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 5)

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) (Microsoft SQL Server, Error: 1326)".

I found a blog where it identifies the problem, and followed every step, however I am still getting the same problems.

Here is my connection string:-

<add name="SIEventManagerEntities" 
     connectionString="metadata=res://*/EventManagerDBModel.csdl|res://*/EventManagerDBModel.ssdl|res://*/EventManagerDBModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=MONFU-PC;Initial Catalog=SIEventManager;Integrated Security=SSPI;MultipleActiveResultSets=True&quot;" 
     providerName="System.Data.EntityClient" />

Any help would really be very much appreciated!

Thanks

© Stack Overflow or respective owner

Related posts about silverlight-4.0

Related posts about sql-server