How to add database provider?

[brett]

I'd like to setup a provider to my SQL Server 2005 database but keep
getting an access denied error in IIS7. I'm using the custom option
for adding a connection string. My string looks like this:

Data Source=servername;Initial Catalog=databasename;Integrated
Security=True

It's the same string used in Visual Studio. There was already an
AspNetSqlRoleProvider to SQLServerExpress that is working. Any
suggestions why this string is denied access to the regular SQL Server?

Thanks,
Brett