Post reply

Problem With Adding FileStream To My DB

  • June 2, 2009 at 11:55 pm

    #222024

    Hi To All

    I have an problem with adding FileStream in SQL Server 2008.

    *I enabled FileStream in my SQL Server Instance

    *I enabled FileStream in my DB

    my error is:

    Unable to open the physical file "F:\FileStream\Devins_FS". Operating system error -2147024891: "0x80070005(failed to retrieve text for this error. Reason: 1815)". (Microsoft SQL Server, Error: 5120)

    *I logged in with sa User and my windows user is Administrator

    *Windows Version: Windows Server 2003 R2 x64

    Please Help Me...

    Thank You...

  • June 3, 2009 at 12:22 am

    #1003784

    please check below links,

    http://social.msdn.microsoft.com/forums/en-US/transactsql/thread/f8a9a6bd-99ae-4f0f-8ba6-8a1d3326d2a9/

    http://www.google.co.in/search?hl=en&client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&q=sql+server+2008+filestream+feature+is+disabled&btnG=Search&meta=&aq=3&oq=sql+server+2008+filestream

    "Don't limit your challenges, challenge your limits"

  • June 3, 2009 at 12:33 am

    #1003786

    Thanks for your reply.

    I enabled FileStream feature

    this problem is only for one server in my organization and other servers work without problem.

    Please Help Me...

  • June 3, 2009 at 6:35 am

    #1003928

    Does the account that SQL Server is running under have access to that drive and/or share? It sounds like a security issue.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • June 3, 2009 at 6:45 am

    #1003942

    yes.

    we logged in as administrator user and have full access.

    I haven't problem with create a new DB and adding other File Groups and Files

    my problem is only with FileStream.

  • June 3, 2009 at 7:33 am

    #1003999

    It still sounds like a permissions problem.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • August 1, 2009 at 12:54 pm

    #1033382

    I would suggest you login to SQL Server using your Windows account (administrator) rather than using 'sa' (sql server authentication) and try again.

    .

  • August 26, 2009 at 8:56 am

    #1044931

    As Grant Fritchey said, it is probably a permission issue.

    One thing I often see and it's overlook is the file / folder permission. Even if all services are using admins right etc, if the file / folder property is "read-only" flagged then that kind error can arise. (this permission is not bypassed by admin rights)

    One way to easily reproduced it is trying to perform a backup overwriting one already existing having the read only file flag set at the file level. It will raise that error.

  • September 9, 2009 at 1:27 am

    #1050935

    did you manage to solve the problem?

    i got the same one

    Thanks

    peleg

  • December 23, 2009 at 6:28 am

    #1095887

    Even i am facing the same pbm

  • December 23, 2009 at 7:55 am

    #1095929

    there is a bug opened on that issue

    check if the service is running as "NetworkService"

    and change it to a user with Admin priviliges.

    after it restart the service and check again

    good luck!:-D

  • December 23, 2009 at 10:58 pm

    #1096221

    Thanks for the reply, i tried your suggestion, but still throwing error Unable to open the physical file. Operating system error -2147024891: "0x80070005(Access is denied.)".

  • December 29, 2009 at 2:23 am

    #1096941

    I'd try....

    Log in using the windows SQL account your SQL services are running under.

    Stop SQL Server so the fielstream file is not locked and then see if you can move or rename the file.

    If you can't move or rename the file it is a permsisions issue.

    Also, check the file attributes.

  • December 31, 2009 at 2:56 am

    #1097798

    I got the error when i tried to create the database with filestream filegroup by using the below script.

    CREATE DATABASE TEST

    ON

    PRIMARY (

    NAME = TESTDB,

    FILENAME = 'E:\Tempfs\fs\TESTDB.mdf'

    ), FILEGROUP TESTFS CONTAINS FILESTREAM(

    NAME = TESTFS,

    FILENAME = 'E:\Tempfs\fs\TESTFS')

    LOG ON (

    NAME = TESTLOG,

    FILENAME = 'E:\Tempfs\fs\TESTLOG.ldf')

    GO

    The error is as below Unable to open the physical file "E:\Tempfs\fs\TESTFS". Operating system error -2147024891: "0x80070005(Access is denied.)".

    Thanks,

    Starterm

  • December 31, 2009 at 3:03 am

    #1097801

    I've tried your code and there is nothing wrong with it so it still looks like permissions.

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply