I'm thinking the question is along the lines of, "I have somebody who connected to a database on a SQL Server. How do I determine, from within SQL Server, the connection string that person used to connect to the server?" Unfortunately, the answer is, "You don't." You **can** get information about the connection from sys.dm_exec_connections and sys.dm_exec_sessions. Start with the following query: select * from sys.dm_exec_connections c inner join sys.dm_exec_sessions s on c.session_id = s.session_id; From there, you can determine things like protocol, authentication method (SQL or Windows), connecting hostname, application name, client interface, login, NT domain (if Windows authenticated), etc. This won't rebuild a connection string for you, but you can make some pretty decent guesses with this data.