First time using security in ASP.NET

Question

I have to do a homework where i have to implement user registration and login in ASP.NET.(Form-Based)

I am reading my book and it says that the first thing I should do is use aspnet_regsql.exe to configure, but when I went to pick the the database I get this error: enter image description here

I keep trying to fix this problem, but I dont know how. At this link I found a note that says:

The database elements that are installed in the feature database will always be owned by the SQL Server database owner account (dbo). In order to install the feature database, a SQL Server login must be permitted to the db_ddladmin and dd_securityadmin roles for the SQL Server database. However, you do not need to be a system administrator for the SQL Server in order to install the feature database.

I don't understand what I am missing.

-What should I do?

-Where can I find db_ddladmin and dd_securityadmin?

UPDATE

As the above step looks like is not able to find the database, i thought i better create it manually. so this is what i do Step 1:

enter image description here

Step 2: enter image description here

Why is this happening?

I just need to prepare my work enviroment to use form-based authentification. I cannot do my homework if i cant configure my working enviroment first. Can someone give me a hand to fix this? Does it have to do something with permisions or other?

First of all make sure that sql server is installed, and it has been started. — driushkin
– driushkin, Commented May 7, 2011 at 15:09

Chad · Accepted Answer · 2011-05-07 14:55:58Z

3

You are getting the error because you're trying to connect to a server that doesn't exist. If you are using sql server express, your server name would be creator-PC/SQLEXPRESS.

I believe I remember having to do this too. http://support.microsoft.com/kb/914277. Follow the instructions under "Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition"

edited May 7, 2011 at 14:55

answered May 7, 2011 at 13:55

Chad

1,4041 gold badge19 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Chad Over a year ago

@sfrj - See my update. I think I remember having to allow remote connections in my sql express.

Wade73 · Accepted Answer · 2011-05-07 12:56:31Z

1

First thing you need to do is try to browse to the database itself. I use the sql server management studio to do this. If you are able to connect, then you will need to edit the user permissions, otherwise you probably have an issue with the sql server setup.

answered May 7, 2011 at 12:56

Wade73

4,5193 gold badges35 silver badges49 bronze badges

2 Comments

javing Over a year ago

Do you know where can i find some step by step tutorial on how to do that?

javing Over a year ago

Sorry but i am confused. I did not create any data base at all. The text on my question is the first step i did. How can i create a db? I thought that it would be created automatically.

Devjosh · Accepted Answer · 2012-06-09 09:02:31Z

1

if you tried connecting using management studio to your DB server and if you are able to connect but you are not able to connect through asp.net application then there is a probability that the database does not have any permission for aspnet user so first create a new user in sql server for aspnet user and try again to connect using the wizard.

Generally the error comes when you not have your server started or installed on machine. Also Make sure the server instance is running and you place the right name of the server instance. if your sql server is configured to use sql server authentication then provide proper parameters i hope this all will help and get you out of it

edited Jun 9, 2012 at 9:02

answered May 7, 2011 at 13:08

Devjosh

6,4824 gold badges41 silver badges61 bronze badges

3 Comments

javing Over a year ago

Wait a second. Should i use VS2005 to create a database first? i thought that wizard would create it for me.

Devjosh Over a year ago

do you know the name of your database server instance if you are using sql server express edition then it is by default machinename\SQLEXPRESS try this to put in the database server field

Wade73 Over a year ago

+1 to DevJosh for explaining my point much better. You need SQL Server installed and working first, before VS will do anything.

Collectives™ on Stack Overflow

First time using security in ASP.NET

3 Answers 3

1 Comment

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related