Re: FSO/firewall question

From: x y (jamescagney90210@excite.com)
Date: 10/02/02 

From: "x y" <jamescagney90210@excite.com>
Date: Wed, 2 Oct 2002 10:04:30 -0400

For any such firewall question, you can always try the operation and then
check the firewall logs to see what ports were used / blocked.

"Baki" <bobradovic2001@yahoo.com> wrote in message
news:uuYyRaUaCHA.1856@tkmsftngp11...
> Hi Ken,
> I didn't mean to store files in SQL Server using FSO, but to store files
> (simple fso.Copy) on the server where SQL Server is installed!
> Thanks anyway,
> Regards,
> Baki
> "Ken Schaefer" <kenRMV@THISadOpenStatic.com> wrote in message
> news:#mowWgEaCHA.2616@tkmsftngp09...
> > You can not access your database server using FSO. FSO is for file
system
> > manipulation. You need to use a data access technology (eg ADO+OLEDB,
> SQLDMO
> > etc) to connect to SQL Server.
> >
> > If you want to insert a file into your SQL Server, you can use ADO, and
> this
> > will work via TCP port 1433
> >
> > That said, storing binary/BLOB data in SQL Server probably isn't the
best
> > use of resources...
> >
> > Cheers
> > Ken
> >
> > --
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > "Baki" <bobradovic2001@yahoo.com> wrote in message
> > news:#WwOcVmZCHA.1860@tkmsftngp12...
> > > Hi guys,
> > > we have following standard configuration:
> > > * external firewall (TCP 80, 25, 21)
> > > * web server, ftp server (IIS 5.0), standalone server
> > > * internal firewall (TCP 1433)
> > > * database server (SQL Server 2000), member of AD
> > > We also have web application (on IIS) that works fine. Meanwhile we
> > started
> > > collecting files on our FTP server. We want to store those files on
> > database
> > > server using FSO, from our web application. In order to do that, what
> TCP
> > > ports do we have to open on internal firewall? Wouldn't security be
> > > jeopardized? What can we implement as an alternative solution (maybe
FTP
> > > upload from application -iis to db-server?)
> > > Thanks in advance,
> > > Baki
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Deploying ASP.NET Application
    ... I think this is not about firewall port blocking, ... > SQL Server does not exist or access denied. ... deployed on that server - it has something to do with ports on the firewall ... environment to our production environment. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cant replicate between two servers
    ... yes i check to ports in the firewall and it's all opened ... Ping only ... > appropriate permissions to access SQL Server and of course, the ports must ...
    (microsoft.public.sqlserver.replication)
  • Re: Can SQL be told to stop listening on specific IPs on its computer ?
    ... ports on the firewall or in packet filtering on the OS network control ... >> In terms of the IPs and the web addresses, ... >> and SQL Server installed on the same server? ... >>>to tell SQL server what IPs and ports to listen on. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server Specific Windows Firewall Exception
    ... their network (and I'm not talking ZoneAlarm, McAfee Personal Firewall, here. ... Microsoft don't have a problem with it considering the exceptions ... Windows Firewall to enable remote access and administration to a SQL Server ... So, if we put aside the whole automatic open ports distraction, wouldn't it ...
    (microsoft.public.sqlserver.connect)
  • Re: Do I need a firewall
    ... >>> One way to see if your SQL server is exposed is to open the Query ... I see quite a few ports are open. ... Will a software firewall such as Zone Alarm ...
    (comp.security.firewalls)