I have a VB application which is based on an Access dB
which is replicated to many remote sites. I am looking
into switching to an SQL Server solution and want to know
if every remote location with a replica will need an SQL
server license? Also, with Access, the Access .mdb file
can be used with VB without a copy of Access on the
remote system, does SQL Server work the same way?

Thanks,

you will NOT need a copy of access on each client. You
will be creating linked server to the existing mdb files
on the subsciber. Go to Tools|Replication|configre
publishers, distributors, subscriber, select subscriber,
new, Microsoft jet, use a UNC to the database.

You will need the appropriate licensing for each client to
access SQL Server. My understanding is that with SQL 2000
there is a per processsor license which means that you
purchase a license per processor. 1 processor you need 1
processor license, 2 CPU's ,2. Etc. Then any number of
clients can connect.

Otherwise each client conneting to your SQL Server needs a
per seat license. If you expect 500 clients, then you
need 500 licenses/CALS.

Licensing isn't my strong point. I urge you to speak with
your microsoft contact/software reseller about this.


Check out

http://www.microsoft.com/licensing/downloads/server_product
s.doc

and

http://www.microsoft.com/licensing/downloads/server_product
s.doc




[quoted text, click to view]