Results 1 to 6 of 6

Thread: Ent Mgr. Management-CurrentActivity-Application - Error?

  1. #1
    Join Date
    Mar 2004
    Location
    Indianapolis
    Posts
    3

    Ent Mgr. Management-CurrentActivity-Application - Error?

    I'm having a problem with couple of users on our network not connecting to SQL exactly right. In the CurrentActivity window under the application column these users are not showing the authenticated usernames. Example: it should be username@computername but all that shows is @computername. These users get weird security problems that I have not been able to resolve. Our network admin is looking into it but he's not sure why these users should be any different than the rest. Any suggestions?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Checked users' desktop to see how did they connect to sql server?

  3. #3
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Can they connect to server using sql client tools (query analyzer ?).

    Application name column may not be set by all applications.

  4. #4
    Join Date
    Mar 2004
    Location
    Indianapolis
    Posts
    3

    MRP

    All the users are using our MRP
    (Fourth Shift). The other users are reporting correctly.

  5. #5
    Join Date
    Sep 2002
    Posts
    5,938
    Does MRP conenct to sql via odbc dsn? If so, check dsn settings for those users.

  6. #6
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Check the MDAC version on those machines.

Posting Permissions

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