访问来自sql server的服务器的IP地址 [英] Ip Address of server from sql server is accessed

问题描述

亲爱的，



我们怎样才能获得我的sql服务器访问过的服务器的IP地址。

考虑钓鱼数据库发生的事情，我想知道所有Sqlserver连接的地址。





谢谢

Dear all,

How can we get the Ip address of the server from which my sql server accessed.
consider some fishing things happened with database ,i want to know the ip addresses from where all the Sqlserver is connected.


Thanks

推荐答案

您可以运行SQL Server Profiler。它列出了SQL数据库的所有请求。然后你可以确定哪个请求是真实的，哪个不是。

You can run the SQL server profiler. It list down all the request that comes to SQL database. Then you can identify which request is genuine and which is not.

1）如果你的意思是有人访问你的应用程序&在前端做hanky panky，我能想到的是你可以在某些你需要记录的操作的前端调用的屏幕上使用存储过程。然后，您可以为该过程提供必要的标识参数，例如IPAddress，userName等。将它们记录在一个单独的表中。



2）如果您尝试使用SQL Server登录某人，则可以使用ConnectionProperty。但是，我想知道如果这应用于Web应用程序，是否会返回应用程序地址。这将有助于 http://msdn.microsoft.com/en-us/library/bb895240.aspx [ ^ ]

1) If you mean someone accessing your application & doing hanky panky with the front end, what I can think of is that you can use a stored procedure on certain screens that is called on the front end on certain operations you want to log. Then, you could provide that procedure with necessary identification parameters such as IPAddress, userName etc. & log these in a separate table.

2) If you are trying to log someone using SQL server you can use ConnectionProperty. However, I wonder if this would return you the application address if this is applied on a web application. This would help http://msdn.microsoft.com/en-us/library/bb895240.aspx[^]

这篇关于访问来自sql server的服务器的IP地址的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！