Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - MSSQL Connection Problem
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

MSSQL Connection Problem
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
shickey View Drop Down
Newbie
Newbie


Joined: 05 November 2007
Status: Offline
Points: 2 		Post Options Post Options   Thanks (0) Thanks(0)   Quote shickey Quote  Post ReplyReply Direct Link To This Post Topic: MSSQL Connection Problem
    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
 


Edited by shickey - 05 November 2007 at 4:39am
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
shickey View Drop Down
Newbie
Newbie


Joined: 05 November 2007
Status: Offline
Points: 2 		Post Options Post Options   Thanks (0) Thanks(0)   Quote shickey Quote  Post ReplyReply Direct Link To This Post 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
 
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

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 at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

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