Default User
Guest
|
 Posted:
Sat Jan 15, 2005 8:13 am Post subject:
Connection to SQL Server problems |
|
|
Hello,
I have a remote/offsite website that is failing to establish a SQL database
connection to my Small Business Server 2003.
Our firewall has a rule set that allows full access of all ports to pass
to/from the website IP.
We do not have ISA installed, and there is only one NIC on our SBS2003.
My main question;
1. Does the Small Business Server 2003 have some sort of firewall or basic
access rules that I am not aware of?
Many thanks for any help or where I should be looking!!!!
PS; Here is the asp code used to connect if that helps?:
Dim conn
Set conn = Server.CreateObject( "ADODB.Connection" )
conn.Open "Provider=sqloledb;" & _
"Network Library=DBMSSOCN;" & _
"Data Source=the-The-IP-Address\ABCDSQL,1433;" & _
"Initial Catalog=ABCD-DB;" & _
"User ID=username;" & _
"Password=password"
dim sql
sql = "SELECT * FROM tblJobInfo"
set rs = Server.CreateObject("ADODB.RecordSet")
rs.Open sql, conn
response.write(rs("LastName") & "<BR>") |
|
SuperGumby [SBS MVP]
Guest
|
| Posted:
Sun Jan 16, 2005 7:41 am Post subject:
Re: Connection to SQL Server problems |
|
|
you probably need to _forward_ port 1433 from your firewall to the SBS,
'allowing' the traffic may not be enough.
Before you do this CONSIDER THE SECURITY CONSEQUENCES. If your firewall
allows you to specify that _ONLY_ the webserver can connect to this port,
I'm SORTTA OK with it. If you cannot control which remote hosts are able to
connect then the forward would be SHEER LUNACY.
If you had a second NIC and ISA you would be able to control which remotes
can connect.
"Default User" <sorry@nospam.net> wrote in message
news:yaGdncqo37Wm4XXcRVn-3g@comcast.com...
| Quote: | Hello,
I have a remote/offsite website that is failing to establish a SQL
database connection to my Small Business Server 2003.
Our firewall has a rule set that allows full access of all ports to pass
to/from the website IP.
We do not have ISA installed, and there is only one NIC on our SBS2003.
My main question;
1. Does the Small Business Server 2003 have some sort of firewall or basic
access rules that I am not aware of?
Many thanks for any help or where I should be looking!!!!
PS; Here is the asp code used to connect if that helps?:
Dim conn
Set conn = Server.CreateObject( "ADODB.Connection" )
conn.Open "Provider=sqloledb;" & _
"Network Library=DBMSSOCN;" & _
"Data Source=the-The-IP-Address\ABCDSQL,1433;" & _
"Initial Catalog=ABCD-DB;" & _
"User ID=username;" & _
"Password=password"
dim sql
sql = "SELECT * FROM tblJobInfo"
set rs = Server.CreateObject("ADODB.RecordSet")
rs.Open sql, conn
response.write(rs("LastName") & "<BR>")
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in