May 21, 2009 at 3:50 am
Hello All;
We have created a copy of the tables and views we have in our Sybase database to MSSQL 2008. Now, i would like to have a DTS connection between both servers but iam totally lost !!! Iam getting this error:
"error msg: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) "
** Is there is any other suggestions beside the DTS to do a migration of data from Sybase to MSSQL2008 daily?
Can anyone help me out please. Thanks.
May 22, 2009 at 10:48 am
Have you checked to ensure remote connections are allowed?
There must be a setting to not use named pipes and use TCP/IP
Have you tried building an SSIS package using the SS2K8 wizard?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply