Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - HTTP Error 500.19 - 0x8007000d
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

HTTP Error 500.19 - 0x8007000d

 Post Reply Post Reply Page  123>
Author
WizzRa View Drop Down
Newbie
Newbie


Joined: 06 March 2020
Location: UK
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote WizzRa Quote  Post ReplyReply Direct Link To This Post Topic: HTTP Error 500.19 - 0x8007000d
    Posted: 06 March 2020 at 4:46pm
Testing the forum software on a Window Server 2016 virtual machine.

Having the above error.
The instructions (whilst not very detailed) state to make sure IIS is installed with ASP classic which I;ve done.

Also set the IIS user to have modify rights on the database folder.

Are there any other settings that need to be enabled in IIS?

If I copy the file to Azure Application service, the forum setup works fine so it cannot be an issue with the file web.config file as per the error message and I miust be missing an IIS setting that's not mentioned in the guide.

Appreciate any assistance.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9611
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 06 March 2020 at 4:49pm
Error looks to relate to the URL Rewrite Rules in the web.config file.

Install the IIS URL Rewrite module on the server and it should fix the error for you.

You can download it from the page below;

Back to Top
WizzRa View Drop Down
Newbie
Newbie


Joined: 06 March 2020
Location: UK
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote WizzRa Quote  Post ReplyReply Direct Link To This Post Posted: 06 March 2020 at 4:54pm
Originally posted by WebWiz-Bruce WebWiz-Bruce wrote:

Error looks to relate to the URL Rewrite Rules in the web.config file.

Install the IIS URL Rewrite module on the server and it should fix the error for you.

You can download it from the page below;

https://www.iis.net/downloads/microsoft/-re - https://www.iis.net/downloads/microsoft/url-rewrite

Awesome fella !!

That fixed it ... and thanks very much for the quick reply!

Did I miss that instruction anywhere?. Swear I never say it published.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9611
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 06 March 2020 at 5:03pm
The web.config file with the URL rewrite rules use to be a separate download, but as most servers already have URL Rewrite installed it is now included in the main download.

The documentation needs to be updated in case there are people like yourself that might not have installed it.

Not sure why Microsoft don'y include URL Rewrite as a built in module. As it is something that everyone installs as almost every website and application uses it.
Back to Top
WizzRa View Drop Down
Newbie
Newbie


Joined: 06 March 2020
Location: UK
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote WizzRa Quote  Post ReplyReply Direct Link To This Post Posted: 06 March 2020 at 5:14pm
Understood ... thanks for the assistance !
Back to Top
WizzRa View Drop Down
Newbie
Newbie


Joined: 06 March 2020
Location: UK
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote WizzRa Quote  Post ReplyReply Direct Link To This Post Posted: 07 March 2020 at 8:52am
Sir Bruce .... perhaps you can help with one more thing, connection to the DB.

During setup, there is an extra option compared to the guide screenshot, The SQL database driver option.

I have another VM with SQL server 2017 installed.
Installed the MDAC on the web server VM.
Created a blank DB with the name "webwizforum".

Selecting the native client v11 option produces "adodb.connection provider cannot be found" errors.
Selecting the OLE DB option produces "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."

The SA account is disabled by default on installation.
Created another database account but not sure what permissions are required or if there are other missing packages that are not mentioned?

Any ideas please?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9611
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 09 March 2020 at 7:52am
The error means the database driver is not installed on the web server, select the other database driver, or install the 'SQL Server Driver SQL Server Native Client 11.0' on the web server.
Back to Top
WizzRa View Drop Down
Newbie
Newbie


Joined: 06 March 2020
Location: UK
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote WizzRa Quote  Post ReplyReply Direct Link To This Post Posted: 10 March 2020 at 11:52am
Installed the DB driver on the Web VM.

Had an error for Named Pipes. Therefore enabled that and TCP/IP settings in Config Mgr but still had same error. Realised a Win FW rule was not created for SQL server on install so created that and did a telnet test to port 1433 which partially resolves the connection bit.

It appears the authentication is now as issue.
The DB name is "WebWizForums"
Trying to give the SA user DB Owner rights fails.
Creating a new DB user called "WebWiz" allows me to make it DB owner but not sure what else is needed.

I'm going to spin up another VM with SQL Express to see if that works and figure out what user settings it uses .... unless you can advise what steps are needed for a new DB user to authentgicate to a fresh DB which I can try to replicate?

Cheers 
Back to Top
 Post Reply Post Reply Page  123>
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.


Become a Fan on Facebook Follow us on Twitter Connect with us on LinkedIn Community Forums Web Wiz Blogs Web Wiz News
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2020 Web Wiz Ltd. All rights reserved.