August 16, 2017 at 8:49 am
When running from my desktop version, SSIS seems to be ignoring the account passed to the connection manager.
Verified that my variables are set correctly.
Executing select @@servername,db_name(),system_user in sql task to verify connection and returning those variables.
Debug watch shows the system_user is the same as my desktop, Not the user passed to it...
Have I missed something ?
Thanks
August 16, 2017 at 9:28 am
rsampson - Wednesday, August 16, 2017 8:49 AMWhen running from my desktop version, SSIS seems to be ignoring the account passed to the connection manager.
Verified that my variables are set correctly.
Executing select @@servername,db_name(),system_user in sql task to verify connection and returning those variables.
Debug watch shows the system_user is the same as my desktop, Not the user passed to it...
Have I missed something ?
Thanks
Do you get anything different if you select SUSER_SNAME()?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 16, 2017 at 11:40 am
Nope, same thing...
August 16, 2017 at 11:42 am
I did verify the query I had before, returned correct results when I logged into SSMS as that user...
August 16, 2017 at 12:30 pm
So are you trying to connect as a SQL Server named user, by passing username and password credentials?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 16, 2017 at 12:44 pm
Nope, Connecting to a Sql Server via Integrated Security (AD account)...not Sql Account so no password is being passed...
August 16, 2017 at 2:14 pm
rsampson - Wednesday, August 16, 2017 12:44 PMNope, Connecting to a Sql Server via Integrated Security (AD account)...not Sql Account so no password is being passed...
In which case, you are not 'passing an account to the connection manager', so I do not understand where the problem is. The connection will log in as you.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply