469,599 Members | 2,868 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,599 developers. It's quick & easy.

Web 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.
Aug 17 '07 #1
1 10437
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/archi...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/
======================================
"ZZ_Scarab" <w_************@hotmail.comwrote in message news:uU*************@TK2MSFTNGP04.phx.gbl...
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.


Aug 17 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by dave | last post: by
16 posts views Thread by jblankenburg | last post: by
reply views Thread by Ian Pitt | last post: by
reply views Thread by GreggTB | last post: by
3 posts views Thread by =?Utf-8?B?Um9nZXIgTWFydGlu?= | last post: by
reply views Thread by Carter | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.