January 15, 2009 at 1:15 am
when i want to run the job of backup it shows the error like this.
Message
Executed as user: NT AUTHORITY\SYSTEM. Named Pipes Provider: Could not open a connection to SQL Server [53].
[SQLSTATE 42000] (Error 53) OLE DB provider "SQLNCLI10" for linked server "xyz" ---(name of the server-xyz)
returned message "Login timeout expired". [SQLSTATE 01000] (Error 7412)
OLE DB provider "SQLNCLI10" for linked server "xyz" 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.
[SQLSTATE 01000] (Error 7412). The step failed.
please give me the solution i want this one.
January 15, 2009 at 6:51 am
What service account is SQL running under and does the SYSTEM account have permissions to access SQL?
Are remote connections enabled on the server (and do you have the named pipes protocol enabled)?
How are you attempting to perform the backups?
May 11, 2011 at 1:02 am
i have the same problem, would you please explain to me how did you resolv this problem?
thanks
May 11, 2011 at 5:25 am
Go to SQL Server configuration Manager and then check the Protocols for both Client and instance NAME PIPED is enabled or not,if not then enable it
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply