|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
DTS Issue while calling from another domainhey guys,
i have this Applicaation that is hosted on one server. This makes a call to a DTS which is on teh DB server on another Domain which is behind a firewall. When the app calls it the call never excutes the DTS. Thought could be a problem with the DTS but the DTS has error loggin but that dosent show anything since the package never executed. If i change connection string to the devp serve which is on the ame domain, then not an issue. if i put the application in the same server as the DB no issue. Can you either tell me whatz wrong and a workaround for the same ty Zach How do you call DTS? I think you can use dtsrun client utility and specify
security. If you're using dtsrun allready then check if that is even started MC Show quote "zacH" <darksideofthem***@gmail.com> wrote in message news:1121408348.627573.304380@z14g2000cwz.googlegroups.com... > hey guys, > i have this Applicaation that is hosted on one server. This makes a > call to a DTS which is on teh DB server on another Domain which is > behind a firewall. When the app calls it the call never excutes the > DTS. > > Thought could be a problem with the DTS but the DTS has error loggin > but that dosent show anything since the package never executed. > > If i change connection string to the devp serve which is on the ame > domain, then not an issue. > > if i put the application in the same server as the DB no issue. > > Can you either tell me whatz wrong and a workaround for the same > > ty > Zach > Thanks for the fast response.
i call the DTS throu a C# based web application. As i mentioned i tried changeing the conncetion string and got the results *** Sent via Developersdex http://www.developersdex.com *** Hi
Running SQL profiler on the remote server will tell you if there is a failed login. John Show quote "zacH" wrote: > hey guys, > i have this Applicaation that is hosted on one server. This makes a > call to a DTS which is on teh DB server on another Domain which is > behind a firewall. When the app calls it the call never excutes the > DTS. > > Thought could be a problem with the DTS but the DTS has error loggin > but that dosent show anything since the package never executed. > > If i change connection string to the devp serve which is on the ame > domain, then not an issue. > > if i put the application in the same server as the DB no issue. > > Can you either tell me whatz wrong and a workaround for the same > > ty > Zach > > hey
the login is correct, since if there was a failed login i would have had a error message I change the connection string (just the DB name) to on on the same domain and it works fine (no change in username or password *** Sent via Developersdex http://www.developersdex.com *** Hi
If it logs in ok then you can still watch happens with SQL Profiler. It is not clear how/where you are running this package, what the differences are between the two servers, if you can connect using other tools... The following may help http://www.sqldts.com/default.aspx?204 John Show quote "zach de" wrote: > hey > the login is correct, since if there was a failed login i would have had > a error message > > I change the connection string (just the DB name) to on on the same > domain and it works fine (no change in username or password > > > *** Sent via Developersdex http://www.developersdex.com *** > Hi,
The application server can connect the DB server only thru a firewall. we kinda found a solution. we saved the DTS on the application server and called it from there. it worked. I still dont know why it didnt int he first instant Hi
Just type in sp_addlinkedserver in the index page and see what topics appear. You may also want to look up sp_addlinkedsrvlogin and also OPENQUERY. John Show quote "zacH" wrote: > Hi, > > The application server can connect the DB server only thru a firewall. > > we kinda found a solution. we saved the DTS on the application server > and called it from there. it worked. > > I still dont know why it didnt int he first instant > >  |
|||||||||||||||||||||||
Other interesting topics