Create database on NAS

I am using SQL 2005 std edtition. Everyone time I create a new database with
files being located to say \\nas\db2. I get 5110 error.(5110 (File
'file_name' Is On A Network Device Not Supported For Database Files).
I read about traceon and other MS KBs but no luck. Anyone ?
thanks(a) I strongly recommend NOT using a NAS for SQL Server... this is not
exactly a robust environment to be running a high performance database
application.
(b) if you really want to go through with it, then you should be mapping a
driver letter for the SQL Server service account user (and any other user
that will need to access it). Ideally, SQL Server uses a local drive (even
if we are talking SAN / direct attached storage), but barring that, it at
least needs to *look* like a local drive.
A
"andyoye" <andyoye@.nospam.com> wrote in message
news:%23RA0%23q04HHA.1484@.TK2MSFTNGP06.phx.gbl...
>I am using SQL 2005 std edtition. Everyone time I create a new database
>with files being located to say \\nas\db2. I get 5110 error.(5110 (File
>'file_name' Is On A Network Device Not Supported For Database Files).
> I read about traceon and other MS KBs but no luck. Anyone ?
> thanks
>
>|||And here's a KB on the topic:
http://support.microsoft.com/default.aspx?scid=kb;en-us;304261
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uiZtE104HHA.4476@.TK2MSFTNGP06.phx.gbl...
> (a) I strongly recommend NOT using a NAS for SQL Server... this is not exactly a robust
> environment to be running a high performance database application.
> (b) if you really want to go through with it, then you should be mapping a driver letter for the
> SQL Server service account user (and any other user that will need to access it). Ideally, SQL
> Server uses a local drive (even if we are talking SAN / direct attached storage), but barring
> that, it at least needs to *look* like a local drive.
> A
>
> "andyoye" <andyoye@.nospam.com> wrote in message news:%23RA0%23q04HHA.1484@.TK2MSFTNGP06.phx.gbl...
>>I am using SQL 2005 std edtition. Everyone time I create a new database with files being located
>>to say \\nas\db2. I get 5110 error.(5110 (File 'file_name' Is On A Network Device Not Supported
>>For Database Files).
>> I read about traceon and other MS KBs but no luck. Anyone ?
>> thanks
>>
>