 |
BOOK: Beginning ASP.NET 4.5.1 : in C# and VB
 | This is the forum to discuss the Wrox book Beginning ASP.NET 4.5.1: in C# and VB by Imar Spaanjaars; ISBN: 978-1-118-84677-3 |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the BOOK: Beginning ASP.NET 4.5.1 : in C# and VB section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
|

October 27th, 2015, 11:37 AM
|
|
Authorized User
|
|
Join Date: Feb 2012
Posts: 22
Thanks: 0
Thanked 4 Times in 4 Posts
|
|
Solved it!
Here: http://stackoverflow.com/questions/2...iguration-tool
What I ended up doing was making a new user account without Administration privilages. (generic user) Gave this user access to database then followed the steps in 3 and 4 everything is good now. Strange how it will not work when the user is in the Administrators group.
|
|

October 28th, 2015, 03:54 AM
|
|
Registered User
|
|
Join Date: Oct 2015
Posts: 2
Thanks: 1
Thanked 0 Times in 0 Posts
|
|
Quote:
Originally Posted by Imar
|
Imar,
Thanks for you help on this. I guessed that it was a permission issue. I created another windows account without admin privileges. Running IIS from there worked. I had to share the location and give that share full control.
It's a little cumbersome let's hope MS reintroduce it on the next release of VS.
Thanks,
Dave
|
|

October 30th, 2015, 04:15 AM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
Good to hear you both figured it out.
Cheers,
Imar
|
|

November 4th, 2015, 10:11 PM
|
|
Registered User
|
|
Join Date: Oct 2015
Posts: 8
Thanks: 0
Thanked 1 Time in 1 Post
|
|
I'm still having issues. I can get the WSAT website running (by the line 989 edit posted earlier), but run into issues with the security tab.
I created a second account on Windows 10 as a local user (that does not have administrative privileges), and I was able to run WSAT through IIS Express on there. However, I receive the same error when I click on the security tab.
The folder for my website is shared and has full access by my second account.
Any other ideas or workarounds? Do I need to use the WSAT tool?
Could using MS SQL Server 2014 rather than 2012 be the issue?
Any help is appreciated.
Last edited by FittyFrank; November 4th, 2015 at 10:41 PM..
Reason: additional configuration information
|
|

November 5th, 2015, 07:07 AM
|
|
Authorized User
|
|
Join Date: Feb 2012
Posts: 22
Thanks: 0
Thanked 4 Times in 4 Posts
|
|
SQL 2014 should not be a problem. I am using SQL Express 2014 with no problems.
One quick thought did you give the new account full access to the database associated with your web site? To get mine to work I had to give read write access to the database for my generic user account. Small caveat I am using windows 7
Also I did not need to edit the file to get it to work.
|
|

November 5th, 2015, 08:39 AM
|
|
Registered User
|
|
Join Date: Oct 2015
Posts: 8
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Quote:
Originally Posted by happyandstable
One quick thought did you give the new account full access to the database associated with your web site? To get mine to work I had to give read write access to the database for my generic user account. Small caveat I am using windows 7
|
Hmm, how would I do that? When the database was created it used windows authentication and the LocalDB rather than a database on SQL Server 2014.
|
|

November 5th, 2015, 09:52 AM
|
|
Authorized User
|
|
Join Date: Feb 2012
Posts: 22
Thanks: 0
Thanked 4 Times in 4 Posts
|
|
- Open windows explorer then locate where your database.mdf files is located
- Right click on database file and choose properties
- select the Security tab then click the Advanced button
- On The Permissions tab select Continue
- ON the Advanced Security Setting for {name of your database}.mdf dialog box hit Add button
- On the Select User or Group dialog select Advanced
- in the new dialog box select eh Find Now Button
- In the Search results: window select your newly created user
- Hit OK Button
- Hit ok Button on next dialog box this will bring you to the Permission Entry dialog for your database. Select the permissions you want this user to have. then Click ok
- Now click ok on each succeeding dialog box till you are back at windows Explorer.
- You have now given permission you choose to your new user.
Hope this helps
|
|

November 5th, 2015, 09:54 AM
|
|
Authorized User
|
|
Join Date: Feb 2012
Posts: 22
Thanks: 0
Thanked 4 Times in 4 Posts
|
|
- Open windows explorer then locate where your database.mdf files is located
- Right click on database file and choose properties
- select the Security tab then click the Advanced button
- On The Permissions tab select Continue
- ON the Advanced Security Setting for {name of your database}.mdf dialog box hit Add button
- On the Select User or Group dialog select Advanced
- in the new dialog box select the Find Now Button
- In the Search results: window select your newly created user
- Hit OK Button
- Hit ok Button on next dialog box this will bring you to the Permission Entry dialog for your database. Select the permissions you want this user to have. then Click ok
- Now click ok on each succeeding dialog box till you are back at windows Explorer.
- You have now given permission you choose to your new user.
Hope this helps
|
|

November 5th, 2015, 10:27 AM
|
|
Registered User
|
|
Join Date: Oct 2015
Posts: 8
Thanks: 0
Thanked 1 Time in 1 Post
|
|
My secondary user (called Other) inherits full access from my website folder. When I click on the .mdf file security settings it has full access (everything is checked except for special privileges).
I might just try and figure it out using IIS, rather than IIS Express. I've spent a while on this, and IIS is going to be used in the production environment so it would make sense to learn that now. I just need to move the database out of localDB and into SQL Server 2014 and hopefully figure it out.
|
|

November 6th, 2015, 04:56 AM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
>> just need to move the database out of localDB and into SQL Server 2014 and hopefully figure it out.
Check Appendix B; it has all the details on how to make this work.
Imar
|
Similar Threads
|
| Thread |
Thread Starter |
Forum |
Replies |
Last Post |
| Chapter 16, Page 584 |
JHubschman |
BOOK: Beginning ASP.NET 4 : in C# and VB |
5 |
August 26th, 2011 05:56 PM |
| Chapter 16 Page 558 |
runner1181 |
BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 |
1 |
February 9th, 2010 03:18 AM |
| Chapter 1 Page 16 - Try It Out |
bradnerdhss |
BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 |
1 |
January 31st, 2006 02:11 PM |
|
 |
|