Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hthikey
Starting Member
4 Posts |
 Posted - 2007-08-24 : 09:06:04
|
| I have created a publication and push subscriptions from a sql server 2005 server to a sql server 2000 servers both within internal network successfully - without any hitch. The replication works fine here. Login to sql server 2000 was through the window authentication. After that I tried to do the same but the Sql Sql Server was outside the firewall on an ISP's network. The setup for this is described below:Sql Server 2005 (local server) is within the internal network from where data needs to be pumped into Sql Server 2000 (remote server) database which is outside the firewall. In order to access the Remote Sql Server I have also created, on the remote (sql server 2000) server a new sql server login user with dbo access to the database. The local sql server can communicate to the external server through the firewall using this user name. This has been tested because I can connect to the external database server from the Sql Server 2005 Management Studio (using sql server authentication ) and query and update the tables. I then created a Local Publication (to transfer table data from one of the database) on the local server, which is ok. But when I try to create a push subscription from the local server to the remote server (with all the parameters assigned, including the sql server authentication users login, etc), the sql server throughs the following error message. (No subscription gets created):***error start *************************An error has occured 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: SQL Network Interfaces, error: 25 - Connection string is not valid) (Microsoft SQL server, error: 87)***error end ************************Can anyone there help?P.S. A similar replication setting from another local sql server 2000 server to the same external Sql Server 2000 server has been working OK. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-24 : 23:34:28
|
| Does sql2k5 allow remote access? |
 |
|
|
|
|
|
Cannot Set up a Subscription from Sql Server 2005