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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-16 : 08:15:19
|
| Paul writes "I have a sql server 2000 (running on windows 2003 web) database with a merge publication. I set up a push subsciption from the pub to a backup server that is to take the load and merge the new information to the publisher, should the publisher ever go offline. The push works fine and the data is updating on the subscriber, but on the subscriber server it appears I have read-only access to the database. I can't insert/update or delete data from the database. Whenever I try I receive the error "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.". This despite being able to view the data in query analyser etc.The permissions on the pub and the sub are identical. At the moment my pub is offline and I wanted to switch to the sub but I can't because I can't update the data. I'm clearly doing something fundamentally wrong, can you shed any light?ThanksPaul" |
|
|
|
|
|
Merge replication problems