really simple question

Hi Everyone,
I'd like to test developing in SQL on my peer network before installing
the application on my clients' servers. I am using VB.Net and MSDE as
my tools.
Question:
- Does MSDE have to be installed on each station in my peer-to-peer LAN?
or
Do I _only_ need to install it on the station with the actual database
files (mdf/ldf files)?
Thanks
Richard
hi Richard,
"Richard Fagen" <no_spam@.my_isp.com> ha scritto nel messaggio
news:%23G2LfjzEEHA.3784@.TK2MSFTNGP10.phx.gbl...
> Hi Everyone,
> I'd like to test developing in SQL on my peer network before installing
> the application on my clients' servers. I am using VB.Net and MSDE as
> my tools.
> Question:
> - Does MSDE have to be installed on each station in my peer-to-peer LAN?
> or
> Do I _only_ need to install it on the station with the actual database
> files (mdf/ldf files)?
>
as MSDE acts in a traditional client/server and multi-user situation, you
usually only have to install 1 instance of MSDE on the server that all
clients want to connect to.
if every pc on the lan hosts MSDE, than usually each of them will query the
local MSDE acting as a single user or desktop solution..
in the first scenario, only 1 MSDE server is available, every client will
connect to it and both queryes and results will be sent over the network..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.6.0 - DbaMgr ver 0.52.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply