VS2008 using SQL2k as membership provider?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have spent half day on this issue already, do not know what's wrong.
Please help.

I am trying to use SQL2k instead SQM2k5 express as my membership
provider.

but when I try to config it using asp.net configuration tool, I got
the following error:

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: 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).



The error message sounds strange, why they use named pipe to connect?
Also, How VS2008 know its sql2k or sql2k5 since they use the same
System. Data.SqlClient??

----------------------

My config file looks like

<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=.
\SQLExpress;Integrated Security=True;User
Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf"
providerName="System.Data.SqlClient"/>
<add name="MSSql2k" connectionString="Data
Source=local;database=mydb;uid=**;pwd=**;"
providerName="System.Data.SqlClient"/>
</connectionStrings>



<membership defaultProvider="MySqlMembershipProvider">
<providers>
<add connectionStringName="MSSql2k"
enablePasswordRetrieval="false"
enablePasswordReset="true" requiresQuestionAndAnswer="true"
applicationName="MyAppl" requiresUniqueEmail="true"
passwordFormat="Hashed"
maxInvalidPasswordAttempts="6" minRequiredPasswordLength="2"
minRequiredNonalphanumericCharacters="0"
passwordAttemptWindow="10"
passwordStrengthRegularExpression=""
name="MySqlMembershipProvider"
type="System.Web.Security.SqlMembershipProvider" />
</providers>
</membership>

I used aspnet_sqlreg.exe to succesfully register my sql2k database,
and in VS2008 server explorer I can see all the tables views and SPs.

If I change to use LocalSqlServer, then it works fine....

Thanks in advance

-rockdale
.

Relevant Pages

  • RE: web parts and a database
    ... service's provider can not correctly establish ... connection to the underlying database. ... services(include membership, rolemanager, profile, personalization ...) ... Are you creating and developing the web project through HTTP/IIS server ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: cant send email
    ... It means you were trying to send from a connection other than Cox. ... the provider of the SMTP server must match the ... Ask your home ISP if they have a port other than '25' for SMTP. ... Substitute the SMTP server belonging to your away-from-home connection. ...
    (microsoft.public.windows.vista.mail)
  • Re: VS2008 using SQL2k as membership provider?
    ... occurred while establishing a connection to the server. ... (provider: Named Pipes Provider, ... My config file looks like ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: web parts and a database
    ... such problem is likely due to the webpart ... service's provider can not correctly establish ... connection to the underlying database. ... Are you creating and developing the web project through HTTP/IIS server ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot connect to an MSAS 2000 Server
    ... What happens is that if the 9.0 provider fails, it will try to do COM ... > I am trying to use ADOMD.NET v9.0 to connect to an MSAS 2000 Server. ... > Microsoft.AnalysisServices.AdomdClient.AdomdConnection Connection = new ... > endReceivalIfException, Boolean readSession, Boolean ...
    (microsoft.public.sqlserver.olap)