473,385 Members | 1,615 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

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_BasicAccess,
aspnet_Roles_FullAccess, and aspnet_Roles_ReportingAccess,

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

<connectionStrings>
<add name="appname" connectionString="Server=serverName;Integrated
Security=True;Database=appName" providerName="System.Data.SqlClient"/>
<add name="SqlRoleManagerConnection" connectionString="Data
Source=serverName;Integrated Security=True;Database=aspnetdb"
providerName="System.Data.SqlClient" />
</connectionStrings>

and

<roleManager enabled="true" defaultProvider="SqlRoleManager">
<providers>
<add name="SqlRoleManager"
type="System.Web.Security.SqlRoleProvider"
connectionStringName="SqlRoleManagerConnection"
applicationName="appName" />
</providers>
</roleManager>

Any suggestions would be greatly appreciated.

Oct 25 '07 #1
0 1499

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

Similar topics

2
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...
2
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...
1
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...
2
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...
16
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...
0
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....
0
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,...
8
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...
3
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...
1
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...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
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,...
0
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...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

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.