Cannot register subscriber

We are setting up a test laptop to use with Merge replication to a SQL 2K
server that serves as both Publisher and Distributor. I was hoping to
create a push subscription but that needs a register server setup that does
not work. When I go to register the server (MSDE on laptop) from the
Publisher, it shows the laptop computer name in the "Select a SQL Server"
dialog box. But when I select it and choose to connect using either windows
authentication OR SQL server login I get the message "SQL Server does not
exist or access denied". When I setup the laptop with MSDE, I set the
authentication to be "Mixed" and entered a strong sa password. Can someone
tell me why this is happening?
p.s. I can setup the laptop as a subscriber using anonymous settings using
Windows Synchronization Manager from the laptop just fine.
David
Unregister this SQL Server in Enterprise Manager and then add it back again.
I think you are having name resolution problems.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:eRe$lX0BGHA.3584@.TK2MSFTNGP11.phx.gbl...
> We are setting up a test laptop to use with Merge replication to a SQL 2K
> server that serves as both Publisher and Distributor. I was hoping to
> create a push subscription but that needs a register server setup that
> does not work. When I go to register the server (MSDE on laptop) from the
> Publisher, it shows the laptop computer name in the "Select a SQL Server"
> dialog box. But when I select it and choose to connect using either
> windows authentication OR SQL server login I get the message "SQL Server
> does not exist or access denied". When I setup the laptop with MSDE, I
> set the authentication to be "Mixed" and entered a strong sa password.
> Can someone tell me why this is happening?
> p.s. I can setup the laptop as a subscriber using anonymous settings using
> Windows Synchronization Manager from the laptop just fine.
> David
>
|||That did not work.
David
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OxlsptDCGHA.1288@.TK2MSFTNGP09.phx.gbl...
> Unregister this SQL Server in Enterprise Manager and then add it back
> again. I think you are having name resolution problems.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "David Chase" <dlchase@.lifetimeinc.com> wrote in message
> news:eRe$lX0BGHA.3584@.TK2MSFTNGP11.phx.gbl...
>
|||What is the sa account you are using? It should be the sa account of the
publisher - not the subscriber.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:ORhLPe$CGHA.4080@.TK2MSFTNGP09.phx.gbl...
> That did not work.
> David
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OxlsptDCGHA.1288@.TK2MSFTNGP09.phx.gbl...
>
sql

Cannot open database during merge replication

Hi All,
I am replicating an SQL2005 express machine to SQL2005 standard edition server using merge replication.

I have a simple VB application using ADO polling msMerge_history at the subscriber every second so that i can show the end user the progress of the replication.

When the subscription first subscribes and after the initial snapshot is applied replication downloads all changes from the server that have been changed since the snapshot was created.

Towards the end of this download faze the VB polling application fails with "Cannot open database "DBName" requested by the login. The login failed."

This connection fails 4 or 5 times and then normal polling resumes. The scary thing is that sometimes when the polling connection fails the merge replication does not complete and if i check msMerge_Sessions the "runstatus" is stuck at 3 (InProgress).

1) Is the reason the ADO polling connection fails because of some sort of lock between replication and reading the system tables?
2) Is replication getting stuck because of locks?
3) What can i do to get around this?

cheers,
Tim

Hello Tim,

Please try to use uncommited read isolation level (or SELECT ... WITH (NOLOCK) )when querying msMerge_Sessions table.

But result row set from this query contains uncommitted transactions.

This posting is provided AS IS with no warranties, and confers no rights

Cannot open database during merge replication

Hi All,
I have previously posted in the MSDN forums with no responses, so any
hints on this would be greatly appreciated.
I am replicating an SQL2005 express machine to SQL2005 standard
edition server using merge replication.
I have a simple VB application using ADO polling msMerge_history at
the subscriber every second so that i can show the end user the
progress of the replication.
When the subscription first subscribes and after the initial snapshot
is applied replication downloads all changes from the server that have
been changed since the snapshot was created.
Towards the end of this download faze the VB polling application fails
with "Cannot open database "DBName" requested by the login. The login
failed."
This connection fails 4 or 5 times and then normal polling resumes.
The scary thing is that sometimes when the polling connection fails
the merge replication does not complete and if i check
msMerge_Sessions the "runstatus" is stuck at 3 (InProgress).
1) Is the reason the ADO polling connection fails because of some sort
of lock between replication and reading the system tables?
2) Is replication getting stuck because of locks?
3) What can i do to get around this?
cheers,
Tim
The status event is the best way to monitor progress of your sync.
Merge replication does put schema and application locks on your tables,
including the sysmergerarticles table - this is probably what you are
seeing.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mar72Vin" <mar72vin@.gmail.com> wrote in message
news:1173826362.218126.53350@.l75g2000hse.googlegro ups.com...
> Hi All,
> I have previously posted in the MSDN forums with no responses, so any
> hints on this would be greatly appreciated.
> I am replicating an SQL2005 express machine to SQL2005 standard
> edition server using merge replication.
> I have a simple VB application using ADO polling msMerge_history at
> the subscriber every second so that i can show the end user the
> progress of the replication.
> When the subscription first subscribes and after the initial snapshot
> is applied replication downloads all changes from the server that have
> been changed since the snapshot was created.
> Towards the end of this download faze the VB polling application fails
> with "Cannot open database "DBName" requested by the login. The login
> failed."
> This connection fails 4 or 5 times and then normal polling resumes.
> The scary thing is that sometimes when the polling connection fails
> the merge replication does not complete and if i check
> msMerge_Sessions the "runstatus" is stuck at 3 (InProgress).
> 1) Is the reason the ADO polling connection fails because of some sort
> of lock between replication and reading the system tables?
> 2) Is replication getting stuck because of locks?
> 3) What can i do to get around this?
> cheers,
> Tim
>
|||Hi Hilary,
Thanks for the quick reply.
We are not using the replication component to start replication so we
can't use the "status event"
We run replmerg.exe independently so that replication can be started
via windows Task Scheduler. This way we do not need to have our
replication monitor open whilst replicating.
However when we do have our replication monitor open the replmerg.exe
disappears out of the taskmanager and leaves replication stuck at the
"in progress" status. This only happens after applying the initial
snapshot. (subsequent replications succeed)
The last message recorded to msMerge_History is usually "Web
Syncronization progress xx% Complete."
Why would the replmerge.exe just "give up" at this stage?
thanks for your time.
Cheers,
Tim
On Mar 14, 12:45 pm, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:[vbcol=seagreen]
> The status event is the best way to monitor progress of your sync.
> Merge replication does put schema and application locks on your tables,
> including the sysmergerarticles table - this is probably what you are
> seeing.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com
> "Mar72Vin" <mar72...@.gmail.com> wrote in message
> news:1173826362.218126.53350@.l75g2000hse.googlegro ups.com...
>
>
>
>
|||Looks like i have been barking up the wrong tree. The connections from
the ado application are not causing this error.
I ran replmerg.exe and captured the results (see below), It looks like
replication is trying to use the SYSTEM login at some point to access
the database and it does not have access.
The SQL2005Express instance is running under the system account, I
can't see why it should have troubles connecting to this database.
Any Ideas?
cheers,
Tim
2007-03-14 04:56:34.347 Connecting to Subscriber 'BARNEYXP\MDSZINC'
2007-03-14 04:56:34.347 Connecting to OLE DB Subscriber at datasource:
'BARNEYXP\MDSZINC', location: '', catalog: 'MDS200703146',
providerstring: '' using provider 'SQLNCLI'
2007-03-14 04:56:36.811 Percent Complete: 0
2007-03-14 04:56:36.811 Category:AGENT
Source: BARNEYXP\MDSZINC
Number: 20052
Message: The process could not access database 'MDS200703146' on
server 'BARNEYXP\MDSZINC'.
2007-03-14 04:56:36.811 Percent Complete: 0
2007-03-14 04:56:36.811 Category:SQLSERVER
Source: BARNEYXP\MDSZINC
Number: 4060
Message: Cannot open database "MDS200703146" requested by the login.
The login failed.
2007-03-14 04:56:36.811 Percent Complete: 0
2007-03-14 04:56:36.811 Category:SQLSERVER
Source: BARNEYXP\MDSZINC
Number: 18456
Message: Login failed for user 'NT AUTHORITY\SYSTEM'.
|||It sounds like one of the accounts you are trying to connect to the
publisher/distributor/or subscriber is not defined. You will need to use an
account which is in the pal on the publisher and in the sysadmin or dbo_role
on the subscriber. It will need rights to read, and list files and folders
on the snapshot share.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mar72Vin" <mar72vin@.gmail.com> wrote in message
news:1173852824.327599.170440@.n59g2000hsh.googlegr oups.com...
> Looks like i have been barking up the wrong tree. The connections from
> the ado application are not causing this error.
> I ran replmerg.exe and captured the results (see below), It looks like
> replication is trying to use the SYSTEM login at some point to access
> the database and it does not have access.
> The SQL2005Express instance is running under the system account, I
> can't see why it should have troubles connecting to this database.
> Any Ideas?
> cheers,
> Tim
>
> 2007-03-14 04:56:34.347 Connecting to Subscriber 'BARNEYXP\MDSZINC'
> 2007-03-14 04:56:34.347 Connecting to OLE DB Subscriber at datasource:
> 'BARNEYXP\MDSZINC', location: '', catalog: 'MDS200703146',
> providerstring: '' using provider 'SQLNCLI'
> 2007-03-14 04:56:36.811 Percent Complete: 0
> 2007-03-14 04:56:36.811 Category:AGENT
> Source: BARNEYXP\MDSZINC
> Number: 20052
> Message: The process could not access database 'MDS200703146' on
> server 'BARNEYXP\MDSZINC'.
> 2007-03-14 04:56:36.811 Percent Complete: 0
> 2007-03-14 04:56:36.811 Category:SQLSERVER
> Source: BARNEYXP\MDSZINC
> Number: 4060
> Message: Cannot open database "MDS200703146" requested by the login.
> The login failed.
> 2007-03-14 04:56:36.811 Percent Complete: 0
> 2007-03-14 04:56:36.811 Category:SQLSERVER
> Source: BARNEYXP\MDSZINC
> Number: 18456
> Message: Login failed for user 'NT AUTHORITY\SYSTEM'.
>
sql

cannot merge after triming the key values

Hi,

I am new to SSIS.I am doing a left outer jon using the merge join.The output was wrong.I realised that may be we have to trim the key values.But when i do the trim in the derived column,the output of the derived columns shows that issorted is becoming false and the sort key position has become 0.So the merge join is showing error.How can i solve this error.

Please help.

TRIM would reset the isSorted property because removing leading and trailing spaces affects the sort order. " B" will sort ahead of "A", because of the leading space. If you are querying from a relational DB, I'd recommend doing the TRIM and SORT in your source query, and set the isSorted and SortKey properties in the Advanced Editor of the OLE DB Source. If it's not a relational source, just add a sort transform after your derived column, but before the merge join.

Cannot log conflict data

Hi,
I'm having problme when performing the Merge replication and the error as
belows:
1) The process could not log conflict information
follow by
2) Too many arguments were supplied for procedure sp_cft_xxxxxxx
Pls help, it is urgent!!!
Thanks.
Ringo
Message posted via http://www.sqlmonster.com
does this help?
http://support.microsoft.com/default...;en-us;Q241658
Hilary Cotter
Looking for a SQL Server replication book?
<http://www.nwsu.com/0974973602.html>
Looking for a FAQ on Indexing Services/SQL FTS
<http://www.indexserverfaq.com>
|||Hi,
This doesn't really help. Maybe I should address more on my problem. The
problem happened when there;s conflict during replication and try to record
info into the conflict table through sp_cft_xxxxx stored procedure. The
error shows that the parameters passing to the sp_cft_xxxxx SP is more (one
extra parameter which I think is "0x00" as the last parameter).
The above replication is between the SQL CE (PDA) and MS SQL 2000 server
where I'm using the "Synchronize()" method.
BTW, thanks for your help
Message posted via http://www.sqlmonster.com
|||where are you calling this proc? Its on the publisher correct?
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"ringo law via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:daf883cd95a9432fba48b2a26852239f@.SQLMonster.c om...
> Hi,
> This doesn't really help. Maybe I should address more on my problem. The
> problem happened when there;s conflict during replication and try to
> record
> info into the conflict table through sp_cft_xxxxx stored procedure. The
> error shows that the parameters passing to the sp_cft_xxxxx SP is more
> (one
> extra parameter which I think is "0x00" as the last parameter).
> The above replication is between the SQL CE (PDA) and MS SQL 2000 server
> where I'm using the "Synchronize()" method.
> BTW, thanks for your help
> --
> Message posted via http://www.sqlmonster.com
|||Hi,
No, I didn't call the stored proc. It's a system stored proc to log
conflict info in publisher table (conflict_tablename) when there's conflict
occurred.
If I try this Merge Replication between SQL Server (2000 to 2000), it can
work and the conflict record is created. But, if between SQL CE and 2000,
then this problem happened.
Thanks.
Ringo
Message posted via http://www.sqlmonster.com

