Cannot connect to SQLServer from localhost

[Kendel]

Hi All,

I have posted this question in ASP forum but didn't get any help. Maybe this forum could help me out.

I download a working web folder into my localhost C:\Inetpub\

http://wwwroot

When I ran it on my localhost, I got this error:
Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

at this line:
Conn1.Open "Provider=sqloledb;" & _
"Data Source=SQL01;" & _
"Initial Catalog=member;" & _
"User Id=webuser;" & _
"Password=webuserpswd"


Macromedia: DreamWeaver
Macromedia: Dreamweaver MX (UltraDev)
Macromedia: Flash
Microsoft: Active Server Pages (ASP)
Microsoft: ASP.NET
Microsoft: FrontPage
PHP
Sun: Servlets and JavaServer Pages (JSP)
Ada
C
HTML, XHTML & CSS (Cascading Style Sheets)
Javascript
Perl
VBA Visual Basic for Applications (Microsoft)
VBScript
Visual Basic(Microsoft) -VB.NET
Visual Basic(Microsoft) Databases
Visual Basic(Microsoft): Version 5 & 6
Business Objects: Crystal Reports 1 Formulas
Communications Rack
Linksys networking solutions
Wiring Closet
Cabling
Desktop Software
E-Mail issues
Trends and Strategies
Information Technology Ethics in the Workplace
Partners
"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)
Feedback
"...I have tons of books, have book marked tons of tutorials, which have helped, but this forum has answered those "impossible to find" solutions. I am thrilled with this site..."
More...
Partners
TopXML
Planet Source Code
DevGuru
ASP Alliance
Programmers Heaven
VisualBuilder.com
Developer Fusion
Code Project
Zvon - Guide to XML
Resource Index
Tek-Tips Forums

Advanced Search
Home > Forums > Programmers > Graphics & Web Tools > Microsoft: Active Server Pages (ASP) Forum
SQL Server on diff network
thread333-950381
Forum Search FAQs Links
Read
New Posts Reply To
This Thread
E-mail It
Print It Next
Thread
Kendel (Programmer) Nov 11, 2004
Hi All,

I download a working web folder into my localhost C:\Inetpub\

http://wwwroot

I got this error:
Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

at this line:
Conn1.Open "Provider=sqloledb;" & _
"Data Source=SQL01;" & _
"Initial Catalog=member;" & _
"User Id=webuser;" & _
"Password=webuserpswd"

Even if I replaced the Server name with IP address, I still got the same error.

The SQLServer is running behind the firewall.

When I go to its URL, it works just find but when I run it on my localhost, I can't connect to SQServer.

Does anyone have a solution for this? Thanks a bunch.

 

[Kendel]

I'm sorry for the copy & paste errors.

Here is my question again:

Hi All,

I have posted this question in ASP forum but didn't get any help. Maybe this forum could help me out.

I download a working web folder into my localhost C:\Inetpub\

http://wwwroot

When I ran it on my localhost, I got this error:
Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

at this line:
Conn1.Open "Provider=sqloledb;" & _
"Data Source=SQL01;" & _
"Initial Catalog=member;" & _
"User Id=webuser;" & _
"Password=webuserpswd"

Even if I replaced the Server name with IP address, I still got the same error.

The SQLServer is running behind the firewall.

When I go to its URL, it works just find but when I run it on my localhost, I can't connect to SQServer.

Does anyone have a solution for this? Thanks a bunch.

 

[SQLSister]

I'd think it was most likely a firewall issue, perhaps the port that SQL server is using is blocked.

Questions about posting. See faq183-874

 

[Kendel]

Thanks for your help SQLSister!
If it is firewall issue, what I can I do to resolve it? How could I find outthe port number for that SQLServer? If I knew that port#, how could I open it?

 

[mrdenny]

The SQL Server is listing on port 1433. You will need to check with your firewall vendor on how to open the port.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[Kendel]

Thank you all!