Thanks for your help! There research must go on!

Regards,

Nick

This is a legacy but robust classic ASP / VB6 application. VB6 objects created within the classic asp page do all of the sql data access firing stored procedures that...

The web app passess a connect string to the stored proc that contains the SQL login account info.

The web and sql boxes are not on the same workgroup.

(Incidently, the web...

Tim,

Many thanks for the swift reply. Unfortunately I still get the access denied error when trying to execute the stored procedure from any app other than QA on the SQL...

Dear All,

I have a similar scenario...

Using SQL 2000 running on Windows Server 2003.

The SQLServer and SQLServerAgent services are running under local system.

I am trying to query MSDIXS on a different...