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?
精彩评论