Print Page | Close Window

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
 Dead
 



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



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