Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    26

    Unanswered: Login failed ... which database.

    Hi,

    I am getting a login failed to a SQL Server 2000, and was wondering how to get the information about which database it is trying to use? is there anyway of doing this in SQL Server 2000.

    Thanks.

  2. #2
    Join Date
    Nov 2004
    Location
    Canada
    Posts
    58
    how do you know a login failed in the first place from a client app? Depending on what alerts/logs you have set up you could check the sql server error log. You could also check the server eventvwr application log
    And check the master.dbo.sysxlogins since you mentioned sql2000, but it will not show the db they tried to connect to. it will show you their status.
    you could run the sp_helplogins proc too to get syxlogins information.
    Last edited by burkular; 05-08-09 at 08:42.

Posting Permissions

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