Cannot insert the value NULL into column 'rowguid'....

Hello
i'm using merge replication in SQL server 2k but when i try to synchronise a
subscriber i get the following error
Cannot insert the value NULL into column 'rowguid'...
This seems to be caused by the fact that the columns are in a different
order
ie. columns we added after the publication
is there a way to cause the publication to name the fields in the insert
therefore eliminating this problem?
Thanks
How did you add the columns after the table was published?
Donna
"kris Palmby" wrote:

> Hello
> i'm using merge replication in SQL server 2k but when i try to synchronise a
> subscriber i get the following error
> Cannot insert the value NULL into column 'rowguid'...
> This seems to be caused by the fact that the columns are in a different
> order
> ie. columns we added after the publication
> is there a way to cause the publication to name the fields in the insert
> therefore eliminating this problem?
> Thanks
>
>
|||I'd like to know this also.
"Donna Lambert" <DonnaLambert@.discussions.microsoft.com> wrote in message
news:E4388B76-FBB2-4F00-8893-1F3F0ACEFB31@.microsoft.com...[vbcol=seagreen]
> How did you add the columns after the table was published?
> Donna
> "kris Palmby" wrote:

cannot insert Null value into columns 'nicknames'

We have a merge replication on a database containing dynamic filters. At a
given moment one of the clients gets the following error during replication.
'The process could not make a generation at the Subscriber'
The error message is
'Cannot insert the value NULL into column 'nicknames', table
'vdavenne.dbo.MSMerge_genhistory'; column does not allow nulls.
Nol ,
does the problem resolve itself when you restart the merge agent? If not,
please can you post up the script of your article and publication and I'll
have a play around with it.
Thanks,
Paul Ibison
|||You need SP3a or Microsoft's hot fix. Went through this pain myself about 2 months ago.
Good luck.
C

Quote:

Originally posted by Paul Ibison
Nol ,
does the problem resolve itself when you restart the merge agent? If not,
please can you post up the script of your article and publication and I'll
have a play around with it.
Thanks,
Paul Ibison

Cannot fine the object “MSmerge_ctsv_... Because it does not exists or you do not have permissio

I keep getting the following error message during the initial merge agent.

· “The merge process was unable to deliver the snapshot to the subscriber.If using Web synchronization, the merge process may have been unable to create or write the message file, when troubleshooting, restart the sychronzation with verbose history loggin and specify an output file to write.

· Cannot fine the object “MSmerge_ctsv_B5ECD41086F24A64B8040A41A75B2DC4”, Because it does not exists or you do not have permission.(source: MSSQLServer, Error number 15151)

I do see this view in the publication and if I run the following command on the publisher I get…

select * from Msmerge_ctsv_B5ECD41086F24A64B8040A41A75B2DC4

I get

tablenick rowguid generation partchangegen lineage colv1 marker logical_record_parent_rowguid logical_record_lineage

(0 row(s) affected)

I have another publication working on this same server that is working, both are from a copy from a template database.Please advise to what this problem could be and what I can do to resolve this.

Thank you,

Pauly C

