|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
August 30th, 2004, 02:44 AM
|
|||
|
|||
Need help in Configuring ISA server to publish SQL server 2000 to web
Hi!
We want to publish some data from our intranet application to the web. I created a simple connection string within a ASP page which is located on a remote web hosting server: Set conn = Server.CreateObject("ADODB.Connection") conn.Open "Provider=SQLOLEDB;Persist Security Info=False;Data Source=xxx.xxx.xxx.xxx;Initial Catalog=Northwind;Network Library=dbmssocn;UID=sa;PWD=xxxxx;" but unfortunately it gives me this error message Microsoft OLE DB Provider for SQL Server (0x80004005) [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. ---> I already configured our ISA server to listen to port 1433, but still dont work. Do I still need to configure SQL server? Help pleaseeeeeee, thankss
|
|
#2
August 30th, 2004, 11:12 AM
|
|||
|
|||
|
Maybe you have some other firewall blocking port 1433, or you really didn't get that port open in ISA server.
__________________
====== Doug G ====== I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > Need help in Configuring ISA server to publish SQL server 2000 to web |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
