0

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 Answer 1

2

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

2: No. That definitely is not possible.

13
  • 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, 2010 at 14:11
  • 1
    @George2: Why do you want to do this? It's very unorthodox.
    – joeqwerty
    Jun 29, 2010 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, 2010 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, 2010 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, 2010 at 16:18

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .