April 30, 2008 at 6:20 pm
Hi,
I have sql server 7.0. i have a dts package. when i run it from the same machine with sql login it is working. but when i try to run it from another computer it is giving me this error -
Error: -2147467259 (80004005); Provider Error: 18452 (4814)
Error string: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0
Please help me in this regard ..
- Dominic
April 30, 2008 at 8:13 pm
It seems a security issue. Check whether or not your DTS package has authority to implement its tasks.
April 30, 2008 at 8:15 pm
It works fine when I run it in the server. But, when i run in from the client PC, i am getting that error.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply