Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using SQL Server 2008 Enterprise on Windows Server 2008. I learned from this link that NAS storage is not enabled by default. Any ideas how to enable it?

Quote from this link,

on the network, then by default, the disk storage system is not supported as a location for SQL Server databases.

thanks in advance, George

share|improve this question
up vote 1 down vote accepted

Setting trace flag 1807 will tell SQL to bypass the check that it does to see if the files are on a network share. Have a look at this KB article.

Why you would do this, though, is really the question. It's really bad news for SQL.

share|improve this answer
How to set the trace flag? I did not see any command to enable this from the Url. – George2 Jul 3 '10 at 3:52
Thanks, question answered. I met with a further issue, which is how to set username and password for the network shared location in SQL Server. I post this question here, any solutions?… – George2 Jul 3 '10 at 14:23

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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