November 29, 2007 at 2:40 pm
For SQL Server 2005, using provider SQLNCLI, if shared memory, named pipes, and TCP/IP are all enabled....
1) How can one determine how an existing user is connected? There is lots of info in the Server Management Studio, but I could not find connection type.
2) If the client is on the same machine and Data Source is '.', which connection is selected? If that one is then disabled, what is next. (What is the preferred order?)
3) If the client is on another machine.... same question as #1 except that shared memory is out of the picture.
4) Can the connection string force which connection type is used? I assume that "DataSource=127.0.0.1" will force TCP/IP, but how about the two.
Yes, I know that if you can answer #1 then I can then easily get the answers to #2 and #3. But if you know, save me the trouble please.
Thanks
Z
November 30, 2007 at 10:30 am
I have some answers to my own questions.
1) To get the connection type, run the query "SELECT net_transport FROM sys.dm_exec_connections WHERE session_id = @@SPID;"
2) Not sure how to use Named Pipes and don't want to, but Shared Memory is preferred over TCP.
3) See #2, I don't care any more !
4) Yes, that will force TCP.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply