Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

http://support.microsoft.com/kb/304261/en-us

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

1 Answer 1

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? stackoverflow.com/questions/3171759/… –  George2 Jul 3 '10 at 14:23

Your Answer

 
discard

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.