Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Limuh
Yak Posting Veteran
94 Posts |
 Posted - 2008-06-04 : 02:02:09
|
| [Connection manager "CLRDB_Connection"] Error: An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Login failed for user 'CLR.Test'.". I got this error i cant resolve this. i deployed the package to other server using sql authentication. and i create the package using windows authentication on my local computer. i try to run my package in my local computer and i got this error. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-04 : 02:04:46
|
| Does you server have a valid login for CLR.Test? |
 |
|
|
Limuh
Yak Posting Veteran
94 Posts |
Posted - 2008-06-04 : 02:17:41
|
| yes. i deployed my ssis package to that server and the credentials to that server is CLR.Test. Sorry to clarify this package is created not on my local machine it was done from other machine and we have a one server where we deployed all our packages. im trying to run this package using my machine which is connected to Clr.Test server. i cant execute the package and always prompt the same error.. thanks please help |
|
|
|
|
|
|
Failed connection SSIS Package