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.
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.