I wanted to create logins for a website (I am very new to this). In Visual Studio 2010, I launched the ASP.Net Web Site Administration Tool and clicked the Security tab, but I am getting the 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: Login failed for user ''.
Do you know how I might be able to fix this?
Some further background:
I have SQL Server 2008 R2 Developer edition installed on my computer (I got rid of the SQL Server Express that came with Visual Studio). I created a blank database (myfirstlogindatabase1) that I planned to use for storing administration data. I ran the aspnet_regsql file
and selected the myfirstlogindatabase1 as the database. I assume this bit all worked fine because a bunch of tables and stored procedures had been added to the database when I looked at in SQL Server Management Studio.
In Visual Studio 2010 I altered the connection strings in the web.config file from:
laudrup
0 Points
10 Posts
Web site administration tool - "Login failed for user" on first load of Security tab
Apr 23, 2012 01:55 AM|LINK
Hi,
I wanted to create logins for a website (I am very new to this). In Visual Studio 2010, I launched the ASP.Net Web Site Administration Tool and clicked the Security tab, but I am getting the 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: Login failed for user ''.
Do you know how I might be able to fix this?
Some further background:
I have SQL Server 2008 R2 Developer edition installed on my computer (I got rid of the SQL Server Express that came with Visual Studio). I created a blank database (myfirstlogindatabase1) that I planned to use for storing administration data. I ran the aspnet_regsql file and selected the myfirstlogindatabase1 as the database. I assume this bit all worked fine because a bunch of tables and stored procedures had been added to the database when I looked at in SQL Server Management Studio.
In Visual Studio 2010 I altered the connection strings in the web.config file from:
<connectionStrings>
<add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
<add name="myfirsdatabase1ConnectionString1" connectionString="Data Source=ASSET000610;Initial Catalog=myfirsdatabase1;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
To:
<connectionStrings>
<add name="ApplicationServices" connectionString="Data Source=ASSET000610;Initial Catalog=myfirstlogindatabase1;" providerName="System.Data.SqlClient"/>
<add name="myfirsdatabase1ConnectionString1" connectionString="Data Source=ASSET000610;Initial Catalog=myfirsdatabase1;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
Note that there is another connection string for a data table I have got on the web page from another database (myfirstdatabase1), which works fine.
Any help would be gretaly appreciated. Am a bit stuck.
Cheers
nijhawan.sau...
All-Star
16398 Points
3172 Posts
Re: Web site administration tool - "Login failed for user" on first load of Security tab
Apr 23, 2012 04:51 AM|LINK
Make sure inrole provider slao you are using the same conenctionstring:
laudrup
0 Points
10 Posts
Re: Web site administration tool - "Login failed for user" on first load of Security tab
Apr 23, 2012 07:58 AM|LINK
Awesome, thanks for the advice, just needed to include Integrated Security=SSPI; in the connection string and it worked.