MSSQL Connection Problem
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=24752
Printed Date: 06 April 2026 at 11:58am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: MSSQL Connection Problem
Posted By: shickey
Subject: MSSQL Connection Problem
Date Posted: 05 November 2007 at 4:37am
|
Hi,
New to this. I run the MSSQL_SERVER_SETUP.ASP and keep getting the following error regardless of the username, SQL server name, password, etc. Change the database_Connection.asp file numerous times.
Using SQLEXPRESS
----------------------------
Error Connecting to database on SQL Server
Check the following is set up and correct:-
SQL Server User Name
SQL Server Password Name of the SQL Server Database name set up by you on the server Empty Database set up by you on the SQL Server Check also that you have entered the correct details in the file 'database_connection.asp' found in the 'database' directory.
Detailed Error Message:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error Details:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. ----------------------------
Any idea on what may be happening / what I need to fix this?
TIA
 |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 05 November 2007 at 9:02am
|
1. Make sure you have installed SQL Express in mixed mode with TCP/IP connections enabled 2. SQL Express installs with the default instance of SQLEXPRESS so you need to include this in the connection. For example if SQL Express is installed on the same computer as your web site use the following:- localhost/SQLEXPRESS ------------- 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: shickey
Date Posted: 06 November 2007 at 2:10am
|
Hi
Tried the localhost/SQLExpress. Uninstalled and reinstalled in Mixed mode. SQL authenticated in (not windows auth) and created database. Changed database_connection.asp to "sa" for the user name and still no luck. Turne on Pipes and TCPip and still can not connect.
Any ideas ?
TIA
|
Posted By: WebWiz-Bruce
Date Posted: 06 November 2007 at 9:05am
|
When connection to SQL Express using localhost, SQL Express needs to be all capitals as it is case sensitive:- localhost/SQLEXPRESS ------------- 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 |