Technical Tips, Tricks and Articles

Posts Tagged ‘sql server 2005

Unable to connect remotely to Microsoft SQL Server 2005

leave a comment »

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.

Daffodil Replicator

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

How to configure SQL Server 2005 to allow remote connections

Written by ..alee

June 11, 2008 at 11:21 am