There is a problem with your selected data store

[Guest]

Hi,
I am using SQLServer 2005.I have created a simple website and i am trying
to membership to this.so when i click on 'Security' tab of the "WAT" tool its
showing the following message.

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: Unable to connect
to SQL Server database.

Is there anyway out of this?

Pls pls pull me out of this.

Regards,
SSREDDI.

 

[sravan_reddy001]

I had faced the same prob. but am not able to do that

this link helped me a little but. may be this may help u better.

http://www.c-sharpcorner.com/Upload...ervice08082005004450AM/MembershipService.aspx

 

[Guest]

Hi Sravan,
Thank you for the information.I already tried this.I know this
works.My concern is that i dont want to use aspnet_regsql.exe.Anyway thanks
for the info.

 

[sravan_reddy001]

u try editing the web.config file...

there is lot more to do with that..
hav u created ur own database for your application. If so you have to
give the connection string for that database.

This is my webconfig file. see this and try. I tried for about 3 days
to that.

if u didn't include the roleManager then we can't create the roles and
it states and error message saying "website not configured to enable
roles"


<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/
v2.0">
<appSettings/>
<connectionStrings>
<add name="MySqlProviderConnection"
connectionString="server=localhost;integrated security =
true;database=aspnetdb" />
</connectionStrings>
<system.web>
<!--
Set compilation debug="true" to insert debugging
symbols into the compiled page. Because this
affects performance, set this value to true only
during development.
-->
<compilation debug="true"/>
<authorization>
<deny users="?"/>
</authorization>
<membership defaultProvider="MySqlMembershipProvider">
<providers>
<add connectionStringName="MySqlProviderConnection"
enablePasswordRetrieval="false"
enablePasswordReset="true" requiresQuestionAndAnswer="true"
applicationName="/" requiresUniqueEmail="true"
maxInvalidPasswordAttempts="5"
passwordAttemptWindow="10" name="MySqlMembershipProvider"
type="System.Web.Security.SqlMembershipProvider, System.Web,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
minRequiredPasswordLength="6"
minRequiredNonalphanumericCharacters="0" />
</providers>
</membership>

<roleManager enabled="true" defaultProvider="SqlRoleProvider">
<providers>
<clear />
<add applicationName="MyAppName"
connectionStringName="MySqlProviderConnection"
name="SqlRoleProvider"
type="System.Web.Security.SqlRoleProvider" />
</providers>
</roleManager>