ASP.Net not showing security tab

Question

4.00/5 (2 votes)

See more:

Hello All,

I want to use ASP.Net Website administration tool for using membership in my web site, for this when i am clicking on security tab , it is showing following error,

SQL

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.

so , i am unable to use website adminitartion tool, suggest me solution to resolve this error..

Posted 10-Apr-12 21:13pm

abhishekagrwl25

Add a Solution

2 solutions

Solution 2

There was a problem with connection string.

Posted 10-Apr-12 22:18pm

abhishekagrwl25

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ed Nutting · Accepted Answer · 2012-04-10T21:45:00

Hi there,

Reading that final bit of the error message:
"Unable to connect to SQL Server database."
Suggests that the connection string you are using to try and connect to your database is probably incorrect or you have not put in the necessary security credentials (i.e. username & password). Therefore, I suggest you check your connection string. If you have SQL Management Studio or even Visual Studio's database management panel (not sure of its exact name - something like "Servers" or "Databases"), connect to your database through one of those then copy the connection string. In SQL Management Studio you will have to go hunting the in the connection properties, in Visual Studio you should be able to right click on the connection (in the servers panel) and then get the connection string quite easily. Then use this as your connection string in your configuration.

However, there may be other security or connection issues. For instance if you connect from your development machine you may have internal access to your database but if your site is running on a web server somewhere externally (i.e. not in your database server's local network), it may not have access. If your database is run outside of your development machine's local network this will not be an issue.

Hope this helps,
Ed