Solved

Web site Administration Tool not detecting Sql DataSource

Posted on 2008-10-17
4
538 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

In .NET 2.0, Microsoft introduced the Web Site.  This was the default way to create a web Project in Visual Studio 2005.  In Visual Studio 2008, the Web Application has been restored as the default web Project in Visual Studio/.NET 3.x The Web Si…
User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

806 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