Can I connect to SQL Server via PPPoE?

I am a fresh guy for networking and here is a question seeking help.
If SQL Server was located in internet and i use a PPPoE (ADSL) line to
connect to internet, can I connect to SQL Server via PPPoE?
Thanks a lot.
Hi
Yes. As long as you use the IP address, your routing is correct and you have
the correct ports open. The default port for SQL Server is 1433.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<stevegao2003@.163.com> wrote in message
news:1135330289.992162.176130@.g43g2000cwa.googlegr oups.com...
> I am a fresh guy for networking and here is a question seeking help.
> If SQL Server was located in internet and i use a PPPoE (ADSL) line to
> connect to internet, can I connect to SQL Server via PPPoE?
> Thanks a lot.
>
|||Thanks.
Mike Epprecht (SQL MVP) wrote:[vbcol=seagreen]
> Hi
> Yes. As long as you use the IP address, your routing is correct and you have
> the correct ports open. The default port for SQL Server is 1433.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> <stevegao2003@.163.com> wrote in message
> news:1135330289.992162.176130@.g43g2000cwa.googlegr oups.com...

Can I connect to SQL Server via PPPoE?

I am a fresh guy for networking and here is a question seeking help.
If SQL Server was located in internet and i use a PPPoE (ADSL) line to
connect to internet, can I connect to SQL Server via PPPoE?
Thanks a lot.Hi
Yes. As long as you use the IP address, your routing is correct and you have
the correct ports open. The default port for SQL Server is 1433.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<stevegao2003@.163.com> wrote in message
news:1135330289.992162.176130@.g43g2000cwa.googlegroups.com...
> I am a fresh guy for networking and here is a question seeking help.
> If SQL Server was located in internet and i use a PPPoE (ADSL) line to
> connect to internet, can I connect to SQL Server via PPPoE?
> Thanks a lot.
>|||Thanks.
Mike Epprecht (SQL MVP) wrote:
> Hi
> Yes. As long as you use the IP address, your routing is correct and you have
> the correct ports open. The default port for SQL Server is 1433.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> <stevegao2003@.163.com> wrote in message
> news:1135330289.992162.176130@.g43g2000cwa.googlegroups.com...
> >
> > I am a fresh guy for networking and here is a question seeking help.
> >
> > If SQL Server was located in internet and i use a PPPoE (ADSL) line to
> > connect to internet, can I connect to SQL Server via PPPoE?
> >
> > Thanks a lot.
> >

Can I connect to SQL Server via PPPoE?

I am a fresh guy for networking and here is a question seeking help.
If SQL Server was located in internet and i use a PPPoE (ADSL) line to
connect to internet, can I connect to SQL Server via PPPoE?
Thanks a lot.Hi
Yes. As long as you use the IP address, your routing is correct and you have
the correct ports open. The default port for SQL Server is 1433.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<stevegao2003@.163.com> wrote in message
news:1135330289.992162.176130@.g43g2000cwa.googlegroups.com...
> I am a fresh guy for networking and here is a question seeking help.
> If SQL Server was located in internet and i use a PPPoE (ADSL) line to
> connect to internet, can I connect to SQL Server via PPPoE?
> Thanks a lot.
>|||Thanks.
Mike Epprecht (SQL MVP) wrote:[vbcol=seagreen]
> Hi
> Yes. As long as you use the IP address, your routing is correct and you ha
ve
> the correct ports open. The default port for SQL Server is 1433.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> <stevegao2003@.163.com> wrote in message
> news:1135330289.992162.176130@.g43g2000cwa.googlegroups.com...

Can I apply this hot fix to solve SqlBulkCopy issue?

Hi,
Our production SQL databaseâ' located on SQL Server 2005 (SP2) with 3161
version. When we use the SqlBulkCopy, the following error occurs:
System.Data.SqlClient.SqlException: The incoming tabular data stream (TDS)
protocol stream is incorrect. The TDS headers contained errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
We searched on web site and found this
http://support.microsoft.com/kb/913177/en-us article.
Now, I want know this hot fix version is higher than 3161 or lower because
we are currently on 3161 version.
Regards,
ChenI don't think this fix affects SQL Server versioning, and doesn't seem to
have anything to do with specific SQL Server hotfixes. So, it is probably
worth a try.
There are also later builds available for SQL Server... you may want to
check cumulative updates 1 - 7 for any mention of the issue you are seeing.
The best part is, you no longer have to call CSS to get one of these
updates.
http://sqlblog.com/blogs/aaron_bertrand/archive/2008/04/25/don-t-want-to-call-css-pss-to-get-a-cumjulative-update-you-don-t-have-to.aspx
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:34AB0521-F9E8-4249-B77C-341FDA1DA921@.microsoft.com...
> Hi,
> Our production SQL databaseâ' located on SQL Server 2005 (SP2) with 3161
> version. When we use the SqlBulkCopy, the following error occurs:
> System.Data.SqlClient.SqlException: The incoming tabular data stream (TDS)
> protocol stream is incorrect. The TDS headers contained errors.
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> Boolean breakConnection)
> We searched on web site and found this
> http://support.microsoft.com/kb/913177/en-us article.
> Now, I want know this hot fix version is higher than 3161 or lower because
> we are currently on 3161 version.
> Regards,
> Chen|||Thank you very much!
"Aaron Bertrand [SQL Server MVP]" wrote:
> I don't think this fix affects SQL Server versioning, and doesn't seem to
> have anything to do with specific SQL Server hotfixes. So, it is probably
> worth a try.
> There are also later builds available for SQL Server... you may want to
> check cumulative updates 1 - 7 for any mention of the issue you are seeing.
> The best part is, you no longer have to call CSS to get one of these
> updates.
> http://sqlblog.com/blogs/aaron_bertrand/archive/2008/04/25/don-t-want-to-call-css-pss-to-get-a-cumjulative-update-you-don-t-have-to.aspx
>
>
>
> "Chen" <Chen@.discussions.microsoft.com> wrote in message
> news:34AB0521-F9E8-4249-B77C-341FDA1DA921@.microsoft.com...
> > Hi,
> > Our production SQL databaseâ' located on SQL Server 2005 (SP2) with 3161
> > version. When we use the SqlBulkCopy, the following error occurs:
> >
> > System.Data.SqlClient.SqlException: The incoming tabular data stream (TDS)
> > protocol stream is incorrect. The TDS headers contained errors.
> > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> > Boolean breakConnection)
> >
> > We searched on web site and found this
> > http://support.microsoft.com/kb/913177/en-us article.
> >
> > Now, I want know this hot fix version is higher than 3161 or lower because
> > we are currently on 3161 version.
> >
> > Regards,
> > Chen
>