Why is my service account displaying a connection using the server IP?
-
Hello All.
I have a 2 node SQL Server 2012 cluster running with no issues.
I have been tasked by management (don't ask me why) to answer why on only this cluster the SQL service account looks as follows in the server logs:
Login succeeded for user 'DOMAIN\SQLserviceaccount'. Connection made using Windows authentication. [CLIENT: XXX.XXX.XXX.XXX] (this of course represents the server node's IP address).
All other servers across the environment report the same info as follows:
Login succeeded for user 'DOMAIN\SQLserviceaccount'. Connection made using Windows authentication. [CLIENT: Localhost]
So they all show the connection as Localhost instead of the server's IP address.
Any thoughts?
Can this server be somehow changed to report the connection as Localhost instead?
Thanks in advance for any suggestions!
-
possibly because it is a cluster and it has its own IP - which will be different from the local host (cluster node)
-
only TCP/IP active ? ( Check SQL Server 20** Configuration Manager / Network Configuration )
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Appreciate the ideas - I will investigate them both!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply