I've installed a vb.net windows service on a Windows 2008 machine, that is attempting to connect to SQL 2005. The service starts succesfully, but can't see the database. The event log has the following entry.
The description for Event ID 0 from source SU4.ESMR.DAL.Job.FillPriorityJobByType(oJobDS, TypeID: 3 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
This was tested locally on both XP and 2008. All environments are 32 bit.
Best Answer
There isn't much to go on here, but it sounds to me like the service account doesn't have the required access rights to the database.
If you installed the service to run under Network Service or Local, create an account on the server that has access to the database and change it to use that service.