Shared Memory Provider, error: 0 - No process is on the other end of the pipe

[alexelprogramador]

si os sale un error como este:

There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

simplemente debeis borrar todo lo que aparezca en esta sección del archivo web.config


en mi caso fue borrando esto:

    <connectionStrings>
      <remove name="LocalSqlServer" />
      <add name="LocalSqlServer" connectionString="data source=localhost;database=aspnetdb;Integrated Security=SSPI;" providerName="System.Data.SqlClient" />
      <add connectionString="server=localhost;database=pubs;trusted_connection=yes;" name="Pubs" providerName="System.Data.SqlClient"/>
    </connectionStrings>

y dejandolo limpio:

    <connectionStrings>

    </connectionStrings>

con eso arreglas un problemon con los inicios de sesion y el sqlserver