Ad:

ASP.NET Discussion Thread
Unsolved
Views: 5379

Aug 19th, 2006

Problem with Provider Management in ASP.NET 2.0

Expand Post »

Hi,

I am developing this app using ASP.NET 2.0, SQL Server 2005 express and VS 2005 express edition. All I am trying to do is use Login Web controls provided in ASP.NET 2.0 for my user login pages. When I go to ASP.NET configuration and click on Security tab I get following error

Quote ...

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.

and when I try "Choose Data Source" I get error

Quote ...

Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.

I've ran aspnet_regsql wizard and it has created role and membership tables in my database. I can connect to the database from the other pages of the application. Here is my web.config

ASP.NET Syntax (Toggle Plain Text)
<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
	<appSettings>
  <add key="CompanyName" value="Kendall Park Learning Center" />
 </appSettings>
	<connectionStrings>
  <add name="KPLC_OneSourceConnectionString1" connectionString="Data Source=TEXPERT002;Initial Catalog=KPLC_OneSource;Integrated Security=True"
   providerName="System.Data.SqlClient" />
 </connectionStrings>
	<system.web>
		  <compilation debug="true" strict="false" explicit="true"/>
		<pages>
			<namespaces>
				<clear/>
				<add namespace="System"/>
				<add namespace="System.Collections"/>
				<add namespace="System.Collections.Specialized"/>
				<add namespace="System.Configuration"/>
				<add namespace="System.Text"/>
				<add namespace="System.Text.RegularExpressions"/>
				<add namespace="System.Web"/>
				<add namespace="System.Web.Caching"/>
				<add namespace="System.Web.SessionState"/>
				<add namespace="System.Web.Security"/>
				<add namespace="System.Web.Profile"/>
				<add namespace="System.Web.UI"/>
				<add namespace="System.Web.UI.WebControls"/>
				<add namespace="System.Web.UI.WebControls.WebParts"/>
				<add namespace="System.Web.UI.HtmlControls"/>
			</namespaces>
		</pages>
				<authentication mode="Windows"/>
			</system.web>
</configuration>
<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
	<appSettings>
  <add key="CompanyName" value="Kendall Park Learning Center" />
 </appSettings>
	<connectionStrings>
  <add name="KPLC_OneSourceConnectionString1" connectionString="Data Source=TEXPERT002;Initial Catalog=KPLC_OneSource;Integrated Security=True"
   providerName="System.Data.SqlClient" />
 </connectionStrings>
	<system.web>
		  <compilation debug="true" strict="false" explicit="true"/>
		<pages>
			<namespaces>
				<clear/>
				<add namespace="System"/>
				<add namespace="System.Collections"/>
				<add namespace="System.Collections.Specialized"/>
				<add namespace="System.Configuration"/>
				<add namespace="System.Text"/>
				<add namespace="System.Text.RegularExpressions"/>
				<add namespace="System.Web"/>
				<add namespace="System.Web.Caching"/>
				<add namespace="System.Web.SessionState"/>
				<add namespace="System.Web.Security"/>
				<add namespace="System.Web.Profile"/>
				<add namespace="System.Web.UI"/>
				<add namespace="System.Web.UI.WebControls"/>
				<add namespace="System.Web.UI.WebControls.WebParts"/>
				<add namespace="System.Web.UI.HtmlControls"/>
			</namespaces>
		</pages>
				<authentication mode="Windows"/>
			</system.web>
</configuration>

Has anyone used login controls with SQL Server 2005 express ? can you please tell me what am I doing wrong ?

thanks in advance.

Tejoo.

Similar Threads

Updated : Simple ASP.Net Login Page in ASP.NET
ASP.NET - session objects Problem in ASP.NET
Impersonation in ASP.NET in ASP.NET
Asp.net-Database Insert problem in ASP.NET

Texpert

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

14 posts
since Jan 2006

Permalink

Apr 23rd, 2008

Re: Problem with Provider Management in ASP.NET 2.0

Simply Reinstall your windows XP or What ever you have.........

Jack12

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Apr 2008

Permalink

Apr 23rd, 2008

Re: Problem with Provider Management in ASP.NET 2.0

Hi Texpert I would advise you to ignore Jack12's response there, not very good advice. I have had this issue before myself but running the aspnet_regsql resolved it. I might recommend that you retry the utility and get back to us? hope this helps!

majestic0110

Reputation Points: 256

Solved Threads: 72

Nearly a Posting Virtuoso

Offline

1,306 posts
since Oct 2007

Permalink

Apr 23rd, 2008

Re: Problem with Provider Management in ASP.NET 2.0

make sure your web.config has forms authentication

Quote ...

</namespaces>
</pages>
<authentication mode="Forms"/>
</system.web>

majestic0110

Reputation Points: 256

Solved Threads: 72

Nearly a Posting Virtuoso

Offline

1,306 posts
since Oct 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: graphs / charts

Next Thread in ASP.NET Forum Timeline: Hidden characters (linebreaks) in string?

DaniWeb Message

Cancel Changes

User Name
Password