473,581 Members | 2,295 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Web Site Administration Tool: Unable to Connect to Database

Hi,

<I posted this on the microsoft.publi c.dotnet.framew ork.aspnet.secu rity
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\Microso ft.net\Framewor k\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 10711
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.comwro te in message news:uU******** *****@TK2MSFTNG P04.phx.gbl...
Hi,

<I posted this on the microsoft.publi c.dotnet.framew ork.aspnet.secu rity 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\Microso ft.net\Framewor k\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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
6464
by: dave | last post by:
I am trying to use the Personal Web Site Starter Kit. I am planning on showing my class how easy it is to create a website in VS 2005. Only I am finding it not to be so easy. I am following the instructions on the default.aspx page and they are as follows. Creating an Administrative User The first step you must take is to create an...
2
7769
by: Sophia | last post by:
Hello, I hope somebody can help me with this, I am getting crazy! When I click on the security tab on the WSAT page (Website/ASP.NET configuration) I get the following message: "There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused...
1
1733
by: RCS | last post by:
All, When I create a website locally, I have that little Administration tool (the little icon in the Solution Explorer - or under Website | Web Site Administration) - but when I connect to a 2.0 webhost (and the rest of the site compiles fine under 2.0) - I don't have that option. More specifically, I want this tool so I can easily setup...
16
15957
by: jblankenburg | last post by:
I am trying to deploy a simple web application to my client's production server, but it's not clear to me how MS planned on having the Security users managed without Studio. Certainly someone has run into this issue. How do you manage users (the ones you would normally manage with the Web Site Administration Tool) without Studio to get you...
7
4032
by: vamichael | last post by:
When I try to run the Website Administration Tool from my published application using http://localhost/myapp/webadmin.axd I am getting a "resource not found" error message. I can use the Admin tool from the IDE however. I noticed some people referring to a directory called c:\Inetpub\wwwroot\aspnet_webadmin\, which i do not have on my...
0
1485
by: Ian Pitt | last post by:
I am unable to add users using the Web Site Administration Tool. I can create/delete roles, but when I try to add a user I get an exception. I posted the error below: An error was encountered. Please return to the previous page and try again. The following message may help in diagnosing the problem: Exception has been thrown by the...
0
1798
by: GreggTB | last post by:
I have written two custom providers for our Oracle 9i database...a Membershp provider and a Role provider. I've been testing these over the last few days and they seem to be working well. However, when I try to use the ASP.NET 2.0 Web Site Administration Tool in VS 2005, I get an error when I click on the "Create User" link. On the tool's...
3
4221
by: =?Utf-8?B?Um9nZXIgTWFydGlu?= | last post by:
When using the Web Site Administration Tool, I get the following error when trying to delete a user in a web application I configured to use membership, roles, and profiles: "An error was encountered. Please return to the previous page and try again. The following message may help in diagnosing the problem: The DELETE statement conflicted...
0
1507
by: Carter | last post by:
I'm developing a Web site with VS 2005 on a machine under Windows Vista Home Premium. I also have SQL Server 2005 Standard Edition installed on the same machine, using Windows authentication. When I try to access the Security tab in the Web Site Administration Tool, it fails with a message "Unable to connect to SQL Server database" The...
0
7862
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
8301
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
8169
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6551
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5670
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3803
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3820
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2300
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1400
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.