Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2010-09-26 : 23:58:57
|
| Dear All,There is one scheduled job which runs every day 6:00AM which fails with following message MessageUnable to connect to SQL Server '(local)'. The step failed.Every day it used to run fine not sure why exactly is this,failure.My intention here is is to Identify what is the reason.I checked in SQL server log(Management) and event viewer application error log.Doesn't seems its server reset How can i find out the exact reason.Thanks,Gangadhar |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2010-09-27 : 02:49:09
|
| Got this error log info from Agent log history when the job failed.Message[298] SQLServer Error: 4060, Cannot open database "DataStage" requested by the login. The login failed. [SQLSTATE 42000] |
 |
|
|
|
|
|
Job failure messege