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 |
|
jspatz
Starting Member
15 Posts |
 Posted - 2009-07-29 : 17:04:33
|
| I will preface this by saying I have little knowledge of ssis .. we were recently tasked with bringing a sql2000 database with numerous dts packages and moving the DB's to a sql 2005 cluster. We are aware that microsoft does not recommend ssis on a cluster, and we have one more DB coming online shortly that also requires SSIS. What we want to do is install SSIS on a non-cluster Server, and be able to access the packages needed through there. What we have found out is there is a 2 hop authentication issue. and it looks like it is trying to use the NT SYSTEM/Anonymous connection to connect to the databases. Is there a way of setting this up without opening the anonymous account to be able to read and write DB's using these ssis packages? |
|
|
|
|
|
question about ssis on separate server