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 |
|
heze
Posting Yak Master
192 Posts |
 Posted - 2007-08-29 : 09:43:53
|
| hi,Im I want to configure my sqlserver 2005 server as both subscriber and distributor for transactional replication purposes.I want to configure the sql server 2000 as the publisher.When I try to configure the publisher in the sql 2000 server, Im not being able to establish the connection with the distributor 2005 sql server in any of the 2 possible cases.case1-Using windows authentication- message:need to use management studio or SMOcase2-Using sql server authentication-message:authentication failedQuestion:Is it possible at all to do this? or should I make the distributor to reside in a sql 2000 server?thank you |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-30 : 00:56:02
|
| You can register sql2k server in ssms and configure publisher there. |
 |
|
|
|
|
|
(publisher sql 2000)-(distributor 2005):problem