Posts Tagged ‘sql server’
I am working on “database synchronization” between Sql Server 2005 (running on windows server 2003) and MySql (running on *nix). Before starting developing my own component i thought to digg around and find some already made tool instead of “re-inventing” the wheel. So by then i found this tool.
It’s nice tool but while configuring it according to the documents i faced an error message
"[Microsoft][SQL Server 2000 Driver for JDBC]End of stream was detected on a read."
Man, i was so stuck in this error and was not able to get any work around then somehow i got to know that may be SQL Server 2005 does not allow REMOTE CONNECTION. When i tested and it was true. SQL Server 2005 does not allow remote access through TCP or NAMED PIPES. You have to allow these connection and you can do this by following this tutorial