[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Microsoft OLE DB Provider for SQL Server error '80004005'  unable to connect remotely to database

Posted on 2004-10-22
7
Medium Priority
?
3,040 Views
Last Modified: 2009-06-24
Dear experts,
I have an ASP file on a webserver that needs to connects to a database server remotely. But for some reason it doesn't allow me to do so. I know it is not the database server problem because I tried connecting to it with another computer and IT WORKS data comes out. I tried using a DSN connection on the web server and "TESTS COMPLETED SUCCESSFULLY", but I still cant' get the data to come up on my ASP page.


the error on the ASP page is
Microsoft OLE DB Provider for SQL Server error '80004005'
 "client unable to establish connection"

 I've also tried directly connecting to SQL server which still doesnt' work.

the error on the ASP page is
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNMPNTW]Access denied.


 I'm pretty sure that it is the web server restricting access but don't know how to unenable it. Any suggestions would be appreciated. I'm on a company network. Is this a problem? I'm getting desperate on this one.

Peter
0
Comment
Question by:tienluong
[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
7 Comments
 
LVL 19

Expert Comment

by:drichards
ID: 12387026
Is your SQL Server set up for "Windows ony" authentication?
0
 
LVL 12

Expert Comment

by:Bob Lamberson
ID: 12391842
0
 
LVL 1

Expert Comment

by:RonaldKunenborg
ID: 12399832
I suggest you take a look at the SQL server setup, just as drichards said. I had the exact same problem.
This is caused by the webserver trying to use the account under which the webserver is running to access the database. This account usually has NO permission to access the database.

To solve it, set up SQL server to allow access by using accountname/password login.

Also, if you are already using this way to access the database, try writing the connect statement anew. Maybe you overlooked a space or quote somewhere?

Good luck,
Ronald.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Expert Comment

by:dileedil
ID: 12402995
Dim connection

set connection=Server.CreateObject("ADODB.Connection")
connection.ConnectionString = "Provider=SQLOLEDB; Data Source=SourceName; Initial Catalog=CatalogName; User ID=sa; Password="
connection.open

Try to set Connecting String like this , This is a solution for you,
Thanks
0
 
LVL 1

Expert Comment

by:RonaldKunenborg
ID: 12437210
Hi TienLuong,

if you answered the question, please share your answer with us so we may benefit in the future. The answers given above are the most straightforward ones, so if you have a really different problem your answer may help someone in the future.

Regards,
- Ronald.
0
 

Accepted Solution

by:
PashaMod earned 0 total points
ID: 12464605
Closed, no points refunded.
PashaMod
Community Support Moderator
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
The SignAloud Glove is capable of translating American Sign Language signs into text and audio.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Introduction to Processes

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question