How can i find connecting string to SQL db from database?

Question

question

jghimirey asked Oct 29, '12

How can i find connecting string to SQL db from database?

connection-string

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock commented · Oct 29, 2012 at 06:08 PM

Normally the connection string is defining the connection to the database and not actually in the DB.. Unless it defines connection to another DB. Usually it is stored within a config file, e.g. in IIS it could be WEB.Config. Try the link below... http://www.connectionstrings.com/

3 ·

Answer 1 · 2012-10-29T18:58:35Z

Kevin Feasel answered Oct 29, '12

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.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2012-10-30T17:42:14Z

jghimirey answered Oct 30, '12

Thanks Kevin!

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question