Problem in the login?

[Jihad]

I have a problem on making user login, because I am not able to set up the roles and users in my Asp.net configurations. When I choose security I get this message "Unable to connect to SQL Server database. " and when I try to choose a provider and select test link I get "Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider. "
I think the problem is that my sqlserver does not allow remote connections, and I don't know how to setup this option.
Any help?
Thanks in advance

[majestic0110]

you need to run the aspnet_regsql exe. hope that helps, I will try to locate the directory URL for you hold on....

[majestic0110]

I've had this issue myself, most irritating lol. make sure your web.config has forms authentication instead of windows....standby for that directory trying to find it lol

[majestic0110]

the aspnet_regsql utility can be invoked via a command line as well:

http://www.daniweb.com/code/printsnippet835.html

[majestic0110]

Aha! gotcha here is a good site for this utility! hope this helps you!

http://www.shiningstar.net/ASPNet_Articles/SqlMembershipProvider.aspx

as you can see, the directory for the User Interface (i.e. non command line) utility is shown at the top of that page.

[Jihad]

Sorry man it didn't work. Thanks for your effort.

[majestic0110]

are you still getting the same error message ?

[sierrasoft]

See these Articles in MSDN:
role-based security, walkthroughs

Walkthrough: Creating a Web Site with Membership and User Login (Visual Studio)

This should help.

[noldbcat]

Have you tried to connect on your Sql database using ODBC. this is just to test if youre capable to connect on your server using SQL username password.

In installing the SQL Server there are two types of login that you must considered, the Windows authentication and the Mixed Mode.

If you choose Windows Authentication only, you have no chance to connect on your SQL server using your UserName and password that you created on your SQL Server.

NOTE: Windows Authentication is set as default when you install SQL server.

so if you cannot connect on your server using your ODBC my advise is to uninstall your SQL server and reinstall it, set the security on the mixed mode.

you can get any further information on this site.
http://vyaskn.tripod.com/sql_server_security_best_practices.htm

Hopes it can help..