Can we connect to SQL server 2000 through Internet using a static IP?

Dear All,
Can we connect to SQL Server 2000 through internet using static ip?
We have a static IP in our office and we would like one of our customer to
connect to our database using this static IP. Is this possible?
Regards,
Peri> Can we connect to SQL Server 2000 through internet using static ip?
> We have a static IP in our office and we would like one of our customer to
> connect to our database using this static IP. Is this possible?
Yes, but typically not recommended. Without a firewall in place explicitly
allowing that specific IP in, your database is exposed to everyone on the
Internet.
So, the question on my mind is, have you tried it?
A|||Thanks a lot.
But can you please tell me which port should I open?
Regards,
Peri
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:uXu0vpemGHA.2316@.TK2MSFTNGP04.phx.gbl...
> Peri wrote:
> Certainly possible, but use extreme caution. Doing this will require an
> open port through your firewall. Opening that port will expose your
> server to the outside world. I would HIGHLY recommend configuring a
> firewall rule to allow ONLY connections from your customer's IP to connect
> to the newly opened port. Get your network people involved to make sure
> this is done securely.

Can we connect to SQL server 2000 through Internet using a static

Peri wrote:
> Dear All,
> Can we connect to SQL Server 2000 through internet using static ip?
> We have a static IP in our office and we would like one of our customer to
> connect to our database using this static IP. Is this possible?
> Regards,
> Peri
>
Certainly possible, but use extreme caution. Doing this will require an
open port through your firewall. Opening that port will expose your
server to the outside world. I would HIGHLY recommend configuring a
firewall rule to allow ONLY connections from your customer's IP to
connect to the newly opened port. Get your network people involved to
make sure this is done securely.Peri wrote:
> Thanks a lot.
> But can you please tell me which port should I open?
> Regards,
> Peri
>
Unless you changed it during the SQL Server install, it's the default
port 1433. Confirm with "netstat -a" at the command prompt.

Can RS E-mail sent through Internet?

As mentioned in the title, can RS sent subscribed report using external SMTP
Server , for example, Gmail, to a subscriber in another e-mail (for example,
someone@.yahoo.com) over the Internet?
ThanksAbsolutely.
Take a look at Reporting Services books online and search on SMTP, there are
a number of options open to you.
The trick is to pass through the security info to logon to the SMTP gmail
server.
--
Tony Rogerson
SQL Server MVP
http://www.sqlserverfaq.com?mbr=21
(Create your own groups, Forum, FAQ's and a ton more)

Can Report Manager be accessed as an Internet application?

Is Report Manager designed to be accessed over the Internet, and if so, is
there a forms based login that can be enabled?
-- Chris, SSSIhttp://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3
"Chris G." wrote:
> Is Report Manager designed to be accessed over the Internet, and if so, is
> there a forms based login that can be enabled?
> -- Chris, SSSI|||Mark,
Will that sample run against 2005 Reporting Services with little or no
modification?
-- Chris, SSSI
"Mark" wrote:
> http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3
> "Chris G." wrote:
> > Is Report Manager designed to be accessed over the Internet, and if so, is
> > there a forms based login that can be enabled?
> >
> > -- Chris, SSSI|||I couldn't say, to be honest. I was never even able to get it working with
2000, although that doesn't mean you'd have the same luck (or lack thereof).
If this doesn't work with 2005, then I'm pretty sure there must be resources
online--by Microsoft or somebody else--for implementing the forms
authentication custom extension.
Hope this helps,
Mark
"Chris G." wrote:
> Mark,
> Will that sample run against 2005 Reporting Services with little or no
> modification?
> -- Chris, SSSI
>
> "Mark" wrote:
> > http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3
> >
> > "Chris G." wrote:
> >
> > > Is Report Manager designed to be accessed over the Internet, and if so, is
> > > there a forms based login that can be enabled?
> > >
> > > -- Chris, SSSI|||Hi Chris,
Thank you for you post and thanks Marks' help.
In the SQL Server 2005 Books online, there is a section about the Forms
Authentication in Reporting Services 2005.
Authentication in Reporting Services
http://msdn2.microsoft.com/en-us/library/ms152899.aspx
Also there is a sample in the SQL Server if you install the samples.
Security Extension Sample
http://msdn2.microsoft.com/en-us/library/ms160724.aspx
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.