I have an application that runs fine when executed off the server. When clients try to connect, they receive the following error:
Failed to get data. *Data provider could not be initialized *SQL Server does not exist, or access denied
on my Office Web Components (MDAC). I am guessing there is some security or server configuration error, but I'm not able to pinpoint it. I am running SQL Server 2005.
*Note - clients can't change their security settings, company policy.
firewall issue. diable firewall, run instance again