I am using SQL Server 2008 Enterprise on Windows Server 2008 Enterprise and I have a network shared drive Z (which the host machine of SQL Server 2008 could access from resouces explorer). My questions are,

  1. Could SQL Server store database files (mdf/ldf) on network shared drive if enough permission is granted?

  2. If the answer to 1 is yes, then as the network drive is protected by some user name and password (in order to write to the network drive). But my SQL Server instance services runs under some other Windows account. How to enable SQL Server to access/write such kinds of account/password protected network drive in this situation? I am not sure if we could set some special network drive permission so that no password is needed in order to access/write network drive? Or we could use "net use" command to store network drive access password?

thanks in advance, George


1: yes, in theory. Very unadvisable for many reasons.

2: No. That definitely is not possible.

  • 1
    well, lets see - I am sure you can somehow USE a network drive, but entering the password simply is out of the question. In genral, using a network drive (or drives - never put your log in the same drive as the database if you want any performance) is simply so unprofessional I do not even do it in development. – TomTom Jun 29 '10 at 14:11
  • 1
    @George2: Why do you want to do this? It's very unorthodox. – joeqwerty Jun 29 '10 at 14:31
  • 1
    It is not only unorthodox, it breaks any guidelines and will result in a very bad performance. In general, someone made a decision that should result in his termination - especially if he tries to defend it. – TomTom Jun 29 '10 at 14:45
  • 1
    if sql server is running as a domain account, sql server can access file server shares as that user. – johnh Jun 29 '10 at 16:09
  • 2
    IMO, a better solution would be to add storage to the SQL server than to attempt to run a database from a network share. – joeqwerty Jun 29 '10 at 16:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.