[RESOLVED] Problems with Intergrated Security

[Ginster]

Help

I'm trying to open a Crystal Report in a CRViewer on a Windows Form.

The report has been created with Intergrated Security and is based on a sp.

When trying to open the report from my vb app i'm being propmted for my ID and Password.

I'm also using the following code

crTables = crReportDocument.Database.Tables
 
        For Each crTable In crTables
            crtableLogoninfo = crTable.LogOnInfo
            crtableLogoninfo.ConnectionInfo = crConnectioninfo
            crTable.ApplyLogOnInfo(crtableLogoninfo)
        Next

Does anyone know where I'm going wrong?

Thanks

[FishGuy]

I dont know if your problem is SQL permissions or if its only a deployment issue have you entered all the crystal report registration details in your deployment project.

http://support.businessobjects.com/c...deployment.pdf

[Ginster]

Have just found out it was SQL Permissions.


As someones Sig says

Sometimes it's the Programmer
Sometimes it's the DBA

This one was down to the DBA

Thanks