Re: ADO Connection in a Service App
From: Arthur Hoornweg (arthur.hoornweg_at_wanadoo.nl.net)
Date: 11/19/04
- Next message: Mathie: "Re: Copy a table to another on different DB"
- Previous message: Brian Bushay TeamB: "Re: ADO Connection in a Service App"
- In reply to: Brian Bushay TeamB: "Re: ADO Connection in a Service App"
- Next in thread: Philip: "Re: ADO Connection in a Service App"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Fri, 19 Nov 2004 09:21:08 +0100
Alternatively, he could run the service under a user account.
That's a bit harder to setup, though.
Brian Bushay TeamB wrote:
>>Using and ADO Connection, my service application throws an error: Login failed for user '(null)'.
>
> How are you setting the User in the connectionstring?
>
>>I use the came exact connection string in my application and it works fine. Any ideas?
>>Do services need special access to get to a remote db since they are not logged in as the user?
>
> If they use Windows integrated Security then there is a problem because that
> user isn't the Account the Services uses. If you use an SQL Server Username and
> password there shouldn't be a problem.
>
> --
> Brian Bushay (TeamB)
> Bbushay@NMPLS.com
-- Arthur Hoornweg (please remove the ".net" from my e-mail address. I had to take this measure to counteract SPAM flooding my mail box)
- Next message: Mathie: "Re: Copy a table to another on different DB"
- Previous message: Brian Bushay TeamB: "Re: ADO Connection in a Service App"
- In reply to: Brian Bushay TeamB: "Re: ADO Connection in a Service App"
- Next in thread: Philip: "Re: ADO Connection in a Service App"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
