asked on

Windows Service trying to write to database table...proglem logging in

I am getting the following SQLException:

Message "Login failed for user 'ITDEV\Administrator'." string

~~~~~~~~~~~~~~

Now, I know that I can use SQL Server Enterprise Manager just fine.....and I can read and write to the table that I am trying to write to in my C# Windows Service. I know that other parts of the Windows Service are running okay.

Tom Knowlton

ASKER

Here is my current connection string:

server=ITDEV;Trusted_Connection=yes;database=RedWall;

This works for other apps just fine.

ASKER CERTIFIED SOLUTION

AdrianJMartin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Tom Knowlton

ASKER

The services control panel?

dfiala13

What's the Logon account being used by the service?
What account do you logon under?

Tom Knowlton

ASKER

Administrator (and admin pw as well)

Isn't this just a logon for the service itself (not for the database connection later on?)

SOLUTION

dfiala13

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Tom Knowlton

ASKER

Are talking about mixed authentication versus NT Authentication?

Tom Knowlton

ASKER

I am positive I use Windows NT authentication when creating a DSN under Data Sources (ODBC) in Administrative Tools. These DSN entries are on the same machine I am testing the Windows Service on.

Does this help?

dfiala13

If you are using windows authentication then the windows account the service is running under comes into play.