Re: Re:Connection

Hi T.Mthimkulu,

Thank you for your update.

Now, I know you host a web site on your ISP. The web site need to connect a
SQL server database. You want to know you'd better host the SQL server on
your SBS or ISP.

The answer is ISP. You need to host the SQL server in ISP together with the
web site. It is safer and faster.

If you host the SQL server on your SBS, you need to publish the SQL server
to Internet, and make the web site to access the published SQL server. It
is very dangerous for the SQL server. Everyone in the Internet could try to
access it. Meanwhile, SQL server access thru Internet is very slow, and
often disconnected.

Therefore, you need to host the SQL server on the ISP, together with your
web site.

I hope these will give you some help.

Thanks and have a nice day!

Best regards,

Terence Liu (MSFT)

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security

=====================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
From: "T.Mthimkulu" <tia.mthimkulu@xxxxxxxxxxxxxxxx>
References: <e2Fr1qP4IHA.776@xxxxxxxxxxxxxxxxxxxx>
<uxIueaQ4IHA.4776@xxxxxxxxxxxxxxxxxxxx>
<evg3GJR4IHA.4988@xxxxxxxxxxxxxxxxxxxx>
<NZclHzW4IHA.4056@xxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: Re:Connection
Date: Wed, 9 Jul 2008 10:06:07 +0100
Lines: 132
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
Message-ID: <OlF8IMa4IHA.4340@xxxxxxxxxxxxxxxxxxxx>
Newsgroups: microsoft.public.windows.server.sbs
NNTP-Posting-Host: host81-130-202-78.in-addr.btopenworld.com 81.130.202.78
Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP06.phx.gbl
Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:114514
X-Tomcat-NG: microsoft.public.windows.server.sbs

Hi Terence Liu,

Ok,thanks for letting me know,as I am getting to grips with this
application.

Yes,we run an SBS 2003 premium which has 2 NICs.One runs externally
through
an ADSL modem router and another one is on the internal network.We are
interested in accessing the SQL server database.

Servlets are java programs that are used to service clients ,by taking
client requests and sending back responses.

I would like to know what you would recommend as the best form of
communication from a website (which is hosted by an ISP) to a
database.Would
the information have to be stored on the web/ISP's space,or on a SBS?

Thanks

T.Mthimkulu

"Terence Liu [MSFT]" <v-terliu@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:NZclHzW4IHA.4056@xxxxxxxxxxxxxxxxxxxxxxxxx
Hello T.Mthimkulu,

Thank you for posting here. Let's also thank Steve for the input.

First, I would like to let you know we do not recommend customer to
create
multiple duplicate posts for single issue. However I will do my best to
be
of assistance if you still want to work this issue here.

Before we go any further, please let me know the following information so
that we can understand your situation more clearly.

1. Do you run SBS 2000 or 2003? Do you run premium or standard edition?
Do
you have single NIC or double on SBS?

2. What is servlets?

3. Do you have router or firewall at upstream the SBS?

3. What service on SBS do you want to access?

4. The website is a remote server out of your network. Am I right?

I appreciate your time and look forward to hearing from you.

Thanks and have a nice day!

Best regards,

Terence Liu (MSFT)

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security

=====================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the
corresponding
newsgroups so that they can be resolved in an efficient and timely
manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check
the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In
doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no
rights.

--------------------
From: "T.Mthimkulu" <tia.mthimkulu@xxxxxxxxxxxxxxxx>
References: <e2Fr1qP4IHA.776@xxxxxxxxxxxxxxxxxxxx>
<uxIueaQ4IHA.4776@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: Re:Connection
Date: Tue, 8 Jul 2008 16:49:58 +0100
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
Message-ID: <evg3GJR4IHA.4988@xxxxxxxxxxxxxxxxxxxx>
Newsgroups: microsoft.public.windows.server.sbs
NNTP-Posting-Host: host81-130-202-78.in-addr.btopenworld.com
81.130.202.78
Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl
Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:114411
X-Tomcat-NG: microsoft.public.windows.server.sbs

P.S.This is a remote server.

"SteveB" <newsgroup@xxxxxxxxxx> wrote in message
news:uxIueaQ4IHA.4776@xxxxxxxxxxxxxxxxxxxxxxx
No need to start 2 threads on this. See the reply from Lanwench in your
other thread.

"T.Mthimkulu" <tia.mthimkulu@xxxxxxxxxxxxxxxx> wrote in message
news:e2Fr1qP4IHA.776@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

Would I be able to connect from a website to a small business server
by
using servlets?If I did,what parameters would I have to declare in
order
to initialise the connection?

Thanks













.

Relevant Pages

  • RE: Management Point not available
    ... > configured the Default Web Site within IIS 6 to use port 8080. ... Manually restart the SMS Agent Host service on the MP. ... MP encountered an error when connecting to SQL Server. ... If using a standard SQL security account, ...
    (microsoft.public.sms.admin)
  • desperately needing help with a Server Error
    ... i know NOTHING about sql server, .net framework or probably anything ... this is NOT a problem with the web site. ... i tripped on to this board from access monster and thought it ... *** i posed this on sql server monster as well, not knowing if here or there ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SQL Connection String using Domain Account
    ... Web.Config but now have the problem that the web site will not run under ... you can have a username/password set up in sql server - but this would ... The DBA has given me a Domain user account with rights to ... I am unable to get a connection to the database. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Securing a web DB
    ... > We are putting up a ASP.NET based web site using SQL Server database. ... > We are planning to host the site with as ISP. ...
    (comp.security.misc)
  • Re: Using SQL on Development Machine
    ... It would require that the ISP permit you to install your database into their instance of SQL Server. ... Would you connect to the host instance in the same way as you connect to your local SQL Server instance? ... you start with getting to know more about your ISP and the engine(s) they support and installing the target engine on your development system. ...
    (microsoft.public.dotnet.framework.adonet)