Hi,
Can someone me in understanding the Protocol Layer in SQL Server?
As far as i know, it's the TCP/IP and is used to communicate with external
app/systems, and access to SQL is possible through these protocols. Any more
info will be ful.

Regards,
Shyam

> Can someone me in understanding the Protocol Layer in SQL Server?

See http://msdn.microsoft.com/en-us/library/cc448435.aspx for a detailed
description of the TDS protocol that SQL Server uses. This sits on top of a
network layer (TCP/IP, named pipes, LPC). Note that TDS is transparent to
applications since the client API (ADO.NET, SQLOLEDB, etc.) takes care of
formulating the TDS requests and passing to the the net library to transfer
over the wire.

--
Hope this s.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"Shyam" <Shyam@discussions.microsoft.com> wrote in message
news:48DFE6A8-64FE-4AB5-86B6-7110C6FCC456@microsoft.com...
> Hi,
> Can someone me in understanding the Protocol Layer in SQL Server?
> As far as i know, it's the TCP/IP and is used to communicate with external
> app/systems, and access to SQL is possible through these protocols. Any
> more
> info will be ful.
>
> Regards,
> Shyam
>

.... and a few words about netlibs here:
http://sqlblog.com/blogs/tibor_karas...and-stuff.aspx

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:eZS0EInEJHA.1272@TK2MSFTNGP05.phx.gbl...
>> Can someone me in understanding the Protocol Layer in SQL Server?
>
> See http://msdn.microsoft.com/en-us/library/cc448435.aspx for a detailed description of the TDS
> protocol that SQL Server uses. This sits on top of a network layer (TCP/IP, named pipes, LPC).
> Note that TDS is transparent to applications since the client API (ADO.NET, SQLOLEDB, etc.) takes
> care of formulating the TDS requests and passing to the the net library to transfer over the wire.
>
> --
> Hope this s.
>
> Dan Guzman
> SQL Server MVP
> http://weblogs.sqlteam.com/dang/
>
> "Shyam" <Shyam@discussions.microsoft.com> wrote in message
> news:48DFE6A8-64FE-4AB5-86B6-7110C6FCC456@microsoft.com...
>> Hi,
>> Can someone me in understanding the Protocol Layer in SQL Server?
>> As far as i know, it's the TCP/IP and is used to communicate with external
>> app/systems, and access to SQL is possible through these protocols. Any more
>> info will be ful.
>>
>> Regards,
>> Shyam
>>
>