Cannot create Merge Replication in 2005

Hi to All,
I had sql 2005 with sp3 and i was working succesfully with merge
replication on Sql ce.
Yestarday i upgrade to sql 2005 (first upgrate my sql200 with sp4)
Now i am here in sql 2005 trying to create a new merge replication on
windows mobile 2005 and i get to the final step this error
------
TITLE: New Publication Wizard
New Publication Wizard encountered one or more errors while retrieving
publication names.
For help, click:
http://go.microsoft.com/fwlink?ProdN...s&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or
batch. (Microsoft.SqlServer.ConnectionInfo)
Invalid column name 'snapshot_jobid'.
Invalid column name 'use_partition_groups'.
Invalid column name 'replicate_ddl'.
Invalid column name 'publication_number'.
Invalid column name 'allow_subscriber_initiated_snapshot'.
Invalid column name 'allow_web_synchronization'.
Invalid column name 'web_synchronization_url'.
Invalid column name 'allow_partition_realignment'.
Invalid column name 'retention_period_unit'.
Invalid column name 'decentralized_conflicts'.
Invalid column name 'generation_leveling_threshold'.
Invalid column name 'automatic_reinitialization_policy'.
Invalid column name 'snapshot_jobid'.
Invalid column name 'use_partition_groups'.
Invalid column name 'replicate_ddl'.
Invalid column name 'publication_number'.
Invalid column name 'allow_subscriber_initiated_snapshot'.
Invalid column name 'allow_web_synchronization'.
Invalid column name 'web_synchronization_url'.
Invalid column name 'allow_partition_realignment'.
Invalid column name 'retention_period_unit'.
Invalid column name 'decentralized_conflicts'.
Invalid column name 'generation_leveling_threshold'.
Invalid column name 'automatic_reinitialization_policy'. (Microsoft SQL
Server, Error: 207)
For help, click:
http://go.microsoft.com/fwlink?ProdN...7&LinkId=20476
------
Can anyone please help ?
Thanks
Savvas
What all did you do when you upgraded?
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
<savvaschr@.nodalsoft.com.cy> wrote in message
news:1139562228.104138.260770@.f14g2000cwb.googlegr oups.com...
> Hi to All,
> I had sql 2005 with sp3 and i was working succesfully with merge
> replication on Sql ce.
> Yestarday i upgrade to sql 2005 (first upgrate my sql200 with sp4)
> Now i am here in sql 2005 trying to create a new merge replication on
> windows mobile 2005 and i get to the final step this error
> ------
> TITLE: New Publication Wizard
> --
> New Publication Wizard encountered one or more errors while retrieving
> publication names.
> For help, click:
> http://go.microsoft.com/fwlink?ProdN...s&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or
> batch. (Microsoft.SqlServer.ConnectionInfo)
> --
> Invalid column name 'snapshot_jobid'.
> Invalid column name 'use_partition_groups'.
> Invalid column name 'replicate_ddl'.
> Invalid column name 'publication_number'.
> Invalid column name 'allow_subscriber_initiated_snapshot'.
> Invalid column name 'allow_web_synchronization'.
> Invalid column name 'web_synchronization_url'.
> Invalid column name 'allow_partition_realignment'.
> Invalid column name 'retention_period_unit'.
> Invalid column name 'decentralized_conflicts'.
> Invalid column name 'generation_leveling_threshold'.
> Invalid column name 'automatic_reinitialization_policy'.
> Invalid column name 'snapshot_jobid'.
> Invalid column name 'use_partition_groups'.
> Invalid column name 'replicate_ddl'.
> Invalid column name 'publication_number'.
> Invalid column name 'allow_subscriber_initiated_snapshot'.
> Invalid column name 'allow_web_synchronization'.
> Invalid column name 'web_synchronization_url'.
> Invalid column name 'allow_partition_realignment'.
> Invalid column name 'retention_period_unit'.
> Invalid column name 'decentralized_conflicts'.
> Invalid column name 'generation_leveling_threshold'.
> Invalid column name 'automatic_reinitialization_policy'. (Microsoft SQL
> Server, Error: 207)
> For help, click:
> http://go.microsoft.com/fwlink?ProdN...7&LinkId=20476
> ------
> Can anyone please help ?
> Thanks
> Savvas
>

Cannot connect using TCP/IP protocol

Win98 client cannot connect to SQL 2K (sp3) on WIN SERVER 2003 (sp1) using
TCP/IP protocol. NamePipe is OK. Other XP client can connect without problem.
any advice?
What is the error number and error message?
There are some TCP/IP issues with older MDAC versions - did
you check/try updating the MDAC version on the 98 client?
-Sue
On Mon, 24 Oct 2005 01:50:02 -0700, "alex"
<alex@.discussions.microsoft.com> wrote:

