Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-17 : 16:33:19
|
Jon writes "This question pertains to ASP and SQL Server through a firewall.
As of yet I haven't seen any good articles on setting up SQL server to pass through a firewall to a web server. I am using the SQLOLEDB driver and I believe SQL Server is listening on port 1433, but I can't open a connection. Where can I check SQL Server to see which port it is listening on and how do I set up my connection string to indicate which port to use? Here is a sample of my connection string:
strConn = "Provider=SQLOLEDB; Data Source=CONTACT;" &_
"Initial Catalog=Account; User Id=web; Password=beer"
Do I just add ":1433" to the end of the Data Source? If not how do I tell the OLE DB driver which port to use for communication?
Regards,
Jon" |
|
|
|
|
|
Hey there is a firewall in my way!