Can multiple workstations running SQL 2005 Server Express attach to the same database files on a

Can multiple instances of SQL 2005 Express attach to the same database files on a network share? I have seen this done before with MSDE where the database files are stored on the server, but instead of having a SQL server running on the network and then connecting to it, only the database files exist on the network share and the users connect through MSDE running on the local machine. Is this possible with SQL2005Express? I do not have the ability to share an SQL instance from one workstation to another nor do I have the ability to install an instance on the corporate server. Is it as simple as creating the database and storing the files on the share then attaching the database to the SQL Instance on each workstation?

No and No. You can only attach a database file to a single instance at a time and SQL Express does not support attaching files from a remote source, only local drives.

Mike

|||

As Michael indicated, that is not possible -and it is not possible with MSDE either.

You will have to install a SQL Server Express somewhere, and that will also be the location for the data files. I suggest that you communicate and negotiate with your network admins, and of course, get the 'clients' involved too.

Otherwise, you will be limited to using an Access *.mdb file -which can be stored on a file server.

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 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!
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 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!

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!

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 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!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 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!

Can I run Report Engine and Report Manager in different servers?

The Subject is the whole question: Can I run Report Engine and Report Manager
in different servers?
This is because of my current network infra-strucutre.. I know that
ReportServer is a Web-Service and Report Manager is a Web Application that
consumes this Web-Service, so I would like to know how can I configure this
App to run in another server and access the remote web service.
Thx,
Rafa®AFAIK, the only splitting of the features can be done by dividing the
database and the ReportServer (Web and Service). Nethertheless, if you could
divide them you would need two licences of SQL Server either. So building of
two ReportServers which can be connected to only one Reporting Database is
possible on by design. See SQL Server Reporting Secifications for more
Details.
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"Rafa®" <Rafa@.discussions.microsoft.com> schrieb im Newsbeitrag
news:1DC7543E-F51B-4F53-BC0E-8D323B635967@.microsoft.com...
> The Subject is the whole question: Can I run Report Engine and Report
> Manager
> in different servers?
> This is because of my current network infra-strucutre.. I know that
> ReportServer is a Web-Service and Report Manager is a Web Application that
> consumes this Web-Service, so I would like to know how can I configure
> this
> App to run in another server and access the remote web service.
> Thx,
> Rafa®