开发者

SQL Server 2005 - SSIS validation error server-side only

开发者 https://www.devze.com 2023-01-21 08:53 出处:网络
I am deploying some integration services into a SQL Server 2005. On my computer, I don\'t have any validation error but I do on the server.

I am deploying some integration services into a SQL Server 2005. On my computer, I don't have any validation error but I do on the server.

It comes from an OLE DB connection manager: "Login failed f开发者_运维百科or user 'rw_user'". Whereas I can fully run it on a client, the connection works perfectly.

This is a connection to the server itself.


Thoughts:

  • If you can run it locally, is it under your credentials?
  • That is, have you fully permissioned rw_user on the target SQL Server?
  • User/password stored OK in the package?
0

精彩评论

暂无评论...
验证码 换一张
取 消