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,
Could SQL Server store database files (mdf/ldf) on network shared drive if enough permission is granted?
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