View Single Post
  #16 (permalink)  
Old December 11th, 2007, 06:41 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

The principle is probably the same. The account that executes your code (e.g. the DTS package in SQL Server) doesn't have permissions to access the remote database.

Can you provide more info about your setup? E.g. which servers are involved, the accounts they run under, the way you configured the DTS package, whether your "LIVE code" is in the same network or not etc etc.

You may want to take a look at this article: http://Imar.Spaanjaars.Com/QuickDocID.aspx?QUICKDOC=263 and see if it helps you understand more about security and context so you can figure out what the problem is.


Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.
Reply With Quote