Error attaching SQL filestream database – Reason: 15105

Symptoms

While trying to attach a filestream database in SQL 2005 – onto a mounted drive, I received the following errors and the database would not attach.

“Could not open file ‘mounted drive:\foldername\filestream folders’ for file number 65540.  OS error: 0xc0000022(failed to retrieve text for this error. Reason: 15105).”

Solutions

  • Check that you do not have the data or log files in the root of the mounted drive.  In my example I mounted the drive as “M:\DATA”, so I created a subfolder and applied permissions on this subfolder – “M:\DATA\datafiles”.
  • Check that the SQL Service account “SQLServerMSSQLUser$servername$SQLinstancename” has full permissions on the folder and that the permissions are passed onto the files and folders located within this folder.
  • Once you have ensured that the two setting above are in place you should have no problem attaching the filestream database.

Please refer to another article I wrote on how to Attach FILESTREAM-Enabled Database with multiple data files and filestream directories

 

 

 

29 comments

  1. Hey! This is my 1st comment here so I just wanted
    to give a quick shout out and say I really enjoy reading your articles.
    Can you suggest any other blogs/websites/forums that
    deal with the same topics? Many thanks!

  2. Very great post. I just stumbled upon your blog and wished to mention that I have really loved browsing your weblog posts.
    In any case I will be subscribing for your RSS feed and I’m hoping you write again very soon!

  3. You have made some good points there. I looked
    on the internet for additional information about the issue and found most
    individuals will go along with your views on this web site.

  4. My weblog is in the precise identical niche as yours and my users would absolutely benefit from a lot of the data you present right here.
    Please let me know if this okay with you.

  5. I don’t even know how I ended up here, but I thought this post was great.
    I don’t know who you are but certainly you’re going to a famous blogger if you aren’t alrteady 😉 Cheers!

  6. First off I would like to say fantastic blog! I had a quick question which I’d like
    to ask if you do not mind. I was interested to know how you center yourself and clear your mind
    before writing. I have had difficulty clearing my
    mind in getting my thoughts out. I truly do take pleasure in writing but it just
    seems like the first 10 to 15 minutes tend to be lost simply just trying to figure out how to begin. Any
    suggestions or tips? Many thanks!

    1. Thank you for taking the time to visit my site. Writing is all about your mood and surroundings. If you are trying to write in a noisy environment, you will find that you get distracted easily and you are on an uphill struggle from the start. Make sure you are comfortable and sitting in a relaxed (not too relaxed) position and think of what you are going to write about. If you get the idea right in your head before you write a single word then it will happen. If you stumble or you feel you are getting nowhere, then take a break away from your writing area. Do something to unclog your mind, I find ironing shirts helps me. Odd but true.

  7. I don’t even know how I ended up here, but I thought this post was
    great. I do not know who you are but certainly you’re going to a famous blogger if you aren’t already 😉 Cheers!

  8. Pretty section of content. I simply stumbled upon your blog
    and in accession capital to assert that I acquire actually enjoyed account your blog posts.
    Anyway I will be subscribing to your augment and
    even I fulfilment you get entry to consistently fast.

  9. Do you mind if I quote a few of your posts as long as
    I provide credit and sources back to your blog? My blog is in the very same niche as yours and my visitors
    would truly benefit from some of the information you present
    here. Please let me know if this okay with you.
    Many thanks!

  10. Hello my friend! I wish to say that this post is awesome, nice written and come
    with approximately all significant infos. I’d like to see more posts like this .

  11. You could definitely see your expertise within the article you write.
    The sector hopes for more passionate writers like you who are
    not afraid to say how they believe. At all times go after your heart.

  12. I think this is one of the most important info for me. And i’m glad reading your article.

    But should remark on some general things, The site style
    is wonderful, the articles is really great : D. Good job, cheers

  13. We absolutely love your blog and find a lot of your post’s to be exactly I’m looking
    for. Does one offer guest writers to write content for you?
    I wouldn’t mind composing a post or elaborating on a lot of the subjects you write concerning here.
    Again, awesome web site!

  14. Fantastic goods from you, man. I have understand your stuff previous to and you are just too excellent.
    I really like what you’ve acquired here, really
    like what you are stating and the way in which you say it.
    You make it enjoyable and you still take care of to keep it sensible.
    I cant wait to read much more from you. This is actually a tremendous site.

  15. After looking over a few off the blog articles on your website,
    I truly like your way of blogging. I saved as a favorite it
    to my bookmark webpage list and will be checking back
    in the nedar future. Take a look at my website too and tell me
    how you feel.

  16. Howdy excellent website! Does running a blog such as this take a great deal of work?
    I’ve absolutely no expertise in coding however I had been hoping too start my own blog soon. Anyhow, should you have any suggestions or tips for
    new blog owners please share. I understand this is off
    topic however I simply needed to ask. Appreciate it!

  17. I just couldn’t leave your web site prior to suggesting that I extremely enjoyed the standard
    information an individual provide in your guests?

    Is gonna be again ceaselessly in order to investigate cross-check
    new posts

  18. I know this web site gives quality based articles or reviews and other data, is there any other
    site which offers such information in quality?

  19. hello!,I like your writing so a lot! proportion we communicate more about your post on AOL?
    I require an expert on this area to resolve my problem.
    May be that is you! Taking a look ahead to see you.

    1. It seems like new technologies come out every day to do the same tnhigs we have done for years and vendors are bombarding us with marketing campaigns to use them. It’s not uncommon to find ourselves wanting to implement these new technologies and techniques whilst the solution has been available to us all along. I would like to praise you for the simplicity and pointing out the obvious.Your blog entry for is refreshing and points out that many of the database objects in RDBMS are forms of automation. I’m now a subscriber to your blog.

Leave a Reply

Your email address will not be published. Required fields are marked *