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()?
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?
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.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy