My DBA gave me Read Only access with integrated security to one of our SQL Server databases while I have been developing a few reports using Crystal Reports and Visual Basic 2005. We use Windows XP SP2.

The reports have been working on my workstation, and I created a deployment project to test it out on another workstation.

When I went to another workstation, logged in as myself, installed, the application, and ran it, I got a SQL Server Logon screen that I couldn't get past.

I thought that my access rights and integrated security was all that I needed to have CR access the database on another workstation.

I will need other users to use this reports application, so what should I, or my DBA, be doing to make sure that all my users can use this program?

Thanks.