Advice needed

From: Don Grover (spamfree_at_assoft.com.au)
Date: 12/29/03 

Date: Mon, 29 Dec 2003 11:14:21 +1100

I have an sql server db on a remote dedicated server that is open on
internet, for remote report writing.
The company that uses is it extremely large and well known, due to this the
sql server gets hammered by bogus logins.
10,000+ of them a day,.
Security wise its ok but the bloody error log files are huge 27-48 mb.

Because I logonto this server remotely atleast once a day and check logs, I
am finding it difficult to read them due to the size for vieving log file
in a TS session.

How can I create 1 error log a day for 7 days then recycle them, or atleast
create them into more manageble sizes.
Regards
Don

Relevant Pages

  • Re: TS vs VPN
    ... Using TS, w/o VPN ... The remote client connects to your local TS via Remote Desktop. ... "Foo" accesses the SQL server, which is nearby in a protected part of the network. ...
    (microsoft.public.windows.terminal_services)
  • Re: Remote Database Connection with PocketPC/MSAccess Front End
    ... If you want to allow direct remote access for your Access data, I'd suggest writing a web service which your remote apps could use. ... The general problem with mobile access to remote data of any kind (including SQL Server which Windows Mobile devices can access directly remotely) is that sometimes the connection just isn't there. ... Generally the easiest backend data store to use for this local cache is going to be SQL Server Compact, which supports several sync strategies including the Access Sync Services that your question isn't about. ...
    (microsoft.public.pocketpc.developer)
  • RE: Login failed for user (null).
    ... used at signon to authenticate in SQL Server. ... connect the remote SQL Server database), is there any other data accessing ... What's the security identity used to access the remote SQL Server, ... the worker process identity. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: SQL 2005 Remote Connection Error
    ... The error log records the port number at the time of startup. ... So I see an entry in the SQL Server error log: ... on my remote desktop, where I am attempting to connect to the SQL Server. ... >> Configuration for Services And Connections for the Remote Connections ...
    (microsoft.public.sqlserver.connect)
  • RE: CTP3 Failure - Creating a Remote Distributor (error during decrypt
    ... with changes in the SQL Server service account after replication has been set ... Are the remote distributor and the publisher machines in the same domain? ... Are the distributor and publisher SQL Server Service running under domain ...
    (microsoft.public.sqlserver.replication)