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 |
|
Alex Nodes
Starting Member
1 Post |
 Posted - 2012-09-10 : 11:46:17
|
| Dear all,There are 3 named instances of SQL Server 2008 R2 on one machine AA: AA\ss1, AA\ss2, AA\ss3, and there are 3 named instances of SQL Server 2008 R2 on another machine BB.: BB\ss1, BB\ss2, BB\ss3I'm creating SSIS pkg (File System) on AA to copy data from AA to BB\ss1, BB\ss2 and BB\ss3When I use SQL login to connect to those instances - there is no problem to see all databases,BUT if I try to connect using Windows Authentication, any database does not appear in the list. I am a member of the administrative group on the source and destination machines and all SQL server instances. So, I have all administrative rights, but it does not help to connect to multi-instance SQL server through the network account. Any ideas will be accepted with appreciation. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-10 : 12:26:44
|
| why do you need ssis for this? why not setup replication between dbs?regarding your problem whats role to which login is mapped to in those instances?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Connect pkg TO multi-instance SQL Server