I am trying to use Windows Authentication on a SQL Server 2008 Report Server that connects to a 'remote' SQL Server 2008 Enterprise server. If I store the login credentials with the datasource everything works fine. The reports limit what information can be selected based on the user's account. I need to be able to use Windows Authentication. If I set the data source to Windows authentication when I try to go to the report it prompts me for my us/pw but every time I enter this information the box pops up again. Both servers are on the same subnet. If I put a copy of the database on the report server it will run without issue.
Environment: Data Server SQL 2008 Enterprise SP1 Windows 2008 Enterprise Physical Server
Report Server SQL Server 2008 Enterprise SP1 Windows 2008 Enterprise VMware ESX 3.5 Virtual
Any Assistance would be greatly appreciated