Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Capture DNS alias info in App connection Expand / Collapse
Author
Message
Posted Friday, December 13, 2013 1:35 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 5:20 PM
Points: 58, Visits: 315
Hi,

Is there a way in Sql server to capture the "DNS alias" being used in the connection string? Applications are connecting using either the "DNS alias" or the "network name" of the sql server machine. We would like every application to connect using DNS alias hence we have to perform an audit of all the apps connecting to Sql server.

Thanks in advance.
Post #1522861
Posted Monday, December 16, 2013 4:42 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Do you mean NSLOOKUP?

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1523154
Posted Monday, December 16, 2013 4:49 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 8:18 AM
Points: 2,448, Visits: 2,988
double post
please only reply to http://www.sqlservercentral.com/Forums/Topic1523063-1550-1.aspx


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1523159
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse