Peer to Peer 64bit and 32bit question

If I have an existing 64bit P2P transactional replication setup, can I join
a 32bit machine without any expected problems or does it also have to be a
64bit machine?
Any direction to resources would be great as well.
Adam P. Cassidy
Adam,
For SQL Server 2000, the issues were summarised as follows:
As the Microsoft Jet engine is not supported, Microsoft Jet push
subscriptions for merge replication are not supported.
Unless the subscriber provides a 64-bit ODBC or OLE DB driver, transactional
or snapshot push subscriptions for ODBC or OLE DB subscribers are not
supported.
Because of the unavailability of 64-bit Data Transformation Services (DTS),
transformable push subscriptions are not supported.
In Peer-to-peer between 64bit and 32bit I am therefore aware of no issues.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||This is a tested configuration
"Adam Patrick Cassidy" <apcassidy@.aol.com> wrote in message
news:O%23gjeUCCHHA.4864@.TK2MSFTNGP04.phx.gbl...
> If I have an existing 64bit P2P transactional replication setup, can I
> join
> a 32bit machine without any expected problems or does it also have to be a
> 64bit machine?
> Any direction to resources would be great as well.
> Adam P. Cassidy
>
sql

Patching SqlRun_Sql.msi not successful

Hi all,

when I tried to integrate SP1 into my install media (32bit Developer Edition) by using

msiexec /i sqlrun_sql.msi shortfilename=true /p sqlrun_sql.msp

using the msp from an extracted SP1 full web download I ended up with a modified msi file. But installing from this one I received an error:

"sysdbupg.sql.<some_guid> was not found in Sql.CAB"

Any ideas how to fix that?

With best regards,

Artus

Hey Artus, what is it specifically that you're trying to integrate? Are you able to change your install cmd to call the SP1 exe instead? Are you confined to call the msp's directly? This gets a bit sticky and we'd prefer to stay with the exe if possible.

Thanks,
Sam Lester (MSFT)

|||

Hi Sam,

for the university I am at we are looking for a solution to deploy SQL Server 2005 to several dozens of computers. It is though not feasible for us to get someone manually installing SQL Server to each computer that is why we are

(1) looking for a program to write an appropriate MST file [any hints appreciated] to deploy custom installation for our AD forest

(2) integrating SP1 and the hotfix rollup for SP1 into the install media *

And for (2) I extracted the SP1 web download, searched for the MSPs and now try to integrate them into the corresponding MSIs.

With kind regards,

Artus

*.) We don't get any of the two updates delivered by Microsoft Update opposite to what we expected when we migrated to Microsoft Update. If WSUS will deliver both the SP1 and the rollup we were fine with that, too

|||Still any help appreciated :-)|||

Running the MSP directly to upgrade to SP1 is not supported. You should look at launching the hotfix.exe using the unattended command-line flags, such as /quiet and /allinstances.

SQL Server SP1 has just been published to Microsoft Update so you can also obatin the update from there.

Peter