Solved

Asp.net website administration tool security tab not working

Posted on 2007-04-05
12
336 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
Comment Utility
0
 

Author Comment

by:jaws1021
Comment Utility
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
Comment Utility
Also, why it is showing asp.net configuration setting? We don't change anything on that...
0
 
LVL 37

Expert Comment

by:samtran0331
Comment Utility
...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
Comment Utility
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
Comment Utility
Sorry, if question above is stupid for you, we are newbie on .net and sql 2005 just trying to learn it.
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 37

Expert Comment

by:samtran0331
Comment Utility
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
Comment Utility
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
Comment Utility
O also you are not using sql server express
0
 

Author Comment

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

Accepted Solution

by:
samtran0331 earned 500 total points
Comment Utility
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
Comment Utility
Thank you! you were a good help!
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
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 demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

744 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now