Connecting to SQL/Server Trusted Connection from ASP

[magicboy]

We are migrating our site from Informix to SQL/Server and I have a problem when calling my Crystal Report from ASP.

The old code was...
Dim webSource
Set webSource = CreateObject("WebReportSource.WebReportSource&quot
webSource.ReportSource = webBroker
webSource.URL = URL
webSource.AddParameter "user0", "ourUser"
webSource.AddParameter "password0", "ourPassword"
webSource.AddParameter "prompt0", ourParam1
webSource.AddParameter "prompt1", ourParam2
webSource.AddParameter "prompt2", ourParam3
webSource.PromptOnRefresh = True

The crystal report has been changed so that it now used an ODBC that has a Trusted Connection to the SQL/Server database.

I have removed the user0 and password0 lines from the code above as I figure they should not now be required but when I run the report from the ASP page I am being prompted to enter the user and password.

When I run the report directly it works fine without entering user/password.

Can anybody help?

 

[Wilciek]

I don't know anything about asp but I think SQL is looking for a login. Try user0 as 'sa' with password0 as the password you use to login to SQL as the 'sa'

I don't know if this will help but it's worth a shot