Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
MS SQL can't connect
Posted on 2015-02-08
HI,
I had a server crash, and am trying to restore a classic ASP web application using an MS SQL 2008 Express database instance.
I successfully have the data tables and all intact records recovered in a new PC, with a new MS SQL installation.
The problem is, my connection file in the ASP application can no longer connect. On my login page I get:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/Connections/mande2.asp, line 20
My current connect string is:
I have a few questions, assuming that I've set up the correct user, assigned that user owner permissions on the restored database, and the user part of this is correct:
1. How do I tell if my MS SQL Server instance is "serving" to the outside world?
2. If I change the data source info from "localhost" to my actual server name and MS SQL instance "SERVER\SQLEXPRESS" the behavior changes. Instead of the error message, the page just loads forever when accessing the database from an ASP page on the site. Is this a clue of some kind? If I name this anything else (localhost, dilbert, etc) I get the error message from above.
3. Any other suggestions for checking the functionality of my new database instance and getting it reconnected?
Thank you
Bill
I had a server crash, and am trying to restore a classic ASP web application using an MS SQL 2008 Express database instance.
I successfully have the data tables and all intact records recovered in a new PC, with a new MS SQL installation.
The problem is, my connection file in the ASP application can no longer connect. On my login page I get:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/Connections/mande2.asp, line 20
My current connect string is:
MM_mande_STRING="Provider=SQLOLEDB;Data Source=localhost;UID=username; PWD=mypassword; database=database_name;"
I have a few questions, assuming that I've set up the correct user, assigned that user owner permissions on the restored database, and the user part of this is correct:
1. How do I tell if my MS SQL Server instance is "serving" to the outside world?
2. If I change the data source info from "localhost" to my actual server name and MS SQL instance "SERVER\SQLEXPRESS" the behavior changes. Instead of the error message, the page just loads forever when accessing the database from an ASP page on the site. Is this a clue of some kind? If I name this anything else (localhost, dilbert, etc) I get the error message from above.
3. Any other suggestions for checking the functionality of my new database instance and getting it reconnected?
Thank you
Bill
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
3 Comments
Active today
Question 1: Determining if your db server is listening to the outside world:
Yes, that is a big clue. If your web application is not on the same server as your SQL database, then localhost will not work. If indeed they are separate, then you have to specify the actual server name or IP address of the SQL server.
As for the long-running of the page, is it possible you have a long-running query? Are you doing any error trapping for SqlExceptions? What version of ASP?
Question 3: Additional suggestions
Try opening the SQL management studio using the same username and password you specified in your string. See if that gives you a better error message.
1.
Go to the Windows menu --> Microsoft Sql Server 2008 --> Configuration Tools --> Sql Server Configuration Manager2.
Drill down on Sql Server Network Configuration --> Protocols for <your instance here>3.
Double-click on TCP/IP in the right-hand pane4.
Make sure enabled is set to "Yes"5.
Click on the "IP Addresses" tab and find the IP address of the server in the list6.
Make note of the TCP Port being used (default is 1433). If it's not the default, your connection string needs to reflect that by using a :#### after the server name in the string (#### = the TCP port)7.
Make sure the Windows firewall is permitting the specified TCP port inbound8.
Make sure your internet firewall is permitting the specified TCP port inbound for only the IP address of your web serverQuestion 2: Response as a clueYes, that is a big clue. If your web application is not on the same server as your SQL database, then localhost will not work. If indeed they are separate, then you have to specify the actual server name or IP address of the SQL server.
As for the long-running of the page, is it possible you have a long-running query? Are you doing any error trapping for SqlExceptions? What version of ASP?
Question 3: Additional suggestions
Try opening the SQL management studio using the same username and password you specified in your string. See if that gives you a better error message.
Thanks for your time. The SQLEXPRESS was the correct name. I was having unrelated SSL certificate issues causing the rest of that delay.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
The reason that corporations and businesses use Windows servers is because it supports custom modifications to adapt to the business and what it needs. Most individual users won’t need such powerful options. Here I’ll explain how you can enable Wind…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…
In this Micro Tutorial viewers will learn how to restore single file or folder from Bare Metal backup image of their system. Tutorial shows how to restore files and folders from system backup. Often it is not needed to restore entire system when onl…
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs.
Launch Data Protection Manager from the deskt…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month4 days, 8 hours left to enroll
635 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.