Technical Tips, Tricks and Articles

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

Advertisements

Written by ..alee

June 11, 2008 at 11:21 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: