I am attempting to convert my VB app from using integrated (NT) security to SQL Server 2000 security. We are doing this to regulate database access.
I have found that when I change the SQL Server user ('Admin') password to 'nothing' I am able to run the report. When I change the Admin user password to anything else I get an error stating: "Login failed for user 'Admin'".
Here is the code that works without a password:

Dim crystal As New CRAXDRT.Application
    Dim report As New CRAXDRT.report
    Set crystal = New CRAXDRT.Application
    crystal.LogOnServer "p2ssql.dll", "LAPTOP_02", "Production", "Admin", ""
    Set report = crystal.OpenReport("D:\ACS\Report1.rpt")

******************************************
Here is the code that fails when I assign a password to the user Admin:

Dim crystal As New CRAXDRT.Application
    Dim report As New CRAXDRT.report
    Set crystal = New CRAXDRT.Application
    crystal.LogOnServer "p2ssql.dll", "LAPTOP_02", "Production", "Admin", "Admin"
    Set report = crystal.OpenReport("D:\ACS\Report1.rpt")

Running the report directly from Crystal 9 works fine.

Any thoughts are appreciated.
Thanks,
Brad

Infact in you following thread

crystal.LogOnServer "p2ssql.dll", "LAPTOP_02", "Production", "Admin", "Admin"

do specify User name & Password as empty string. Only server name is nessary there.

Regards

Tanveer D.K.