Can I run sql server on a peer to peer network?

My dad wants me to write some inventory software for his small business (I a
m
an ex-programmer-turned-stay-at-home-mom). I have visual studio.net and a
developer edition of sql server. My dad's company has a peer-to-peer networ
k
(windows xp professional) and they don't want to buy a database server right
now. If I understand correctly, I can write an application for them and
deploy it with the database that I create in sql server(they don't need to
buy a seperate license, correct?). My questions are: If they deploy my
application on one of their pcs, can users on other pcs connect and run the
application (one at a time)? Will the application/database be able to handl
e
multiple concurrent users(5-10 users)?
Thanks for your help!Linda Call wrote:
> My dad wants me to write some inventory software for his small
> business (I am an ex-programmer-turned-stay-at-home-mom). I have
> visual studio.net and a developer edition of sql server. My dad's
> company has a peer-to-peer network (windows xp professional) and they
> don't want to buy a database server right now. If I understand
> correctly, I can write an application for them and deploy it with the
> database that I create in sql server(they don't need to buy a
> seperate license, correct?). My questions are: If they deploy my
> application on one of their pcs, can users on other pcs connect and
> run the application (one at a time)? Will the application/database
> be able to handle multiple concurrent users(5-10 users)?
> Thanks for your help!
If you run SQL Server on a Windows XP PC, then you need to run the
Personal Edition, which I believe has some concurrency throttling with
more than about 5 connections. It will work with more connections, but
you won't see the same performance as the full version. Personal edition
comes with standard/EE/a and probably developer.
The developer edition of SQL Server is not licensed for use in
production environments, so legally, you'll need to purchase a new
license... Of course, you could use MSDE (MS Data engine) which is a
free version of SQL Server for small groups. No client tools are
available, but you can use the free SQL Server Web Data Administrator
for most database tasks.
David Gugick
Imceda Software
www.imceda.com|||hi linda,
this is mahesh here
you can install sql server(your database) on any machine in your dads office
or you can access database through internet keeping at home but you have to
take care of security then
the thing is what edition yo want to install
because msde comes free & can support 5-10 users but it doesn't support very
useful features of sql sql server 2000 enterprise edition can run on any
server os and supports lot of functionality but it will be somewhat costly
as devid suggested you can use free SQL Server Web Data Administrator
but it might create security problem i don,t have great knowlege abouit this
tools
network might be any network peer to peer or client server it is ment for
data routing only
it has nothing to do with sql server
your server can be accessed by ip address only you can definately create
.net based applications
bye, have a great day
maheshmandhare@.yahoo.com
"Linda Call" wrote:

> My dad wants me to write some inventory software for his small business (I
am
> an ex-programmer-turned-stay-at-home-mom). I have visual studio.net and a
> developer edition of sql server. My dad's company has a peer-to-peer netw
ork
> (windows xp professional) and they don't want to buy a database server rig
ht
> now. If I understand correctly, I can write an application for them and
> deploy it with the database that I create in sql server(they don't need to
> buy a seperate license, correct?). My questions are: If they deploy my
> application on one of their pcs, can users on other pcs connect and run th
e
> application (one at a time)? Will the application/database be able to han
dle
> multiple concurrent users(5-10 users)?
> Thanks for your help!