By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,564 Members | 810 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,564 IT Pros & Developers. It's quick & easy.

ASP.NET Web Site Administration Tool

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.