Solved

Asp.net website administration tool security tab not working

Posted on 2007-04-05
12
339 Views
Last Modified: 2013-11-26
I have VS 2005 professional edition and sql server 2005 enterprise edition installed to my pc. when I click on asp.net website administration tool and security tab, I get this 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: Unable to connect to SQL Server database.

What do I need to do?
0
Comment
Question by:jaws1021
  • 7
  • 4
12 Comments
 
LVL 37

Expert Comment

by:samtran0331
ID: 18857247
0
 

Author Comment

by:jaws1021
ID: 18868802
Thank you for the link, it solved my problem, but I don't know how putting this code make that much difference? And when I run the application still put another connectionstring automatically but didn't effect anything.

<configuration>
 <connectionStrings>
<remove name=”LocalSqlServer”/>
  <add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=appservicesdb;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
</configuration>

0
 

Author Comment

by:jaws1021
ID: 18868806
Also, why it is showing asp.net configuration setting? We don't change anything on that...
0
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

 
LVL 37

Expert Comment

by:samtran0331
ID: 18875644
...you're trying to use "full" sql2005 right?
without that section in your web.config, the application tries to use the default db and location, which would be a sql express db and located in your app_data folder

>>why it is showing asp.net configuration setting
where?
0
 

Expert Comment

by:hpolat
ID: 18876349
Thank you for your explaination, also do we need to leave code put there automatically or should delete it?
Right before the code, it is showing asp.net configuration setting dialog box, I was wondering why it show that?
0
 

Author Comment

by:jaws1021
ID: 18876453
Sorry, if question above is stupid for you, we are newbie on .net and sql 2005 just trying to learn it.
0
 
LVL 37

Expert Comment

by:samtran0331
ID: 18877022
don't be sorry! we all start somewhere!

>>Thank you for your explaination, also do we need to leave code put there automatically or should delete it?
--You need to leave that section in your web.config just like the tutorial or else without it, your application will look for the default sql express database (which I assume you're not using)

>>Right before the code, it is showing asp.net configuration setting dialog box, I was wondering why it show that?
--I'm still unsure where you see a dialog box
0
 

Author Comment

by:jaws1021
ID: 18878460
thank you for being patient with us. You know the blog link you gave above when I click that and follow thru scroll down right above this code , has Asp.Net Configuration Settings Box there, we didn't understand why it is shown there even though doesn't say to do something on it? Is that made more sense now?

<configuration>
 <connectionStrings>
<remove name=”LocalSqlServer”/>
  <add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=appservicesdb;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
</configuration>
0
 

Author Comment

by:jaws1021
ID: 18878468
O also you are not using sql server express
0
 

Author Comment

by:jaws1021
ID: 18878476
I am sorry. I meant above we are not using sql server express :)
0
 
LVL 37

Accepted Solution

by:
samtran0331 earned 500 total points
ID: 18878533
i see.

In the article, the author is just showing you that there is another way to edit the web.config.
Either you can do it manually by putting that chunk of code in your web.config.

or you can use IIS in which case, you will see that Asp.Net Configuration Settings Box .
if you go to IIS and go to the properties of your application and then click on the asp.net tab and then click the "Edit Configuration" button, you will see that dialog box and from there, you can edit almost all the settings of the web.config file without actually opening the web.config file in a text editor.

so it's in the article only because the author wanted to show you that editing the web.config can be done through IIS (in previous versions of .Net, this was not true)

And because you are *not* using SQL Express and the default database and settings, that is exactly why you have to have:
<connectionStrings>
<remove name=”LocalSqlServer”/>
  <add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=appservicesdb;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>


that section in the web.config says:
"remove the default settings and use my settings"

0
 

Author Comment

by:jaws1021
ID: 18879922
Thank you! you were a good help!
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
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 video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

821 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