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.

.



Relevant Pages

  • Re: Error trying to connect to Access Database
    ... windows admin userid and password. ... your database isn't updatable because of the permissions issue. ... Are you the administrator of the server where the ASP is running? ... I do not know what else to do, and I am trying to get a web site done. ...
    (microsoft.public.access.gettingstarted)
  • Re: Saving WSS site prior to upgrading SQL Server 2005 Express to Standard/Enterprise
    ... Your backup is from a different version of Windows SharePoint Services and ... SQL Server 2005 is available. ... The advantages of the embedded version ("Windows Internal Database") over ...
    (microsoft.public.sharepoint.windowsservices)
  • IIS / SQL Server impersonation
    ... I am attempting to implement impersonation from a windows application ... I have configured the host virtual directory in IIS to require windows ... the database permits Windows Authentication. ... When I try and open a connection to SQL Server: ...
    (microsoft.public.dotnet.security)
  • Re: User setup problem.
    ... login permissions for SQL Server. ... have access to SQL Server and the database through their ... windows group role membership which has the permissions.. ...
    (microsoft.public.sqlserver.security)
  • Permissions problem on SBS 2003 R2 for SQL Server 2005 clients
    ... involving SQL Server Express 2005 on a Windows SBS 2003 R2 network. ... I've been testing a SQL Server 2005 Express database in a multiuser ... environment using Window Small Business Server 2003 R2 with Windows XP ... On a given client computer to which I may have logged on with Windows ...
    (microsoft.public.windows.server.sbs)