Custom TDS Endpoints: Listening on multiple ports
Last time, I talked about how clients communicate with SQL Server through TDS endpoints and how to disable endpoints to prevent user access. Today we’ll see how we can configure SQL Server to listen on multiple ports through the use of user-defined endpoints. Create a new TDS endpoint There can only be one Shared Memory [...]
April 18, 2012
Tags: connectivity, network, SQL Server, TDS Posted in: Internals 
No Comments
TDS Endpoints: SQL Server’s “Listener”
In the land of Oracle, if you want to prevent user access to your database, you stop the listener. Without that agent running, you can still connect to the database locally, via shared memory, but all TCP/IP connectivity is disabled. As a DBA, this is pretty handy if you need time to perform maintenance tasks [...]
April 17, 2012
Tags: connectivity, Internals, network, SQL Server, TDS Posted in: Internals 3 Comments
