Web Wiz Forums - SSL security error with database connection

Print Page | Close Window

SSL security error with database connection

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=31472
Printed Date: 29 March 2026 at 2:07pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SSL security error with database connection

Posted By: MPIDR
Subject: SSL security error with database connection
Date Posted: 20 April 2017 at 2:00pm

Dear Web Wiz Forum folks,

We are new to Web Wiz Forum and just about to set up our first forum. IIS is 8.5 on Win2012R2 with the SQL server native client 11.0 installed. The SQL server is 2008 R2 including all patches for TLS 1.2. Creating an ODBC connection from the webserver to the WWZ database using the SQL native driver works fine and the tests completes successfully. This was done for testing only.

However, when running the WWZ installation wizard and using the same database, the connection tests fails with an SSL security error.

An Error Occurred Connecting to the Database

Error details:-
Microsoft OLE DB Provider for SQL Server
[DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error.

Is there a solution to this?

Regards,

MPIDR

Replies:

Posted By: WebWiz-Bruce
Date Posted: 20 April 2017 at 2:39pm

This is likely related to the SQL Server databases driver as Web Wiz Forums uses the 'SQLOLEDB' driver for the database connection.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: WebWiz-Bruce
Date Posted: 20 April 2017 at 2:45pm

I have had a look and you can change the driver from SQLOLEDB to SQL Server Native Client 11.0 by editing line 89 of the file database/database_connection.asp and change it from

Provider=SQLOLEDB;

to

Provider=SQL Server Native Client 11.0;

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: MPIDR
Date Posted: 26 April 2017 at 9:45am

Dear Bruce,

Thank you very much for your reply!

I made the changes today and noticed that I also had to change it in two more files:

setup_db_con_test.asp (line 166)

setup_database_connection.asp (line 168)

With these changes, setting up the database works well.

Regards,

MPIDR

Posted By: WebWiz-Bruce
Date Posted: 26 April 2017 at 11:41am

Glad to hear that it worked.

We will look at adding an option of selecting the database driver for SQL Server for future releases.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting