sql server connect: Window Service c# -- sql server connect

Window Service c#

JJ
9/21/2005 8:11:05 AM

sql server connect:

Hi,

I have a windows service that I built in c#. I am trying to connect to a
sql server database with trusted authentication but I get login keeps on
failing. So I am assuming that I need to supply different login credentials
since its not accepting my windows nt login that I use for logging in to
desktop and being a window service, correct? What do I need to do in order to
connect?

Re: Window Service c#

David J. Cartwright
9/21/2005 1:12:53 PM

I believe you can do one or both of the following

1. Set your service to use a domain account which has access to the SQL
Server
2. Have the service impersinate a user (or current user) which has been
given access

[quoted text, click to view]