•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP.NET section within the Web Development category of DaniWeb, a massive community of 402,077 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,538 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting
Views: 445 | Replies: 8
 |
•
•
Join Date: Nov 2007
Posts: 21
Reputation: 
Rep Power: 1
Solved Threads: 0
Newbie Poster
Problem in the login? 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
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
•
•
Join Date: Oct 2007
Location: Bristol, UK
Posts: 1,124
Reputation:
Rep Power: 3
Solved Threads: 47
you need to run the aspnet_regsql exe. hope that helps, I will try to locate the directory URL for you hold on....
If you have a quality, be proud of it and let it define you. Add it to the world!
If you got your answer, please mark the thread as Solved. It saves time when people are looking to contribute threads or for answers!
If you got your answer, please mark the thread as Solved. It saves time when people are looking to contribute threads or for answers!
•
•
Join Date: Oct 2007
Location: Bristol, UK
Posts: 1,124
Reputation:
Rep Power: 3
Solved Threads: 47
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
If you have a quality, be proud of it and let it define you. Add it to the world!
If you got your answer, please mark the thread as Solved. It saves time when people are looking to contribute threads or for answers!
If you got your answer, please mark the thread as Solved. It saves time when people are looking to contribute threads or for answers!
•
•
Join Date: Oct 2007
Location: Bristol, UK
Posts: 1,124
Reputation:
Rep Power: 3
Solved Threads: 47
the aspnet_regsql utility can be invoked via a command line as well:
If you have a quality, be proud of it and let it define you. Add it to the world!
If you got your answer, please mark the thread as Solved. It saves time when people are looking to contribute threads or for answers!
If you got your answer, please mark the thread as Solved. It saves time when people are looking to contribute threads or for answers!
•
•
Join Date: Oct 2007
Location: Bristol, UK
Posts: 1,124
Reputation:
Rep Power: 3
Solved Threads: 47
Aha! gotcha here is a good site for this utility! hope this helps you!
as you can see, the directory for the User Interface (i.e. non command line) utility is shown at the top of that page.
as you can see, the directory for the User Interface (i.e. non command line) utility is shown at the top of that page.
If you have a quality, be proud of it and let it define you. Add it to the world!
If you got your answer, please mark the thread as Solved. It saves time when people are looking to contribute threads or for answers!
If you got your answer, please mark the thread as Solved. It saves time when people are looking to contribute threads or for answers!
•
•
Join Date: Nov 2007
Posts: 21
Reputation:
Rep Power: 1
Solved Threads: 0
Newbie Poster
Sorry man it didn't work. Thanks for your effort.
•
•
Join Date: Oct 2007
Location: Bristol, UK
Posts: 1,124
Reputation:
Rep Power: 3
Solved Threads: 47
are you still getting the same error message ?
If you have a quality, be proud of it and let it define you. Add it to the world!
If you got your answer, please mark the thread as Solved. It saves time when people are looking to contribute threads or for answers!
If you got your answer, please mark the thread as Solved. It saves time when people are looking to contribute threads or for answers!
•
•
Join Date: Nov 2006
Location: Nasik-India
Posts: 21
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
See these Articles in MSDN:
role-based security, walkthroughs
Walkthrough: Creating a Web Site with Membership and User Login (Visual Studio)
This should help.
role-based security, walkthroughs
Walkthrough: Creating a Web Site with Membership and User Login (Visual Studio)
This should help.
•
•
Join Date: Oct 2006
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
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_..._practices.htm
Hopes it can help..
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_..._practices.htm
Hopes it can help..
|
•
•
•
•
•
•
•
•
DaniWeb ASP.NET Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- Apple Power Book G4 Keyboard Problem (Apple Hardware)
- database driven login page (ASP.NET)
- Word Press 2.2 users... mulitple installation of word press blog and login once... (PHP)
- login code problem (VB.NET)
- can't login (Windows NT / 2000 / XP / 2003)
- problem with login page (C#)
- Cannot Login Yahoo (Community Introductions)
- login check (ASP)
- Login Problems with Hotmail (Web Browsers)
- Problem with login Safe Guard Easy v3.20 (Troubleshooting Dead Machines)
Other Threads in the ASP.NET Forum
- Previous Thread: how to pass array from one page to another page
- Next Thread: Writing each Row of a Dataset into XML files
