up vote 0 down vote favorite
1
share [g+] share [fb]

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

link|improve this question
59% accept rate
feedback

1 Answer

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.

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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