Server Location II

Given that a file server is just a normal computer where people tend to store files, the answer is yes, you can. You just log onto the computer and install SQL Express normally. But I'm guessing that you have some specific motive other than a normal install, so could you give details about what you're really trying to do?

Mike

MikeWachal-MSFT at 2007-10-9 >

SQL Server is a service that runs on a computer, not a file. You will have to be an administrator on the computer where you want to install SQL Express. It is most likey that you will need to ask your companies IT department to do this for you. Once SQL Express is installed on the server computer, you access it via a connection string, not via a mapped drive.

You might want to read more about installing SQL Server so you clearly understand all the requirements. There are many topics in Books Online that discuss this, I would start with this one (http://msdn2.microsoft.com/en-us/library/ms143719.aspx) and work from there.

Mike

MikeWachal-MSFT at 2007-10-9 >

The datafiles must be on a logical drive for the computer running SQL Server -a mapped drive does not work.

As Michael indicated, you can install SQL Server on the file server -BUT it will run as a service on the file server and will require at least local admin priveleges on the file server for installation.

ArnieRowland at 2007-10-9 >