Solved

Asp.net website administration tool security tab not working

Posted on 2007-04-05
12
338 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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
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!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

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.…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

831 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