>Win98 client cannot connect to SQL 2K (sp3) on WIN SERVER 2003 (sp1) using
>TCP/IP protocol. NamePipe is OK. Other XP client can connect without problem.
>any advice?

Cannot connect using TCP/IP protocol

Win98 client cannot connect to SQL 2K (sp3) on WIN SERVER 2003 (sp1) using
TCP/IP protocol. NamePipe is OK. Other XP client can connect without problem.
any advice?What is the error number and error message?
There are some TCP/IP issues with older MDAC versions - did
you check/try updating the MDAC version on the 98 client?
-Sue
On Mon, 24 Oct 2005 01:50:02 -0700, "alex"
<alex@.discussions.microsoft.com> wrote:
>Win98 client cannot connect to SQL 2K (sp3) on WIN SERVER 2003 (sp1) using
>TCP/IP protocol. NamePipe is OK. Other XP client can connect without problem.
>any advice?

Cannot connect using TCP/IP protocol

Win98 client cannot connect to SQL 2K (sp3) on WIN SERVER 2003 (sp1) using
TCP/IP protocol. NamePipe is OK. Other XP client can connect without problem
.
any advice?What is the error number and error message?
There are some TCP/IP issues with older MDAC versions - did
you check/try updating the MDAC version on the 98 client?
-Sue
On Mon, 24 Oct 2005 01:50:02 -0700, "alex"
<alex@.discussions.microsoft.com> wrote:

>Win98 client cannot connect to SQL 2K (sp3) on WIN SERVER 2003 (sp1) using
>TCP/IP protocol. NamePipe is OK. Other XP client can connect without proble
m.
>any advice?

Cannot connect to subscriber

Setup:
- SQL2000 SP3 running on Windows2000 servers.
I have a merge replication running between three identical servers. Two of
the servers, the publisher and subscriber1, receive data from different
sources and are synced every day at 4am. Subscriber2 is a query server only
and is updated by the publisher at 5am.
Replication has been running flawlessly since we upgraded everything nearly
a year ago. This morning the merge agent for Subscriber1 failed with the
following error (XXXX is the server name):
"The process could not connect to Subscriber 'XXXX'.
(Source: XXXX (Agent); Error number: 20084)"
"Cannot generate SSPI context
(Source: XXXX (Data source); Error number: 11004)"
Subscriber2 succeeded. Nothing has changed on the servers, and the logon
credential are the same for each.
I'm at a loss here. Anyone have any idea what might be happening and how to
fix it?
Thanks,
John Steen
There are some patches which seem to be causing this problem. The first
thing I would do is try to connect to the problem machine using SQL
Authentication. This might indicate that someone has changed the server from
mixed authentication to windows. Then try Windows - do you get the SSPI
error there too?
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
"John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
news:ABA30CE3-CA41-481E-9195-35482227D318@.microsoft.com...
> Setup:
> - SQL2000 SP3 running on Windows2000 servers.
> I have a merge replication running between three identical servers. Two
of
> the servers, the publisher and subscriber1, receive data from different
> sources and are synced every day at 4am. Subscriber2 is a query server
only
> and is updated by the publisher at 5am.
> Replication has been running flawlessly since we upgraded everything
nearly
> a year ago. This morning the merge agent for Subscriber1 failed with the
> following error (XXXX is the server name):
> "The process could not connect to Subscriber 'XXXX'.
> (Source: XXXX (Agent); Error number: 20084)"
> "Cannot generate SSPI context
> (Source: XXXX (Data source); Error number: 11004)"
> Subscriber2 succeeded. Nothing has changed on the servers, and the logon
> credential are the same for each.
> I'm at a loss here. Anyone have any idea what might be happening and how
to
> fix it?
> Thanks,
> John Steen
>
|||Thanks for getting back to me so quickly, Hilary.
All three servers are using mixed authentication and identical credentials,
and there have been no patches or updates applied. I ran the merge agent for
Subscriber1 this morning manually and it succeeded. I did the same thing for
Subscriber2 but it failed. A second attempt succeeded. So it doesn't seem
to be an authentication issue.
We have a BU Exec SQL agent that does a differential backup at the same time
the merge agents run, so I'm going to to change the time that the agents run
to see if there's a conflict of some sort. If not, then I'll push it off to
our telecom people.
Thanks,
John
John Steen
remove (nospam) from e-mail address to send me a message
"Hilary Cotter" wrote:

> There are some patches which seem to be causing this problem. The first
> thing I would do is try to connect to the problem machine using SQL
> Authentication. This might indicate that someone has changed the server from
> mixed authentication to windows. Then try Windows - do you get the SSPI
> error there too?
> --
> 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
> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> news:ABA30CE3-CA41-481E-9195-35482227D318@.microsoft.com...
> of
> only
> nearly
> to
>
>

Cannot connect to FTP Site (Merge replication)

Hi;
We have mulitple clients (subscribers) with MSDE SP3. All but one subsriber
are able to retrieve the subscription and replication. The error message on
the failing subscriber is "The computer is disconnected from the network".
The computer runs XP Pro like most of the others and is connected via a VPN
like the others.
The schema script '' could not be propagated to the subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
The process could not connect to FTP site 'PL000' using port 21.
(Source: lachlan (Agent); Error number: 0)
The computer is disconnected from the network
(Source: (OS); Error number: 12163)
Any ideas what can cause this? The subscriber that fails was infected with a
virus earlier, but it is now clean the the virus software does not detect
any new or existing virus.
Thomas Born
there are many possibilities
1) the ftp server/site is not active
2) you have specified anonymous only in your ftp server and are trying to
connect using an NT account
3) the ftp server is listening on a different port
4) the snapshot folder does not have read rights for the NT account you are
using or if you are using anonymous authentication to the IUSER_MachineName
account
5) You are using an NT account that does not exist on the machine hosting
the FTP server.
6) your subscriber is on the deny acccess IP address list
Return to your publisher and confirm that all of the above is correctly set
up
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Thomas Born" <tborn_news@.hotmail.com> wrote in message
news:u2gIGJYZEHA.3564@.TK2MSFTNGP11.phx.gbl...
> Hi;
> We have mulitple clients (subscribers) with MSDE SP3. All but one
subsriber
> are able to retrieve the subscription and replication. The error message
on
> the failing subscriber is "The computer is disconnected from the network".
> The computer runs XP Pro like most of the others and is connected via a
VPN
> like the others.
>
> The schema script '' could not be propagated to the subscriber.
> (Source: Merge Replication Provider (Agent); Error number: -2147201001)
> ----
--
> --
> The process could not connect to FTP site 'PL000' using port 21.
> (Source: lachlan (Agent); Error number: 0)
> ----
--
> --
> The computer is disconnected from the network
> (Source: (OS); Error number: 12163)
> ----
--
> --
> Any ideas what can cause this? The subscriber that fails was infected with
a
> virus earlier, but it is now clean the the virus software does not detect
> any new or existing virus.
> Thomas Born
>
|||Thanks for the respone,
I am using anonymous authentication from all the other subscribers as well
and they are working. Also very sure that the server listens on 21. Need to
check 6) but I don't think it is a problem.
I have tested it with having two different machines as the subscriber on my
network at home. One is working and the other one gets the computer
disconnected message. I am getting close to reinstall the operating system
on the failing subscriber, will see if that fixes the problem.
Thomas
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:OFyXETaZEHA.3012@.tk2msftngp13.phx.gbl...
> there are many possibilities
> 1) the ftp server/site is not active
> 2) you have specified anonymous only in your ftp server and are trying to
> connect using an NT account
> 3) the ftp server is listening on a different port
> 4) the snapshot folder does not have read rights for the NT account you
are
> using or if you are using anonymous authentication to the
IUSER_MachineName
> account
> 5) You are using an NT account that does not exist on the machine hosting
> the FTP server.
> 6) your subscriber is on the deny acccess IP address list
> Return to your publisher and confirm that all of the above is correctly
set[vbcol=seagreen]
> up
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Thomas Born" <tborn_news@.hotmail.com> wrote in message
> news:u2gIGJYZEHA.3564@.TK2MSFTNGP11.phx.gbl...
> subsriber
> on
network".[vbcol=seagreen]
> VPN
> ----
> --
> ----
> --
> ----
> --
with[vbcol=seagreen]
> a
detect
>
|||Re-installing the operating system to fix ftp is radical.
Can you open up IE, and in the address bar connect to the ftp site on the
publisher. What do the ftp logs on the publisher reveal?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Thomas Born" <tborn_news@.hotmail.com> wrote in message
news:eWZ00$%23ZEHA.3708@.TK2MSFTNGP10.phx.gbl...
> Thanks for the respone,
> I am using anonymous authentication from all the other subscribers as well
> and they are working. Also very sure that the server listens on 21. Need
to
> check 6) but I don't think it is a problem.
> I have tested it with having two different machines as the subscriber on
my[vbcol=seagreen]
> network at home. One is working and the other one gets the computer
> disconnected message. I am getting close to reinstall the operating system
> on the failing subscriber, will see if that fixes the problem.
> Thomas
> "Hilary Cotter" <hilaryk@.att.net> wrote in message
> news:OFyXETaZEHA.3012@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
> are
> IUSER_MachineName
hosting[vbcol=seagreen]
> set
message[vbcol=seagreen]
> network".
a[vbcol=seagreen]
number: -2147201001)
> ----
> ----
> ----
> with
> detect
>

Cannot connect to analysis services 'servername'

Hi,
I am very new to using Analysis services, so please bare with me. I am
running dqlserver service pack 4 which has AS sp3 bundled within. Everything
is on the same box.
I am trying to schedule a job from my sql server to build me cubes.
The local package works but when I schedule, I receive an error.
Executed as user: RENRE\RenreSQLAgent. DTSRun: Loading... DTSRun:
Executing... Error string: Cannot connect to the Analysis server on
computer 'BDA-REPORTING01'. Connection to the server is lost
I have tried to add myself to OLAP admin group, edited the repository string
,
added to local admin.
Please help DebraCheck if the account under which SQLServerAgent runs (RENRE\RenreSQLAgent ?)
is a member of OLAP Administrators group of the computer 'BDA-REPORTING01'
Francesco Anti
"Debra Ramlal via droptable.com" <forum@.droptable.com> wrote in message
news:507B14EC71864@.droptable.com...
> Hi,
> I am very new to using Analysis services, so please bare with me. I am
> running dqlserver service pack 4 which has AS sp3 bundled within.
> Everything
> is on the same box.
> I am trying to schedule a job from my sql server to build me cubes.
> The local package works but when I schedule, I receive an error.
> Executed as user: RENRE\RenreSQLAgent. DTSRun: Loading... DTSRun:
> Executing... Error string: Cannot connect to the Analysis server on
> computer 'BDA-REPORTING01'. Connection to the server is lost
> I have tried to add myself to OLAP admin group, edited the repository
> string,
> added to local admin.
> Please help Debra

Cannot connect to analysis services 'servername'

Hi,
I am very new to using Analysis services, so please bare with me. I am
running dqlserver service pack 4 which has AS sp3 bundled within. Everything
is on the same box.
I am trying to schedule a job from my sql server to build me cubes.
The local package works but when I schedule, I receive an error.
Executed as user: RENRE\RenreSQLAgent. DTSRun: Loading... DTSRun:
Executing... Error string: Cannot connect to the Analysis server on
computer 'BDA-REPORTING01'. Connection to the server is lost
I have tried to add myself to OLAP admin group, edited the repository string,
added to local admin.
Please help DebraCheck if the account under which SQLServerAgent runs (RENRE\RenreSQLAgent ?)
is a member of OLAP Administrators group of the computer 'BDA-REPORTING01'
Francesco Anti
"Debra Ramlal via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:507B14EC71864@.SQLMonster.com...
> Hi,
> I am very new to using Analysis services, so please bare with me. I am
> running dqlserver service pack 4 which has AS sp3 bundled within.
> Everything
> is on the same box.
> I am trying to schedule a job from my sql server to build me cubes.
> The local package works but when I schedule, I receive an error.
> Executed as user: RENRE\RenreSQLAgent. DTSRun: Loading... DTSRun:
> Executing... Error string: Cannot connect to the Analysis server on
> computer 'BDA-REPORTING01'. Connection to the server is lost
> I have tried to add myself to OLAP admin group, edited the repository
> string,
> added to local admin.
> Please help Debra

Cannot connect to analysis services 'servername'

Hi,
I am very new to using Analysis services, so please bare with me. I am
running dqlserver service pack 4 which has AS sp3 bundled within. Everything
is on the same box.
I am trying to schedule a job from my sql server to build me cubes.
The local package works but when I schedule, I receive an error.
Executed as user: RENRE\RenreSQLAgent. DTSRun: Loading... DTSRun:
Executing... Error string: Cannot connect to the Analysis server on
computer 'BDA-REPORTING01'. Connection to the server is lost
I have tried to add myself to OLAP admin group, edited the repository string,
added to local admin.
Please help Debra
Check if the account under which SQLServerAgent runs (RENRE\RenreSQLAgent ?)
is a member of OLAP Administrators group of the computer 'BDA-REPORTING01'
Francesco Anti
"Debra Ramlal via droptable.com" <forum@.droptable.com> wrote in message
news:507B14EC71864@.droptable.com...
> Hi,
> I am very new to using Analysis services, so please bare with me. I am
> running dqlserver service pack 4 which has AS sp3 bundled within.
> Everything
> is on the same box.
> I am trying to schedule a job from my sql server to build me cubes.
> The local package works but when I schedule, I receive an error.
> Executed as user: RENRE\RenreSQLAgent. DTSRun: Loading... DTSRun:
> Executing... Error string: Cannot connect to the Analysis server on
> computer 'BDA-REPORTING01'. Connection to the server is lost
> I have tried to add myself to OLAP admin group, edited the repository
> string,
> added to local admin.
> Please help Debra