Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Location
    CHENNAI-INDIA
    Posts
    8

    Unanswered: Violations in WINDOWS 2000 when connection established from a client to server

    Hi,

    I am a SQL DBA involved in accomplishing various activities using Enterprise Manager by regestering servers of various countries.

    Now as the NT Team has gone for auditing implementation in all the servers in OS lever, they find Access violations from the workstation from where I connect to the server. This does not happens if I unregester the Servers from Enterprise manager and use only query analyzer.

    Note: We have our own users in OS as wel as in SQL SERVER .

    Its Urgent!!! Please help!!!
    Last edited by chandarmohanr; 07-23-04 at 14:58.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    What do you mean "access violation"? Where do they see it? Post the error.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Apr 2004
    Location
    CHENNAI-INDIA
    Posts
    8
    Hi, Thanks for your response,

    Please find the error message. The message is a single line but wrapped due to space restriction

    Server Name : ASTRIST01P013(Turkey)
    Login used : ca73461
    WORKSTATION:APACINMAASTW010(India)


    7/22/2004 3:13:34 PM 16 2 529 Security NT AUTHORITY\SYSTEM ASTRIST01P013 Logon Failure: Reason: Unknown user name or bad password User Name: CA73461 Domain: APACINMAASTW010 Logon Type: 3 Logon Process: KSecDD Authentication Package: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0 Workstation Name: \\APACINMAASTW010


    Find also the attached file for your information
    Attached Files Attached Files

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    EM uses UDP to check the heartbeat of the server. Talk to your sysadmin/network admin and ask him/her if there UDP or port restrictions that have been implemented (1434 I think).

    Logon types that I know are:

    Interactive = 2 - Interactively logged on (locally or remotely)
    Network = 3 - Accessing system via network
    Batch = 4 - Started via a batch queue
    Service = 5 - Service started by service controller
    Proxy = 6 - Proxy logon
    Unlock = 7 - Unlock workstation
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  5. #5
    Join Date
    Apr 2004
    Location
    CHENNAI-INDIA
    Posts
    8
    Thanks for your reply, I passed on the information to Sysadmin team and waiting for their response.

    But I want to share one more information. Though I get access violation, My connection to the server is always successful and we are working from it without any problem. If there is any restriction as you mention, should it not stop the connection from being successful.

    Again, the violations occurs so frequently(see attached text) that within a second, I get sometimes more than 5 to 6 violations per sec.

    We are constantly screwed for these violations.

    Few more Info to share.
    1. Our workstation belongs to different domain from the target server which
    we connect to
    2. Though username is same in local workstation and server to which we connect to, the passwords may be same or different.

    Expecting your observations and suggestions

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •