Capture Connection String

• thbaig

  Hall of Fame

  Points: 3003

  More actions

  June 5, 2015 at 6:00 am

  #297448

  Hi,

  I am migrating one of our db server to new hardware. Our application is legacy and not all developer exist who developed this app.

  We want to see what servers are connecting to database, we had done this with dmvs. But the next challenge is to capture connection string. In code usually qualified domain exist for connection but on some places one had bind the IPAddress. So this is risky to move without know these details. We want to extract that information, so that dev can fix code on required server

  I want to capture connection string information e.g.

  <ConnectionString>Server = ServerName , Catalog=MyDb ........

  <ConnectionString>Server = ServerIP , Catalog=MyDb ..............

  Is it possible to capture such information in MSSQL ? or if you know some other way to capture such information .

  Thanks

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  June 5, 2015 at 6:44 am

  #1803276

  I don't think it can be done in SQL Server.

  -- Gianluca Sartori