August 17, 2010 at 4:56 pm
Hi,
We have a SQL job running every 5 mins and sometimes it's displaying the below message when we view job history and at the same time the application is unable to communicate with SQL Server and it's happening sometimes only like weely 2 or 3 times.
Executed as user: ABC\mssqlsrv http://abc/abc.amc.client/sys/asp/ETLStart_ISLLSYS_20010101.asp?policyid=12345&userid=scott [SQLSTATE 01000] (Message 0) Source = msxml6.dll, Description = The server name or address could not be resolved [SQLSTATE 01000] (Message 0). The step succeeded
Could you please advice what will be reason for the application fail to communicate with SQL Server?
I did NOT see any errors in SQL Server Error log or in event viewer.
So is there way to get an email when the above message occurs? We are using database mail
Thanks
August 17, 2010 at 8:19 pm
gmamata7 (8/17/2010)
Hi,We have a SQL job running every 5 mins and sometimes it's displaying the below message when we view job history and at the same time the application is unable to communicate with SQL Server and it's happening sometimes only like weely 2 or 3 times.
Executed as user: ABC\mssqlsrv http://abc/abc.amc.client/sys/asp/ETLStart_ISLLSYS_20010101.asp?policyid=12345&userid=scott [SQLSTATE 01000] (Message 0) Source = msxml6.dll, Description = The server name or address could not be resolved [SQLSTATE 01000] (Message 0). The step succeeded
Could you please advice what will be reason for the application fail to communicate with SQL Server?
I did NOT see any errors in SQL Server Error log or in event viewer.
So is there way to get an email when the above message occurs? We are using database mail
Thanks
When you say weekly 2 or 3 times .. does that mean that the server gets rebooted ?
If so check if the SPN is registered properly
Ref: http://www.mssqltips.com/tip.asp?tip=2070 ==> step 6
HTH,
Cheers
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂
August 18, 2010 at 1:52 am
We also have the same issue and it may the issue with application url that unable to recognize the sql instance
August 18, 2010 at 1:55 am
No, the server is not rebooting. The SQLAgent shows the below message and when we see this message, at that time the application is unable to connect sql server and after some time, the message disappears in sql agent job and application re communicates
Executed as user: ABC\mssqlsrv http://abc/abc.amc.client/sys/asp/ETLStart_ISLLSYS_20010101.asp?policyid=12345&userid=scott [SQLSTATE 01000] (Message 0) Source = msxml6.dll, Description = The server name or address could not be resolved [SQLSTATE 01000] (Message 0). The step succeeded
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply