473,804 Members | 3,649 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

ASP.NET Web Site Administration Tool

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 database aspnetdb is attached, and my user login, which is in a
sysadmin server role, is mapped to that database, as well as the
application database.

Database roles selected are: aspnet_Roles_Ba sicAccess,
aspnet_Roles_Fu llAccess, and aspnet_Roles_Re portingAccess,

The application's web.config file has the following code:

<connectionStri ngs>
<add name="appname" connectionStrin g="Server=serve rName;Integrate d
Security=True;D atabase=appName " providerName="S ystem.Data.SqlC lient"/>
<add name="SqlRoleMa nagerConnection " connectionStrin g="Data
Source=serverNa me;Integrated Security=True;D atabase=aspnetd b"
providerName="S ystem.Data.SqlC lient" />
</connectionStrin gs>

and

<roleManager enabled="true" defaultProvider ="SqlRoleManage r">
<providers>
<add name="SqlRoleMa nager"
type="System.We b.Security.SqlR oleProvider"
connectionStrin gName="SqlRoleM anagerConnectio n"
applicationName ="appName" />
</providers>
</roleManager>

Any suggestions would be greatly appreciated.

Oct 25 '07 #1
0 1515

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
3449
by: RickatGoIn | last post by:
We are currently using the security features included with latest .NET 2.0 Framework (v2.0.50215), including the Web Site Administration Tool. The only problem we have encountered thus far is getting the Web Site Administration Tool to install and work on the IIS Server. To clarifty, we can only access the Web Site Administration Tool for our applications using our local machines (localhost). When we try to access the Web Admin Tool on...
2
6481
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 administrative user. The administrative user has permission to upload photos and create albums. To...
1
1740
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 roles and users for a website - and it seems like without that tool, I would have to do that via...
2
1697
by: John | last post by:
Hi Web site administration tool is great. How can I provide this functionality for the end user? I need the end user Admin to be able to list users and then change roles for any of the users or to be able to disable any of the users. Thanks Regards
16
15989
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 to the Web Site Administration Tool ? Thanks for your help!
0
1498
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 target of an invocation. at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object...
0
1817
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 Provider tab, I _have_ selected to use my custom providers! Also, I do not seem to have a problem...
8
2019
by: Kirk | last post by:
Hello, I am a somewhat experienced VS 2005 user who is trying to us the ASP.NET Web Site Administration Tool for the first time. I have experimented with it on my local IIS and it seems to be an excellent tool for security administration. However, I have some long term questions. Where does the W.S.A.T. store its information? In my local SQL Server 2000, I can see a database called "aspnetdb" - however none of the
3
4240
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 with the REFERENCE constraint "FK__aspnet_Me__UserI__24285DB4". The conflict occurred in database...
1
10726
by: ZZ_Scarab | last post by:
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...
0
9704
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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9569
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
10302
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10069
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9130
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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6844
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5636
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3802
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2975
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.