September 14, 2009 at 4:51 am
Hi,
One of my DTS job connects to sql server,it worked till recently,but currently its throwing this error.Please help with below
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A socket operation was attempted to an unreachable host.) (Microsoft SQL Server, Error: 10065)
Thank for the help
September 14, 2009 at 7:07 am
Are you running DTS on SQL Server 2005? sorry its not an attempt to answer your question, was just curious to know. This is not the reason for your error.
Most of the time it will be the issue with the account that you are using in the DTS that would cause failure. Check them.
---------------------------------------------------------------------------------
September 14, 2009 at 11:08 pm
Can you ping the servername that you are trying to connect to FROM the server with the DTS job on it? It sounds like you need to do the normal TCP/IP connectivity checks.
CEWII
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply