Install Windows service for a Sharepoint application -

I have written a Windows service to send mail to users in a Sharepoint list based on certain conditions.

The development server is a stand-alone sharepoint installation and the Windows service works fine. However, there are applications (SharePoint) and databases (SQL) on different servers in production environments.

So when Windows tries to open the service list, it says "database" can not open the "WSS_Content80" login login. Login failed. "Let me know how to proceed. I have been killed on this issue for a long time ..

This issue is quick and dirty To resolve from what you can do to allow users to grant content to your SharePoint application's database, which is running Windows services.

But you want to do it in a systematic way, I recommend you write Timer Job for SharePoint . Not only here permission is taken care of automatically but you can apply it to multiple web applications even if you want it and manage it easily.

The best article on the subject is or