 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / ASP.NET / General / August 2007Web Site Administration Tool: Unable to Connect to Database
Hi, <I posted this on the microsoft.public.dotnet.framework.aspnet.security newsgroup but before I got a reply this newsgroup has become unavailable!! So I'm posting it here again. Sorry for the inconveneice.> I tried using the ASP.Net Web Site Administration Tool to setup security for a web site I'm creating using VS 2005 C#. When clicking on the Security tab, I get the error message: "Unable to connect to SQL Server database". I then created the ASPNETDB database with the ASPNET_REGSQL utility in the Windows\Microsoft.net\Framework\v2.0.50727 and can now see the database in SQL Server Management Studio (I'm running SQL Server 2005). I tried the Web Site Administration Tool and got the same error. It is interesting that the tool does not ask for the server name or the database. Is it getting this info from some setting setup by the ASPNET_REGSQL utility when creating the ASPNETDB database? I have no problems connecting from my application or VS proper to the database, only from the Web Site Administration Tool. What am I missing? Thanks for any pointers. Another quick question: I couldn't get the ASPNET_REGSQL tool to build the ASPNETDB database in my App_Data folder so I can separate out the different web site databases. How can I get it to do that? And I suspect that I would need to use a different name for the database since no two databases can have the same name on the same server in SQL Server. If so, what would I need to change in order to reference this changed database name? Thanks > Hi, > [quoted text clipped - 23 lines] > > Thanks for any pointers. Another quick question: I couldn't get the ASPNET_REGSQL tool to build the ASPNETDB database in my App_Data folder so I can separate out the different web site databases. How can I get it to do that? And I suspect that I would need to use a different name for the database since no two databases can have the same name on the same server in SQL Server. If so, what would I need to change in order to reference this changed database name? Thanks > Hi, > [quoted text clipped - 23 lines] > > Thanks for any pointers. re: !> It is interesting that the tool does not ask for the server name or the database. By default, the connection is made to a SQL Server Express database. You need to have SQL Server Express 2005 for the default to work. If you want to setup a SQL Server 2000 or a SQL Server 2005 database, see : http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx Juan T. Llibre, asp.net MVP asp.net faq : http://asp.net.do/faq/ foros de asp.net, en español : http://asp.net.do/foros/ ====================================== > Hi, > [quoted text clipped - 16 lines] > > Thanks for any pointers.
Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.