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
wonderful put up, very informative. I ponder why the other experts of this sector do not realize this. You should continue your writing. I’m sure, you’ve a great readers’ base already!
Thanks for the post, was an interesting read. Curious as to how you came about that solution…
Very neat blog.Much thanks again. Really Cool.
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!
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!
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.
Very nice article, totally what I was looking
for.
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.
Hi, yes – please feel free to link up to my site.
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!
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!
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.
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!
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.
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!
Hi Carey,
Yes, feel free to quote and include links to my posts.
Peter
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 .
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.
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
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!
Hi Holly,
Please send me on your articles and I will set up a guest writer section.
Regards Peter
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.
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.
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!
Hi there, I enjoy reading through your aarticle post.
I wwanted to write a little comment too support you.
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
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?
Hi there, I enjoy reading through your article. I like to write a little
comment to support you.
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.
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.