I have been receiving messages in my log file saying :-
"Login failed for user 'sa': Reason Password did not match that for the login provided. [Client:xx.xx.xx.xx]"
the xx are actual numbers.
In the MS firewall, I've added my IP to the "Remote IP address" list on the Scope tab.
When I have gone back to the log file, the message has stopped appearing. Instead it says "its starting up ReportServerTempDB", does this mean that I've inadvertently by adding my IP to the remote IP list allowed anyone in?
By putting only my IP address in the scope means I've blocked everyone else apart from me connecting to the remote database?
Ultimately, I would like remote access allowed only to my IP. If that is not possible, I want a block on all remote access.