Chapter 13 - operating system error 5: "5(access is denied.)" for Planet Wrox DB

[email protected] · March 25th, 2015, 01:09 PM

Hi Imar,

I really love the book and I've got as far as Chapter 13 without running into any problems that I couldn't solve.

In the Try It Out on p444, step 6, I get an error accessing the database from VS (it's fine from SSMS) - I get 'operating system error 5: "5(access is denied.)"'. I've done everything I can think of to solve it - I've changed the access permissions on the entire path to allow Authenticated Users. I've checked the web.config and it's identical to the one in the downloaded source code. I've deleted and recreated the connection and the DB (using the SQL file from the Resources folder).

The only thing that I can think of (because it's the only part of your instructions that I couldn't follow correctly) is that it might be something to do with being unable to log into SSMS as (LocalDB)\v11.0 (p411, TIO step 3). This option isn't offered any more - the only option available is MAIN-PC\SQLEXPRESS.

In case it matters, I'm running VS Express 2013 on a Windows 8.1 laptop.

It would be great if you could help, please, as I would love to be able to finish the book.

All the best,

Louise

Imar · March 25th, 2015, 01:11 PM

>> This option isn't offered any more - the only option available is MAIN-PC\SQLEXPRESS.

Can you try typing it in directly? The drop down just shows recent entries.

Imar

[email protected] · March 25th, 2015, 01:26 PM

Hi Imar,

Thank you so much for the quick reply. I've tried it (I thought I had already but obviously not) and I can type (LocalDB) etc. in. It will take me a little while to check if it solves everything because windows is not letting me delete the old DBs without a reboot (and I have to go and collect my baby from nursery now), but I'll work through it and let you know.

All the best,

Louise

[email protected] · March 25th, 2015, 06:21 PM

Hi Imar,

Thank you so much for your quick response - it's all sorted and working now. I checked the text on p411 and it does say enter (LocalDB)\v11.0 - I just misread it.

I really appreciate your help and I'm looking forward to finishing the rest of the book now.

All the best,

Louise

Imar · March 28th, 2015, 07:02 PM

Good to hear, and thanks for the follow up.

Cheers,

Imar