Re: Create DB for filestream failes
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 9 Sep 2009 08:39:17 +0000 (UTC)
peleg (peleg@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
i am tryng to create a Db from this article :
http://www.databasejournal.com/features/mssql/article.php/3802241/Working-
with-FILESTREAM-using-VB-NET.htm?comment=16043-0
when i try to creatre the db :
...
Msg 5123, Level 16, State 2, Line 1 CREATE FILE encountered operating
system error 5(failed to retrieve text for this error. Reason: 1815)
while attempting to open or create the physical file 'd:\Program
Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\filestream1'.
Check the service account for SQL Server. There is a known issue where
using NetworkService as the service accounts does not work with Filestream.
Use a regular user account for the service account and you should be fine.
Use SQL Server Configuration Manager to change this.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: Create DB for filestream failes
- From: peleg
- Re: Create DB for filestream failes
- Prev by Date: Re: Create DB for filestream failes
- Next by Date: SQL to Access
- Previous by thread: Re: Create DB for filestream failes
- Next by thread: Re: Create DB for filestream failes
- Index(es):
Relevant Pages
|
