Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Asp.net website administration tool security tab not working

Posted on 2007-04-05
12
Medium Priority
?
351 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Use Filtering Commands to Process Files in Linux

Learn how to manipulate data with the help of various filtering commands such as `cat`, `fmt`, `pr`, and others in Linux.

 
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 2000 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

705 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