Solved

Web site Administration Tool not detecting Sql DataSource

Posted on 2008-10-17
4
546 Views
Last Modified: 2012-06-22
I am using Visual Web Developer 2008 Express SP1.

I added a Login Control on my Web Form. While trying to configure the membership, I selected "ASP.NET
configuration" from the Website menu on my IDE to open Web Site administration tool. When I click the
"Security" tab, I get an error "could not connect to SQL Data Provider".

Actually it is not able to detect my SQL Server 2005 Express Edition instance name. This might be due to that while installing SQL Server 2005 Express Edition, I changed the instance name. I am using instance name "SQLXpress" and not "SqlExpress".

I tried to set the configuration from the command line by using 'aspnet_regsql'. Even after successfully
configuring from the command line, it is simply not detecting the Data Store when returned to Web site
Administration Tool.
0
Comment
Question by:rpkhare
  • 2
  • 2
4 Comments
 
LVL 9

Accepted Solution

by:
HeoQue earned 500 total points
ID: 22739652
override LocalSqlServer connectionString in web.config
like
<connectionString>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionstring="your connection string" />
</connectionString>
0
 
LVL 8

Author Comment

by:rpkhare
ID: 22740729
Now it is 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: The connection name 'LocalSqlServer' was not found in the applications configuration or the connection string is empty. (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Config\machine.config line 145)
====================================
0
 
LVL 9

Expert Comment

by:HeoQue
ID: 22740871
please post your connectionstring
0
 
LVL 8

Author Comment

by:rpkhare
ID: 22740877
Ok, I traced the problem. I modified the machine.config file also according to the way you suggested and it worked. Thanks.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today is the age of broadband.  More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question