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: 228
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="Data Source=MONFU-PC;Initial Catalog=SIEventManager;Integrated Security=SSPI;MultipleActiveResultSets=True""
providerName="System.Data.EntityClient" />
Any help would really be very much appreciated!
Thanks
© Stack Overflow or respective owner