Does anyone know why there should be a requirement for a publisher/distributer to be set up in per seat licensing mode to be able to add an Oracle subscriber. I have a SQL Server 7.0 (SP4) standard edition which I've had set up for 4 1/2 years publishing data to numerous other SQL Servers (both 7.0 and 2000). The server is set up in per server licensing mode. This week I had a requirement to add an Oracle subscriber to an existing publication. When I ran the distribution agent I got the following error.
"Distributor must be running in per seat (named user) licensing mode to use
this replication feature"
I tried it again on another SQL Server 7.0 with a brand new publication, with the same result. As yet I've not tried using one of my SQL Server 2000's as the publisher/distributer (I don't have one with the Oracle client installed). All my 2000's are set up in per processor mode.
It seems to be behaving as if the subscriber is the desktop edition of SQL Server (ref KB Q207809).
I haven't found anything in BOL to say that there is this restriction.