March 28, 2016 at 4:56 pm
I am installing a SQL Server 2014 Instance on a server in my domain. There is already a 2008 R2 Instance on a different server in the same domain.
The 2014 Instance needs to:
1) Run SSIS packages via the 2014 SQL Agent that have connection strings to the 2008 R2 Instance
2) JOIN tables in the 2008 R2 Instance in tables in the 2014 Instance (T-SQL code in stored procedures)
How should the service account be set-up for the SQL Server Agent and SQL Server?
I have done this when both Instances are on the same server using the default virtual accounts. However, I don' think these accounts or the Local accounts have a domain level scope.
Thx
March 29, 2016 at 10:27 am
Create a domain account that has access to the required databases both in 2008 and 2014 servers.
Execute the SSIS job as the domain account
April 7, 2016 at 9:40 am
That worked. Also, if you create a SQL Agent job, the domain account for the SQL Agent needs correct permissions in 2008 to execute any stored procedures used in the SSIS package.
Thx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply