Web site Administration Tool not detecting Sql DataSource
Posted on 2008-10-17
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