Crystal Reports and SQL Server access

[TonyScarpelli]

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 the other 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.


Tony Scarpelli
Clinical Engineering Dept.
Maine Medical Center
Portland, Maine 04102

 

[IanWaterman]

What is your connection method.

If its ODBC you will need to create the ODBC connection on each machine that will access the report.

Ian

 

[jmd0252]

Also,, you could do deployment via the crystal Web server, if you have it, but you will have to have a read-only user setup for sql login. And do all your designs, etc using that common sql login.

 

[TonyScarpelli]

I'm using OLE DB for SQL Server. It's also a SQL Server 2005 database.

Right now I'm not using web deployment.

I think there is something different with the other workstation, even though I'm logging onto it.

I guess I'll have to get my SQL Server people to figure this out.

Thanks.


Tony Scarpelli
Clinical Engineering Dept.
Maine Medical Center
Portland, Maine 04102

 

[TonyScarpelli]

I think I found my problem.

I went through the Crystal Reports walkthrough "Logging onto a Secure SQL Server Database Using Integrated Security" and using our company's SQL Server database found that it worked correctly on my other workstation.

It seems there is something not set correctly in my code for the project I wrote. Why it works on my workstation and not on the other is my goal to solve for today.

Thanks all for your help.


Tony Scarpelli
Clinical Engineering Dept.
Maine Medical Center
Portland, Maine 04102