0

I have a remote windows server and SQL Server 2008 installed. How can I check the access log of SQL Server with the IP address that tried to access the DB?

I tried in SQL Server Management Studio -> Management->SQL Server Log. It doesn't show the IP address.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
dharanbro
  • 1,327
  • 4
  • 17
  • 40
  • You may take a look at http://dba.stackexchange.com/questions/46009/get-username-and-or-ip-address-responsible-for-a-query – Ionic Jul 16 '15 at 06:57

1 Answers1

0

As far as I know, if you missed to set up login auditing, you can't. By default, only failed logins are logged. You have to set your server instance to log both failed and successful logins.

You can find some details here

Community
  • 1
  • 1
OzrenTkalcecKrznaric
  • 5,535
  • 4
  • 34
  • 57