ASPNETDB Problem - Unable to connect to SQL Server database

From: "ZZ_Scarab" <w_b1o2c3t4o5r6@xxxxxxxxxxx>
Date: Thu, 16 Aug 2007 17:57:05 -0700

Hi,

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.

.

Follow-Ups:
- Re: ASPNETDB Problem - Unable to connect to SQL Server database
  - From: ZZ_Scarab

Prev by Date: Re: Session data loss during user logged session
Next by Date: Re: Problem deploying forms authorization
Previous by thread: Re: Session data loss during user logged session
Next by thread: Re: ASPNETDB Problem - Unable to connect to SQL Server database
Index(es):
- Date
- Thread

Relevant Pages

Securing a web DB
... We are putting up a ASP.NET based web site using SQL Server database. ... Users of the web site get to see confidential data. ...
(comp.security.misc)
Securing a web DB
... We are putting up a ASP.NET based web site using SQL Server database. ... Users of the web site get to see confidential data. ...
(microsoft.public.sqlserver.security)
Re: Securing a web DB
... >We are putting up a ASP.NET based web site using SQL Server database. ... >name, uid, password) from an XML file and establish connection to the DB. ...
(microsoft.public.sqlserver.security)
Re: No db access after publishing web site
... Is the SQL Server Express database in the new application's App_Data folder? ... But after I published the web site in a file system ...
(microsoft.public.dotnet.framework.aspnet)
ASP.NET Web Site Administration Tool
... I'm developing a Web site with VS 2005 on a machine under Windows ... When I try to access the Security tab in the Web Site Administration ... it fails with a message "Unable to connect to SQL Server ... The database aspnetdb is attached, and my user login, which is in a ...
(microsoft.public.dotnet.framework.aspnet)