RE: Application "Failure Audit" Event

Hello Alex,

Disable the Remote connection will not disapear the Failure Audit event.
Since when the remote client logon, OS will pass it to SQL Server and get
the login error.

To close the IP port, you may disable the 1433 and 1434 default TCP port
for the SQL Server. You could use the SQL Configuration Manager to check
which port the instance is using.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages

  • [NT] Microsoft SQL Server 2000 Unauthenticated System Compromise
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Microsoft's database server SQL Server 2000 exhibits two buffer-overrun ... clients connecting to TCP port 1433 or both. ... This message is a single byte packet, ...
    (Securiteam)
  • Re: Is there any way to prevent hacker trying to guess sa password?
    ... and port 1433 will not be open. ... If someone can crash SQL Server by connecting to port 1433, ... You don't need multiple security experts. ...
    (microsoft.public.sqlserver.security)
  • Re: Accessing sql server
    ... port, select All ports, in Remote port, select Fixed port and input 1433 ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... | I have now checked and I can access the sql server when creating an ODBC ...
    (microsoft.public.windows.server.sbs)
  • Re: How to connect a workstation to SQL Server 2005 thru ODBC?
    ... and open the port in the Windows XP ... Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... Either SQL Server Management Studio or Management Studio Express. ...
    (microsoft.public.sqlserver.connect)
  • Re: Failover problems on 2 active/active SQK 2k clusters on Windows 2003
    ... If you don't set the port numbers with SNU, the ports change each time the ... Microsoft SQL Server MVP ... I recently deployed 2 new SQL clusters for our web environments. ... The first cluster has instance names DBSERVER1 and DBSERVER2\DBSERVER2, ...
    (microsoft.public.sqlserver.clustering)