RBS accessibility issue

Mar 14, 2010 at 3:46 PM

hi all,

We have successfully installed RBS. But now when we try to execute a query on the database (sql server 2008) of the web application, the following error is occuring.

Please let us know how to access the database in sql that has become inaccessible(it states permission issues when we try to access the db).

 

Msg 5120, Level 16, State 101, Line 3
Unable to open the physical file "d:\Blobstore". Operating system error 5: "5(Access is denied.)".
Msg 5120, Level 16, State 106, Line 3
Unable to open the physical file "d:\Blobstore". Operating system error -1073741771: "0xc0000035(failed to retrieve text for this error. Reason: 15105)".
Msg 5105, Level 16, State 14, Line 3
A file activation error occurred. The physical file name 'd:\Blobstore' may be incorrect. Diagnose and correct additional errors, and retry the operation.
Msg 945, Level 14, State 2, Line 3
Database 'WSS_Content_4444' cannot be opened

Msg 5120, Level 16, State 101, Line 3

Unable to open the physical file "d:\Blobstore". Operating system error 5: "5(Access is denied.)".

Msg 5120, Level 16, State 106, Line 3

Unable to open the physical file "d:\Blobstore". Operating system error -1073741771: "0xc0000035(failed to retrieve text for this error. Reason: 15105)".

Msg 5105, Level 16, State 14, Line 3

A file activation error occurred. The physical file name 'd:\Blobstore' may be incorrect. Diagnose and correct additional errors, and retry the operation.

Msg 945, Level 14, State 2, Line 3

Database 'WSS_Content_4444' cannot be opened

 

Thanks in advance. :)

 

Mar 15, 2010 at 8:12 PM
Edited Mar 25, 2010 at 6:12 PM

Are these errors from the errorlog? If so, the rest of the log would be helpful. Also, when you say ‘when we try to execute a query’ are you directly connecting to the database and attempting a query? What query are you trying? More info here will be useful.

 

It sounds like this might be a permissions issue. What account is the sqlservr.exe service running under, and does it have permissions to access the d:\blobstore directory?

mike