Web site Administration Tool not detecting Sql DataSource

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.
LVL 8
rpkhareAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

HeoQueCommented:
override LocalSqlServer connectionString in web.config
like
<connectionString>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionstring="your connection string" />
</connectionString>
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rpkhareAuthor Commented:
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
HeoQueCommented:
please post your connectionstring
0
rpkhareAuthor Commented:
Ok, I traced the problem. I modified the machine.config file also according to the way you suggested and it worked. Thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.