I am trying to
copy a database from our company's external SQL
Server(production) to our local SQL
Server(development). The Copy Database wizard fails on the step
"Execute SQL Server Agent Job".
Following is the error in the log file.. Please advise
InnerException-->An
error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact
that under the default settings SQL Server does not allow remote
connections. (provider: Named Pipes Provider, error: 40 - Could not
open a connection to SQL Server)
Have you verified that both servers have the remote connections allowed. Have a look at this KB Article. Remember that Remote connections is turned off by default on new installes of sql server 2005.
|||Do you know how I can set SQL Server2005 to allow remote connections on a cluster?
No comments:
Post a Comment