•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP.NET section within the Web Development category of DaniWeb, a massive community of 375,172 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,109 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting
Views: 2834 | Replies: 3
![]() |
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
and when I try "Choose Data Source" I get error
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
Has anyone used login controls with SQL Server 2005 express ? can you please tell me what am I doing wrong ?
thanks in advance.
Tejoo.
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
•
•
•
•
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
•
•
•
•
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
<?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.
•
•
Join Date: Oct 2007
Location: Bristol, UK
Posts: 1,122
Reputation:
Rep Power: 3
Solved Threads: 47
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!
If you have a quality, be proud of it and let it define you. Add it to the world!
If you got your answer, please mark the thread as Solved. It saves time when people are looking to contribute threads or for answers!
If you got your answer, please mark the thread as Solved. It saves time when people are looking to contribute threads or for answers!
•
•
Join Date: Oct 2007
Location: Bristol, UK
Posts: 1,122
Reputation:
Rep Power: 3
Solved Threads: 47
make sure your web.config has forms authentication
•
•
•
•
</namespaces>
</pages>
<authentication mode="Forms"/>
</system.web>
If you have a quality, be proud of it and let it define you. Add it to the world!
If you got your answer, please mark the thread as Solved. It saves time when people are looking to contribute threads or for answers!
If you got your answer, please mark the thread as Solved. It saves time when people are looking to contribute threads or for answers!
![]() |
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb ASP.NET Marketplace
•
•
•
•
.net .net framework 3.0 access accounting software selection ajax apple asp business software code combo community cracked custom data development digital dom drm dropdownlist erp systems evaluations feed gates hack ipod management melinda microsoft module msdn net news project management reader registration reuse rights skin software software selection sql technology evaluation theme vista weather web windows workflow xml xoap yahoo!
- Updated : Simple ASP.Net Login Page (ASP.NET)
- Impersonation in ASP.NET (ASP.NET)
- Asp.net-Database Insert problem (ASP.NET)
- Team Lead C#, ASP.NET, VB.NET, Web Services, SQL - Los Angeles, CA (Web Development Job Offers)
- ASP.NET - session objects Problem (ASP.NET)
- Porting asp to asp.NET (with fileup) (ASP.NET)
- ASP.NET problem (ASP.NET)
Other Threads in the ASP.NET Forum
- Previous Thread: graphs / charts
- Next Thread: Hidden characters (linebreaks) in string?



Linear Mode