December 18, 2008 at 8:40 am
I am trying to connect my 2000 server to another 200 server. What I am trying to do is just setup a DTS job that will insert some data into the other server.
I do not have control of that other server and the other server is on a different domain.
I am a user on that domain, but my password is not the same on each domain. (one domain we control and the other it the company domain and the passwords must be changed monthly)
My server logs into our domain.
If I log my test server's desktop into the company domain, then I can connect to the other server.
I don't want to log my production server into the company domain because then I will be basically giving the company access to my server. (we are a small consultanting)
So basically, 2 servers, different domains, how do we connect them through DTS?
December 18, 2008 at 8:48 am
I guess posting the error message that I get would be helpful :
Login failed for user '(null)'. Reason : Not associated with a a trusted SQL Server connection.
December 18, 2008 at 9:33 am
There are numerous reasons why you may be getting that error. I'm not an expert on network security so I'm going to stay clear of that one.
One option that you may have, is to create a SQL login on the other server and use that to connect. It worked for me many times.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 18, 2008 at 9:45 am
Thanks for the reply.
Having the admin of the other server create a SQL Login would be my next option if I cannot get connected this way.
I can bring up the other server and connect to it in windows explorer and see the share list. I have to go through the 'Connect as' dialog box and specify a user on the other domain, but I can't seem to do the same thing through DTS.
December 18, 2008 at 9:55 am
Connect as? Oh I hate and love that. Hate that I have to use it but love that it is available.
If you running the DTS manually, you can launch Management Studio using Run As and specify the account that work. This won't work if you're automating the process as a job.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 18, 2008 at 10:10 am
I'm running 2000, so no Management Studio and I am setting up this DTS job so that it can be automated daily.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply