Best Protocol?

What is the best protocol (Named Pipes, TCP/IP or VIA) to use when connecting to a SQL Server 2005 on:

a) LAN (100MBps+)

b) VPN (via Internet)

c) Internet

And why?

The answer you're looking for is here.
http://msdn2.microsoft.com/en-us/library/ms187892.aspx|||

I do not believe the article about choosing a connection type to the server answers the question.

In my opinion it is ovbious that the LAN is the best just because of the TCP/IP connection method being able to take advantage of low overhead, hi bandwidth connections.

VPN is guaranteed to be slower than the LAN because the protocol is sitting on top of TCP/IP and will inherently add more overhead.

As far as Internet goes, I am not sure what the difference b/w LAN and Internet is going to be as far as which protocol to use.

Hope this helps.

|||

oj (MVP): Your comment was very helpfull, thank you. I had trouble finding this article myself.

Leifton: Yours was not so.

From what I understand, this is my conclusion (in a very cut-down nutshell).

VIA works best with VIA hardware, enough said.

Named Pipes works best over normal LAN.

TCP/IP works best over VPN and Internet.

Best Protocol?

What is the best protocol (Named Pipes, TCP/IP or VIA) to use when connecting to a SQL Server 2005 on:

a) LAN (100MBps+)

b) VPN (via Internet)

c) Internet

And why?

The answer you're looking for is here.
http://msdn2.microsoft.com/en-us/library/ms187892.aspx|||

I do not believe the article about choosing a connection type to the server answers the question.

In my opinion it is ovbious that the LAN is the best just because of the TCP/IP connection method being able to take advantage of low overhead, hi bandwidth connections.

VPN is guaranteed to be slower than the LAN because the protocol is sitting on top of TCP/IP and will inherently add more overhead.

As far as Internet goes, I am not sure what the difference b/w LAN and Internet is going to be as far as which protocol to use.

Hope this helps.

|||

oj (MVP): Your comment was very helpfull, thank you. I had trouble finding this article myself.

Leifton: Yours was not so.

From what I understand, this is my conclusion (in a very cut-down nutshell).

VIA works best with VIA hardware, enough said.

Named Pipes works best over normal LAN.

TCP/IP works best over VPN and Internet.

Best Design for reports over time

Hi everyone,
I am designing a reporting system for the internet using Reporting
Services. Is there a way to access the historical snapshots
programmatically? We are displaying the reports in the browser by
linking to them in the url, but that brings up the current month's
report. We want to be able to run the report monthly(different data)
and generate a snapshot, then link to the snapshots from the custom
ASP.Net application.
Can we do this? Is is there a better way?
Thanks in advance,
ShawnJust render a history snapshot and look at the generated URL. The URL will
look like this:
http://ServerName/Reports/Pages/Report.aspx?ItemPath=%SomeReport&HistoryID=2005-05-11T22:25:40
The HistoryID identifies the history snapshot in UTC time.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"sysdesigner" <sysdesigner@.discussions.microsoft.com> wrote in message
news:7B7A9AA3-2EBB-45D2-85B2-AD58FE3A5A09@.microsoft.com...
> Hi everyone,
> I am designing a reporting system for the internet using Reporting
> Services. Is there a way to access the historical snapshots
> programmatically? We are displaying the reports in the browser by
> linking to them in the url, but that brings up the current month's
> report. We want to be able to run the report monthly(different data)
> and generate a snapshot, then link to the snapshots from the custom
> ASP.Net application.
>
> Can we do this? Is is there a better way?
>
> Thanks in advance,
> Shawn
>
>