I am getting following error message for quite a few of my procedure in webfocus.They run fine in the developer studio but when i try to schedule them using Report caster, i get the below listed error message.Does any one know what's causing it.

: Microsoft OLE DB Provider for SQL Server: [08001] [DBNETLIB][ConnectionO
pen (Connect()).]SQL Server does not exist or access denied.
L (FOC1406) SQL OPEN CURSOR ERROR.

1. In Dev Studio do you have the MSSQL server configured on localhost
and are you creating and testing the jobs on localhost?

2. Is the MSSQL server configured on the reportcaster WebFocus server?

3. Are you using explicit,password passthrough or trusted connection to MSSQl?

MSSQL trusted (which is most likely) has an issue if the caster job userid and password
are not valid Domain id's but are dedictaed run time id's.

The id must either be a valid domain id or it must be an MSSQL specific id and authentication
in MSSQL must be set to allow both.

1. In Dev Studio do you have the MSSQL server configured on localhost
and are you creating and testing the jobs on localhost?
I am not sure but i believe it is a locast host. This was already setup by my precessdor.

2. Is the MSSQL server configured on the reportcaster WebFocus server?

Yes.

3. Are you using explicit,password passthrough or trusted connection to MSSQl?

I am using Explicit connection to MSSQL.

OK,

You need to go to the WebFocus server console used by the Report Caster server not your localhost.

Goto adapters and test the conection to the problem MSSSQL instance.

If that fails your adapter is configured incorrectly.

userid / password and server all need to be checked