Monday, March 19, 2012

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.

No comments:

Post a Comment