Error: Unspecified error occurred on SQL Server

• pravin-431687

  Old Hand

  Points: 309

  More actions

  January 21, 2009 at 2:19 am

  #198874

  Hi All,

  I have job in sql server which restores database backup and permissions thereafter.

  Sometime one step in this job fails with below message. This step restores users permissions on the restored database.

  Message

  Unspecified error occurred on SQL Server. Connection may have been terminated by the server. [SQLSTATE HY000] (Error 0). The step failed.

  Please help...I don't find any specific error message in log file also.

• Seggerman-675349

  Hall of Fame

  Points: 3563

  More actions

  January 22, 2009 at 6:55 am

  #931127

  I have known unhelpful messages but this has gotta be the worst

  no advice from me, but a certain amount of moral support

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 22, 2009 at 7:12 am

  #931141

  Nothing in the SQL error log at all?

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• isaid.zx

  SSC Journeyman

  Points: 75

  More actions

  November 2, 2009 at 1:26 am

  #1073684

  The same situation, and really, nothing at all on this errorlog instance msg.

  Except one thing: when the process of restoring started, the sqlagent log contains the following msg till the end of restoring:

  2009-11-01 12:30:02 - ! [298] SQLServer Error: 18456, Login failed for user 'DIAMOND\sqladmin64'. [SQLSTATE 28000]

  2009-11-01 12:30:02 - ! [298] SQLServer Error: 4060, Cannot open database "bankDoc" requested by the login. The login failed. [SQLSTATE 42000]

• pravin-431687

  Old Hand

  Points: 309

  More actions

  November 2, 2009 at 1:30 am

  #1073686

  Guys, I found the culprit.

  One script in a job was kiiling connections. That was useless script :).

  Thanks.