connecting using a trusted connection

Hello,

I appologize if this is in the wrong spot, but it seemed like the appropriate place.

We have IIS installed on one box and SQL on another. We use a trusted connection to connect.

When we try an connect to our DB, we don't get an error, the page just refreshes. From what i have gathered, it looks like we are not being authenticated. We have the ASPNET domain user on both boxes and its configured with the correct permissions, but we still can't connect.

Do i need to set up or give permissions to another account i dont know about, or is there some file that needs access?

Have you checked SQL logs, or IIS logs? Event logs? If it's a securtiy issue it should be logged. Also make sure you really are using the ASP.NET account when you access the box, it could be an authenticated user's credentials that are passed. And keep in mind that by defualt the ASp.NET process account is not a domain account, it's local.

Jeff

|||There are two permissions in SQL Server, the server permissions in the management section of Enterprise Manager or Management Studio and the database permissions are in the database under permissions and in SQL Server 2005 under security in the database. You may have created one and not the other. Hope this helps.