Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 570
  • Last Modified:

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.
0
rpkhare
Asked:
rpkhare
  • 2
  • 2
1 Solution
 
HeoQueCommented:
override LocalSqlServer connectionString in web.config
like
<connectionString>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionstring="your connection string" />
</connectionString>
0
 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now