CODEWITHSUNDEEP
sql-serverauthenticationssis
newbie
newbie

Reputation: 3

SSIS Connection Manager points to Windows Authentication

I have created an SSIS package, and I have set the UserId and Password in Connection Manager. I have also pointed it to Log On to Server as SQL Authentication. Protection level is EncrypytSensitiveWithUserKey. However, when I executed the package, authentication seems to get the current user log on, and not the User Name that I have set earlier in Connection Manager.

However, when I tried to test the connection, it succeeds. But I notice that everytime I open the connection manager windows, log on to server is always set to Windows Authentication.

What could be the problem?

Thank you so much.

Upvotes: 0

Views: 984

Answers (1)

Aashish Jain
Aashish Jain

Reputation: 121

Check for expression evaluation property . https://msdn.microsoft.com/en-in/library/ms141214(v=sql.105).aspx

So ,its not overriding default connection.

Thanks.

Upvotes: 0

Related Questions