Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How to use a specific domain account in an SSIS connection object

Posted on 2012-03-27
2
Medium Priority
?
455 Views
Last Modified: 2012-03-28
I have an SSIS 2008 server that runs all my SSIS packages in a domain. Let's call this domain SSIS.net. I need to connect to the OLTP SQL server instances on OLTP.com. The sys admins of the OLTP.com domain do not want to create a SQL account for me, then want me to use a domain account to connect to the OLTP instances on OLTP.com, and to make life even funner, there is no trust between the domains.

When I run the SSIS package it is running under the SQL agent account named "sqlAgent@ssis.net". What I would like to do, is write a custom connection string for the connection objects that need to talk to OLTP.com. How do I use integrated authentication in an SSIS connection object so when the package attempts the specific step to OLTP.com it uses the domain account for OLTP.com?

Thanks in advance!
0
Comment
Question by:sqlagent007
2 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 2000 total points
ID: 37775452
Not sure what the impact of the missing trust will be, but perhaps the following is worth giving a try?

Data Source=THE_SERVER;Initial Catalog=THE_DB;Provider=SQLNCLI10.1;User ID=DOMAIN\USER;Password=*****;

(adapt all values to your specific situation)

THE_SERVER can be in the form of "IP address,port number", for instance 1.1.1.1,1433

(ref. http://www.connectionstrings.com/sql-server-2008)
0
 
LVL 1

Author Closing Comment

by:sqlagent007
ID: 37776725
Thanks!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question