Print Page | Close Window

SQL Server Install Not Working

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=31567
Printed Date: 29 March 2026 at 11:20am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: SQL Server Install Not Working
Posted By: swabygw
Subject: SQL Server Install Not Working
Date Posted: 05 September 2018 at 1:27pm
Hi, I’m doing a new installation on a new Windows server (equipped with SQL Server) and I’m getting the following error on the test database connection - see Attachment 1. Here’s my configuration (I’ve already created the database, EnterpriseInterchange, in SQL Server 2017) - see Attachment 2.
Okay, the image attachment feature isn't working correctly here...here's the error that I'm getting: "An error occurred connecting to the database.  Error details: Microsoft OLE DB Provider for ODBC Drivers. Data source name not found and no default driver specified."  In the configuration page, I specified the IP address for my server where I have my SQL Server, I created a database instance and entered the name of it in the configuration page, along with the userid and password to log in.
 



Replies:
Posted By: WebWiz-Bruce
Date Posted: 06 September 2018 at 7:40am
The error:

Data source name not found and no default driver specified.

Means that the database driver you have selected is not installed on the server.

Try selecting the alternative driver or install the missing Database driver on the web server.

Supported drivers for SQL Server are:

SQL OLE DB (SQLOLEDB)
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: swabygw
Date Posted: 06 September 2018 at 10:24am
Thanks - I installed the driver and am now receiving a 500.19 error (can't read web.config file).  I should also ask which of the following directory structures is recommended:
 
1) http://www.mydomain.com/forum - www.mydomain.com/forum - default.asp is within the forum folder
2) http://www.mydomain.com - www.mydomain.com - default.asp is at the root
 
Essentailly, should the I keep everything in the forum folder, or place everything at root?
 
Edit:  I attempted to replace the web.config file with a standard (basically empty) web.config file and was able to get back to the installation page.  From there, I was able to make a successful database connection.  However, after the database test was successful, it took me back to the first installation page (no install occurred).


Posted By: WebWiz-Bruce
Date Posted: 07 September 2018 at 10:19am
If the web.config is causing an error it means that you do not have the IIS Rewrite Module installed on the server for the rewrite rules to work. You can download it from:

https://www.iis.net/downloads/microsoft/url-rewrite" rel="nofollow - https://www.iis.net/downloads/microsoft/url-rewrite

If the setup is not competing it means the setup wizard is unable to write the configuration settings to the files in the forums 'database' folder. Make sure you enable write permissions on the forums 'database' folder.

Were you install your forum, in the website root or a sub folder makes no difference, it is a personal choice where you prefer it. 


-------------
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: swabygw
Date Posted: 07 September 2018 at 3:53pm
The url-rewrite installation did the trick.  Thanks!



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net