Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    7

    Unanswered: Random Failed Logins for Database

    Hi,

    We are running MSSQL 2000 on a reasonably powerful dedicated Win2k system Dual 2.4 Xeon Procs, 2 GB of RAM, Ultra 160 SCSI disks.. blah blah blah.

    Our primary use this database server is for our Coldfusion Application servers. We host about 50 or so databases.

    Of late, we have been experiencing random failed logins for certain databases. These failed logins are logged to the event log on the server. They randomly; queries executed against a datasource configured on our application servers trying to get data from the database fail with a login failure when other times they will succeed. I am confused about this issue. Could an issue where the SQL Server is overloaded cause a login failure for a database?


    Errol Neal

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What type of sql server license do you have?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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