Database attaching

I will try to describe my problem:
I need 3 workstations to work with one, the same database file (*.mdf) at
the same time. My idea is to install MS SQL Server 2005 Express engine on all
3 workstations and connect each of it to this file placed on linux server. Is
it possible?
I tried to connect my *.mdf (using path like this: \\Server\infotec.mdf)
file to one of engines using MSS Management Studio Express but I get message
that attaching databases from naetwork paths is impossible.
Is there any possibility to do this?
I can't install Database Engine on Server and use it by all of the
workstations because I don't have a Microsoft operation system server.
sorry for my English
Tomash wrote:
> I will try to describe my problem:
> I need 3 workstations to work with one, the same database file (*.mdf) at
> the same time. My idea is to install MS SQL Server 2005 Express engine on all
> 3 workstations and connect each of it to this file placed on linux server. Is
> it possible?
> I tried to connect my *.mdf (using path like this: \\Server\infotec.mdf)
> file to one of engines using MSS Management Studio Express but I get message
> that attaching databases from naetwork paths is impossible.
> Is there any possibility to do this?
> I can't install Database Engine on Server and use it by all of the
> workstations because I don't have a Microsoft operation system server.
> sorry for my English
A database file can only be attached to one server at a time. Express
doesn't require a server OS. You could put the data file on one of the
3 workstations and run Express there. The other two should still be
able to connect to that instance of Express using whatever client
application you have.
Bear in mind that Express only supports databases upto 4GB. If your
data is larger than that you'll have to buy Workgroup Edition.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
|||Thank you for your reply David.
Yes, that is true that I can install SQL Engine on one of the workstations
but in this case I need to keep this workstation working all the time i need
to connect from another workstation. And this is not so comfortable. So I see
that the simpliest but expensive solution would be changing my Linux server
to MS OS server.