ASP.NET Web Site Administration Tool

C

Carter

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,756
Messages
2,569,533
Members
45,007
Latest member
OrderFitnessKetoCapsules

Latest Threads

Top