开发者

SQL Server 2005 - SSIS validation error server-side only

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