Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Minimum Setup Requirements for SQL 2005 Replication.

0 views
Skip to first unread message

Stuart Lowe

unread,
Feb 1, 2007, 8:59:00 AM2/1/07
to
What are the minimum setup requirements to support the following.

2 Remote Laptops running SQL Server 2005 Express databases with the ability
to synchronize with each other. Also they should be able to synch with a
server hosting a SQL Database whci is accessible from 2 other Desktop PCs.

What are the SQL CAL Licensing issues that would apply to this scenario.

Regards

Hilary Cotter

unread,
Feb 1, 2007, 9:16:12 AM2/1/07
to
Unfortunately SQL Server Express can only be a subscriber to all types of
replication. All subscriptions must be created through RMO or replication
stored procedures.

Regarding your desktop pc's - If they are running workgroup edition they can
have up to 25 merge subscribers, but 5 transactional subscribers. In regards
to licensing anything which accesses the desktop must have a license, which
can be a CAL or a server per processor license (which will not make a whole
lot of sense).
--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"Stuart Lowe" <Stuar...@discussions.microsoft.com> wrote in message
news:6C1471E6-61F1-4BF2...@microsoft.com...

0 new messages