The issue was the mobile server name was changed but not dropped and re-added back so the values of@.@.servername and serverproperty(‘servername’) did not match. Once I fixed this everything replicated fine. Not a very intuitive error but if the error returns somethign like "Cannot fine the object “MSmerge_ctsv_..." check the subscriber server name by running

select @.@.servername as oldservername, serverproperty('servername') as newservername, case when @.@.servername <> serverproperty('servername') then '*** Error - Server name changed, replication will not work' else 'Replication friendly' end as cMessage

also this is a script I use to run the procs to drop and add the server...

Use Master

IF (select SERVERPROPERTY('ServerName')) <> (SELECT @.@.Servername )

begin

DECLARE @.SQL VARCHAR(256), @.oldsvrname varchar(128), @.newsvrname varchar(128)

select @.oldsvrname = cast(@.@.servername as varchar(128)), @.newsvrname = cast(SERVERPROPERTY('ServerName') as varchar(128))

set @.SQL = 'Sp_DropServer @.server = ''' + @.oldsvrname + ''', @.droplogins =''droplogins'''

exec( @.SQL)

SET @.SQL = 'Sp_Addserver @.server =''' + @.newsvrname + ''', @.local= ''LOCAL'' , @.duplicate_ok = ''duplicate_OK'' '

exec(@.SQL )

end

** must restart services at this point.

Thank you,

Pauly C

|||Maybe if you would run the agent with a higher OutputVerboseLevel, perhaps it may have given you clues.|||Actually I did that but it gave the same error message.

Cannot find the identity range allocation entry for the Subscriber

Dear All,
When I am synchronizing the merge push subscription, receiving following error
Cannot find the identity range allocation entry for the Subscriber in the
MSmerge_identity_range table. Reinitialize the subscription.
What could be the cause of message, and is there some way so I can avoid
re-initialization of susbscription
How did you deploy this subscriber? Did you do a no-sync?
"M. M. Ansari" <MMAnsari@.discussions.microsoft.com> wrote in message
news:15A3AA2B-9F5F-45BC-BBC7-4C48FEF239E7@.microsoft.com...
> Dear All,
> When I am synchronizing the merge push subscription, receiving following
> error
> Cannot find the identity range allocation entry for the Subscriber in the
> MSmerge_identity_range table. Reinitialize the subscription.
> What could be the cause of message, and is there some way so I can avoid
> re-initialization of susbscription
>

Cannot find sp_repladdcolumn stored procedure.

I have merge replication set up on several database tables. I was reading
about using sp_repladdcolumn and sp_repldropcolumn to make modification to
the schema since it cannot be done directly with the alter table command.
However, I cannot find either of these store procedures in the list for this
database. I do see several sp_ followed by a long cryptic looking name
comprised of lettes and numbers.
Should the sp_repldropcolumn and sp_repladdcolumn be showing up on a merge
replicated database? If so, do you know of why these are not showing up?
Thanks,
Bill Mitchell
they are in the master database on all SQL Server 2000 systems.
"Bill Mitchell" <bill.mitchell@.jjindustries.com> wrote in message
news:u5M5LEDREHA.1340@.TK2MSFTNGP12.phx.gbl...
> I have merge replication set up on several database tables. I was reading
> about using sp_repladdcolumn and sp_repldropcolumn to make modification to
> the schema since it cannot be done directly with the alter table command.
> However, I cannot find either of these store procedures in the list for
this
> database. I do see several sp_ followed by a long cryptic looking name
> comprised of lettes and numbers.
> Should the sp_repldropcolumn and sp_repladdcolumn be showing up on a merge
> replicated database? If so, do you know of why these are not showing up?
> Thanks,
> Bill Mitchell
>
|||Thanks Hilary! I am just learning SQL Server and was sure I had corrupted
something in my database.
Bill
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:u3qr33EREHA.2716@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> they are in the master database on all SQL Server 2000 systems.
> "Bill Mitchell" <bill.mitchell@.jjindustries.com> wrote in message
> news:u5M5LEDREHA.1340@.TK2MSFTNGP12.phx.gbl...
reading[vbcol=seagreen]
to[vbcol=seagreen]
command.[vbcol=seagreen]
> this
merge[vbcol=seagreen]
up?
>