June 19, 2011 at 3:31 am
Hi all,
When i am running the below statement
select count(*) from [ID3522].MSDB.DBO.SYSJOBHISTORY
from management studio, i am getting desired results.
But when i am running the same statement from SQL job step i am getting below error:
Executed as user: US\sqlid. Named Pipes Provider: Could not open a connection to SQL Server [5]. [SQLSTATE 42000] (Error 5) OLE DB provider "SQLNCLI10" for linked server "ID3522" returned message "Login timeout expired". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI10" for linked server "ID3522" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.". [SQLSTATE 01000] (Error 7412). The step failed.
ID3522 is a SQL server 2000 and the server from which i am running these queries is 2008 version.
Please help!!
Regards,
Ankur
Cheers
June 19, 2011 at 11:50 am
I posted this in wrong header. Can the moderator move this to SQL server 2008.
Cheers
June 24, 2011 at 7:59 am
Check if SQL Agent has permissions to [ID3522].MSDB database.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply