Replication Expired subscription clean up job failed

Don't know why this job failed since I deleted and rebuilt the subscriber and
publisher last week. Can someone help?
Error detail says: 'Executed as user: FOSTER\sqlservice. Could not find
stored procedure ''. [SQLSTATE 42000] (Error 2812) Associated statement is
not prepared [SQLSTATE HY007] (Error 0). The step failed.'
Appreciate your time.
Tsuey
Tsuey,
please take a look at this to see if it applies:
http://support.microsoft.com/kb/884854
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi Paul,
Thanks for the quick reply. I read this article and don't think it apply.
I don't think I created the replication as transactional replication with
queued updating. If I did, SQL Server will add a new column in each
replicated table, right? How can I sure that the replication is not
configured as queued update?
Tsuey
"Paul Ibison" wrote:

> Tsuey,
> please take a look at this to see if it applies:
> http://support.microsoft.com/kb/884854
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||Tsuey,
what is the 'update mode' if you run sp_helpsubscription?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi Paul, I tried to execute sp_helpsubscription in Query analyzer (hope this
is the right tool to run it) but how do I display the result set? I set the
result in grid or text or file, but can not get the result set to display.
It just simply tells me 'The command(s) completed successfully'. What did I
do wrong? The syntax I use is as below:
exec sp_helpsubscription
GO
"Paul Ibison" wrote:

> Tsuey,
> what is the 'update mode' if you run sp_helpsubscription?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
|||You'll need to execute this at the publisher on the publication database and
provide the subscriber name.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi Paul, I got the sp_helpsubscription ran successfully!! The update mode
for all rows are 0's. It means 'read-only'. What does this tell me? FYI,
we configure the replication as a push replication.
Thanks for your time,
Tsuey
"Paul Ibison" wrote:

> You'll need to execute this at the publisher on the publication database and
> provide the subscriber name.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||OK - then the article definitely doesn't apply. I'd be tempted to reapply
your latest service pack on the distributor, publisher then subscriber. If
that doesn't resolve this issue they I'd raise a support case.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi Paul,
Thanks very much for your reply. I'll try appying the SP4 to see if it helps.
Tsuey
"Paul Ibison" wrote:

> OK - then the article definitely doesn't apply. I'd be tempted to reapply
> your latest service pack on the distributor, publisher then subscriber. If
> that doesn't resolve this issue they I'd raise a support case.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>

Replication Error in Visual Basic

Hi Group,
I have an SQL Server with a database called support for which I have setup a
merge replication subscription called "support".
On my laptop, I have a support program using MSDE locally to access an exact
copy of the data as the main SQL server has.
Whenenver I try to synchronise using the SQLDistribution activeX control, I
get the following message:
"Cannot create transactional subscription to merge publication "support".
The publication type should either be transactional(0) or snapshot(1) for
this operation."
The trouble is, how I see it, I have to used merged because several clients
would have disconnected data sources and any or all could effectively change
the data.
Any help on this appreciated.
Jim
I think your script is wrong. Could you post it here?
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 Hilary,
Thanks for the reply. I figured out I actually needed to use the "merge"
activeX control and not the distribution one. My code is below but I am
still receiving this error:
"The merge process was unable to add the pull subscription from
'JBHOME':'Support:'Support'."
JBHOME being my SQL server, support being the database name and also the
publication name. I have tried various variations on the below code but to
no avail.
-- CODE: --
With SQLMerge
.Publisher = "JBHOME"
.PublisherDatabase = "Support"
.Publication = "Support"
.PublisherSecurityMode = NT_AUTHENTICATION
.Distributor = "JBHOME"
.DistributorSecurityMode = NT_AUTHENTICATION
.Subscriber = "(Local)"
.SubscriberDatabase = "Support"
.SubscriberDatasourceType = SQL_SERVER
.SubscriberSecurityMode = NT_AUTHENTICATION
.SubscriberLogin = "sa"
.SubscriberPassword = "mypassword"
.SubscriptionType = ANONYMOUS
.SynchronizationType = AUTOMATIC
.AddSubscription EXISTING_DATABASE, NONE
.Initialize
.Run
.Terminate
End With
-- END CODE --
Kind Regards
Jim
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1113405033.118118.312480@.g14g2000cwa.googlegr oups.com...
>I think your script is wrong. Could you post it here?
> --
> 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
>
|||FYI,
What I am attempting to do is have a server with a database on it and be
able for a vb written client program to "merge" update the remote server.
The clients will use MSDE as their disconnected database, and all this will
work over the internet (hopefully!!!)
Jim
"Reapes" <reapesuk-@.hotmail.com> wrote in message
news:xvb7e.85688$Nr5.22780@.fe2.news.blueyonder.co. uk...
> Hi Hilary,
> Thanks for the reply. I figured out I actually needed to use the "merge"
> activeX control and not the distribution one. My code is below but I am
> still receiving this error:
> "The merge process was unable to add the pull subscription from
> 'JBHOME':'Support:'Support'."
> JBHOME being my SQL server, support being the database name and also the
> publication name. I have tried various variations on the below code but to
> no avail.
> -- CODE: --
> With SQLMerge
> .Publisher = "JBHOME"
> .PublisherDatabase = "Support"
> .Publication = "Support"
> .PublisherSecurityMode = NT_AUTHENTICATION
> .Distributor = "JBHOME"
> .DistributorSecurityMode = NT_AUTHENTICATION
> .Subscriber = "(Local)"
> .SubscriberDatabase = "Support"
> .SubscriberDatasourceType = SQL_SERVER
> .SubscriberSecurityMode = NT_AUTHENTICATION
> .SubscriberLogin = "sa"
> .SubscriberPassword = "mypassword"
> .SubscriptionType = ANONYMOUS
> .SynchronizationType = AUTOMATIC
> .AddSubscription EXISTING_DATABASE, NONE
>
> .Initialize
> .Run
> .Terminate
> End With
>
> -- END CODE --
> Kind Regards
> Jim
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1113405033.118118.312480@.g14g2000cwa.googlegr oups.com...
>

Replication error - can not retrieve column information

does anyone have an idea of what generally could be wrong with a pull merge subscription when it errors out with the following:
sql server The merge process could not retrieve column information for table "tablename"
Also, could you tell me where I can get more details of errors (i.e. where the errorlog for replication is located
I found how to output the merge agent errors. Here is the output. Can anyone shed any light on this?
[5/15/2004 6:28:05 PM]BOSERVER-CSC3.vis-csc3: {call sp_MSgetversion }
Connecting to Publisher 'VIVA-SQLHQ.VIS'
Server: VIVA-SQLHQ
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[5/15/2004 6:28:05 PM]VIVA-SQLHQ.VIS: {call sp_MSgetversion }
Percent Complete: 5
Processing article 'viva_visit_qualified_statuses'
Percent Complete: 5
Processing article 'viva_inoffice_statuses'
Percent Complete: 5
Processing article 'Users'
The merge process could not retrieve column information for table 'dbo.viva_visit_qualified_statuses'.
The merge process could not retrieve column information for table 'dbo.viva_inoffice_statuses'.The merge process could not retrieve column information for table 'dbo.Users'.
The merge process could not retrieve column information for table 'dbo.Applicant Requirements'.
Percent Complete: 0
The merge process could not retrieve column information for table 'dbo.viva_visit_qualified_statuses'.
Percent Complete: 0
Category:NULL
Source: Merge Replication Provider
Number: -2147201016
Message: The merge process could not retrieve column information for table 'dbo.viva_visit_qualified_statuses'.
Percent Complete: 0
Category:COMMAND
Source: Failed Command
Number: 0
Message: {call sp_MSenumcolumns (?,?)}
Percent Complete: 0
Category:SQLSERVER
Source: BOSERVER-CSC3
Number: 2812
Message: Could not find stored procedure 'sp_sel_82D17F3FEACB41DE7A9684009ECD4868'.
Percent Complete: 0
Category:NULL
Source: Merge Replication Provider
Number: -2147201016
Message: The merge process could not retrieve column information for table 'dbo.viva_inoffice_statuses'.
Percent Complete: 0
Category:NULL
Source: Merge Replication Provider
Number: -2147201016
Message: The process was successfully stopped.
Disconnecting from Subscriber 'BOSERVER-CSC3'
Disconnecting from Publisher 'VIVA-SQLHQ'
Disconnecting from Subscriber 'BOSERVER-CSC3'
Disconnecting from Subscriber 'BOSERVER-CSC3'
Disconnecting from Subscriber 'BOSERVER-CSC3'
Disconnecting from Subscriber 'BOSERVER-CSC3'
Disconnecting from Publisher 'VIVA-SQLHQ'
Disconnecting from Publisher 'VIVA-SQLHQ'
Disconnecting from Publisher 'VIVA-SQLHQ'
Disconnecting from Publisher 'VIVA-SQLHQ'
Disconnecting from Publisher 'VIVA-SQLHQ'
Disconnecting from Distributor 'VIVA-SQLHQ'

Replication Details

Hi,

I used my DB and some tables for replication earlier, now i removed my all replication subscription and publication and my DB is out of replication.

Now i am altering my table for PK then its giving err as follows:

Cannot alter the table 'mstparty' because it is being published for replication.

From where i can find details, i mean in which sys table all replication obj are stored.

There is no Replication now on DB then why still table 'mstparty' has a replication err when i alter table.

Please advice as i am not able to alter my table or tables which earlier i used in replication and now i removed replication.Check this...
http://msdn2.microsoft.com/en-us/library/ms152757.aspx (http://msdn2.microsoft.com/en-us/library/ms152757.aspx)|||Run this query in your Distribution database. & see what data are you getting..?

Select * from MSpublications
Select * from MSarticles

If you are getting any data related your database, means your DB is still there for replication.

Use Publication Wizard from Enterprise Manager for remove publication.|||Not able to find out anything, as there is no subscription or publication exist at all.|||Can you post error along with error number..?|||here is the solutions below:

1. EXEC sp_removedbreplication 'your_database_name'

2. Execute the following procedure on the problematic database and pass the table name as the parameter:

EXEC sp_msunmarkreplinfo 'your_table_name'

3. You may not need this method, but take this as a last resort.

EXEC sp_configure 'allow',1
go
reconfigure with override
go
use your_database_name
go
update sysobjects set replinfo = 0 where name = 'your_table_name'
go
EXEC sp_configure 'allow',0
go
reconfigure with override
gosql

Replication and security..is it really this UNSECURE!

Hi Guys
I need to create an anonymous pull subscription over the Internet.
I've got everything working but I don't want my subscribers to be able
to connect to the publisher/distributor via Enterprise Manager or
ISQLW or anything else for that matter!! Basically they should only
be able to talk to the Publishing SQL Server through replication
methods. How is this achieved?
I'm currently using SQL Security because I don't want an anonymous
subscriber to impersonate my publishers sqlserver agent account, the
agent on the publisher is used for other scheduled tasks that needs
Domain Admin privileges, am I missing something here!!'
Currently I've got it secure-ish. I've used a specific sql account
and given it access in the PAL and removed the guest account from
other DBs, however you cannot remove the guest account from Master or
Msdb and said account must also be a member of the db_owner role. The
most they can do is issue select statements against tables but I think
that is even too much, for instance they can query sysservers which
would allow them to see other subscribers that we do business with.
Even if I use a secure VPN between publisher and subscriber what's to
stop an inquistive subscriber, using the SQL account that I've told
them to use for their subscription, connecting using EM or ISQLW
through the VPN? Surely there must be a way to give ONLY replication
access but nothing else?
Please help!!What type of Replication are you implementing? Snapshot/Transactional or
Merge ?
If they have the data on the Subscriber, there would really be no need to
connect to the Publisher. So, if the users are connecting to the
Subscribing database, that's all they should need.
Are you attempting to restrict access to the Subscribed database?
There isn't a way to restrict access FROM a particular application. So, if
you allow the user to connect to the Server and grant them access to the
database, then they have access from *any* odbc or oledb application.
There isn't a way to restrict this.
Replication works using the accounts designated with the Agents. It
doesn't rely on what permissions the users have.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Replication and security..is it really this UNSECURE!

Hi Guys
I need to create an anonymous pull subscription over the Internet.
I've got everything working but I don't want my subscribers to be able
to connect to the publisher/distributor via Enterprise Manager or
ISQLW or anything else for that matter!! Basically they should only
be able to talk to the Publishing SQL Server through replication
methods. How is this achieved?
I'm currently using SQL Security because I don't want an anonymous
subscriber to impersonate my publishers sqlserver agent account, the
agent on the publisher is used for other scheduled tasks that needs
Domain Admin privileges, am I missing something here!!?
Currently I've got it secure-ish. I've used a specific sql account
and given it access in the PAL and removed the guest account from
other DBs, however you cannot remove the guest account from Master or
Msdb and said account must also be a member of the db_owner role. The
most they can do is issue select statements against tables but I think
that is even too much, for instance they can query sysservers which
would allow them to see other subscribers that we do business with.
Even if I use a secure VPN between publisher and subscriber what's to
stop an inquistive subscriber, using the SQL account that I've told
them to use for their subscription, connecting using EM or ISQLW
through the VPN? Surely there must be a way to give ONLY replication
access but nothing else?
Please help!!
The problem is not with replication and security, but rather a larger one
with SQL Server security in general. Anytime you create an account on that
server, and give that account rights to only one user database, this account
can query system tables on the master database.
I suggest you post this question to the microsoft.public.sqlserver.security
newsgroup.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"greedo" <d8rrylf@.msn.com> wrote in message
news:f0badc7a.0408170010.47baef00@.posting.google.c om...
> Hi Guys
> I need to create an anonymous pull subscription over the Internet.
> I've got everything working but I don't want my subscribers to be able
> to connect to the publisher/distributor via Enterprise Manager or
> ISQLW or anything else for that matter!! Basically they should only
> be able to talk to the Publishing SQL Server through replication
> methods. How is this achieved?
> I'm currently using SQL Security because I don't want an anonymous
> subscriber to impersonate my publishers sqlserver agent account, the
> agent on the publisher is used for other scheduled tasks that needs
> Domain Admin privileges, am I missing something here!!?
> Currently I've got it secure-ish. I've used a specific sql account
> and given it access in the PAL and removed the guest account from
> other DBs, however you cannot remove the guest account from Master or
> Msdb and said account must also be a member of the db_owner role. The
> most they can do is issue select statements against tables but I think
> that is even too much, for instance they can query sysservers which
> would allow them to see other subscribers that we do business with.
> Even if I use a secure VPN between publisher and subscriber what's to
> stop an inquistive subscriber, using the SQL account that I've told
> them to use for their subscription, connecting using EM or ISQLW
> through the VPN? Surely there must be a way to give ONLY replication
> access but nothing else?
> Please help!!

Replication and Deleting Rows

Hello,
I have a large table with over 20 million rows.
It is replicated accross a 4 subscribers using Pull subscription. One of the
subscribers is also a Distributor.
We are running some processed to "clean up" the data in this table by
issuing a lot of DELETE commands (using Primary Key as the where clause)
against the large table. The DELETE commands are enclosed in BEGIN TRAN -
COMIT TRAN batches of 20 each.
The deletion works extremely fast on the Publisher.
However, it takes very very long time to apply the very same commands on all
of the subscribers. The subscribers also have the PRIMARY KEY index that is
on the Publisher.
We need to delete a few million rows from the large table using this
technique. However, it makes the Subscribers very slow and unresponsive.
Any suggestions?
Thanks,
ArsenConsider doing this in even smaller batches. If that is not possible, and
transactional consistency is not really of importance, then you could use a
parameter called MaxCmdsInTran for logreader (introduced in SQL Server 2000
SP1 I believe). This breaks huge transactions into smaller chunks of
specified size, while storing the commands in distribution database.
There is another approach, that I would recommend. Consider using 'stored
procedure execution' replication. With this method, you keep a copy of the
archiving stored procedure on all subscribers. When you run this procedure
on the publisher, the distribution agent will call this sp on all
subscribers, instead of sending millions of DELETEs over the network. See
SQL Server Books Online for more information on this.
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Arsen V." <arsen@.community.nospam> wrote in message
news:%23hpi4tKoEHA.2612@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have a large table with over 20 million rows.
> It is replicated accross a 4 subscribers using Pull subscription. One of
the
> subscribers is also a Distributor.
> We are running some processed to "clean up" the data in this table by
> issuing a lot of DELETE commands (using Primary Key as the where clause)
> against the large table. The DELETE commands are enclosed in BEGIN TRAN -
> COMIT TRAN batches of 20 each.
> The deletion works extremely fast on the Publisher.
> However, it takes very very long time to apply the very same commands on
all
> of the subscribers. The subscribers also have the PRIMARY KEY index that
is
> on the Publisher.
> We need to delete a few million rows from the large table using this
> technique. However, it makes the Subscribers very slow and unresponsive.
> Any suggestions?
> Thanks,
> Arsen
>

Replication and Deleting Rows

Hello,
I have a large table with over 20 million rows.
It is replicated accross a 4 subscribers using Pull subscription. One of the
subscribers is also a Distributor.
We are running some processed to "clean up" the data in this table by
issuing a lot of DELETE commands (using Primary Key as the where clause)
against the large table. The DELETE commands are enclosed in BEGIN TRAN -
COMIT TRAN batches of 20 each.
The deletion works extremely fast on the Publisher.
However, it takes very very long time to apply the very same commands on all
of the subscribers. The subscribers also have the PRIMARY KEY index that is
on the Publisher.
We need to delete a few million rows from the large table using this
technique. However, it makes the Subscribers very slow and unresponsive.
Any suggestions?
Thanks,
Arsen
Consider doing this in even smaller batches. If that is not possible, and
transactional consistency is not really of importance, then you could use a
parameter called MaxCmdsInTran for logreader (introduced in SQL Server 2000
SP1 I believe). This breaks huge transactions into smaller chunks of
specified size, while storing the commands in distribution database.
There is another approach, that I would recommend. Consider using 'stored
procedure execution' replication. With this method, you keep a copy of the
archiving stored procedure on all subscribers. When you run this procedure
on the publisher, the distribution agent will call this sp on all
subscribers, instead of sending millions of DELETEs over the network. See
SQL Server Books Online for more information on this.
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Arsen V." <arsen@.community.nospam> wrote in message
news:%23hpi4tKoEHA.2612@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have a large table with over 20 million rows.
> It is replicated accross a 4 subscribers using Pull subscription. One of
the
> subscribers is also a Distributor.
> We are running some processed to "clean up" the data in this table by
> issuing a lot of DELETE commands (using Primary Key as the where clause)
> against the large table. The DELETE commands are enclosed in BEGIN TRAN -
> COMIT TRAN batches of 20 each.
> The deletion works extremely fast on the Publisher.
> However, it takes very very long time to apply the very same commands on
all
> of the subscribers. The subscribers also have the PRIMARY KEY index that
is
> on the Publisher.
> We need to delete a few million rows from the large table using this
> technique. However, it makes the Subscribers very slow and unresponsive.
> Any suggestions?
> Thanks,
> Arsen
>

Replication (pulling a subscription)

I am trying to pull subscription for a database but I always get the error message ...
Error 15004: Name cannot be null
What exactly have I done wrong
Plaese help
Thanks
Nneka EchebeLets' go thru the process again. I just tried to replicate with northwind. The problem I came up with is nameing convention. It would not accept the local name for the server. It has to have a proper registration name. I also found out that you must replication from the server or sa level. Meaning that remote loggins must have the highest level of access.

Replication - sp_MSget_subscription_guid impossible

We currently have a pull transactional subscription running from a remote 'PublicationServer' in another country to our local server.

After restarting our fire wall we get the following error message:
"The process could not execute '{call sp_MSget_subscription_guid(16)}' on 'PublicationServer'."

This message is followed by another error message: "Another distribution agent for the subscription(s) is running.", although nothing was changed to the configuration and no SQL processes were started or restarted.

When we restart the distribution job manually it runs as if nothing happened.

Does anyone know what exactly caused the failure, and how to prevent it ?

PhilipQuit restarting your firewall ?

I really don't have a good answer for this question. Sometimes after an unexpected failure, the simplest answer is just to manually restart what won't start automagically.

-PatP

Replication -- New Subscription Wizard SQL Mobile error, please help..

I'm following the steps of sample SQL Server Mobile Tutorials..
error on my replication subscription wizard :

"Initialiazing SQL Server Reconciler has failed
HRESULT 0x80045003 (29045)

The initial snapshot for publication 'SQLMobile' is not yet available. Start the Snapshot Agent to generate the snapshot for this publication. If this snapshot is currently being generated, wait for the process to complete and restart the syncronization.
HRESULT 0x80045003 (0)"

error while waiting synchronizing Data in New Subcription Wizard!!
anyone can help?how to solve this problem?the error says the snapshot wasn't available. Did you create the snapshot already?|||of course I did create the snapshot (I succeed create publication on database engine), like I said..I exactly followed the instruction from the SQL Server Mobile tutorial (MSDN Help).
but when I came to New Subscription Wizard step, It fail to synchronize.

please help me "_"|||

Hi feby,

Check and do the following:

1) Open SQL Server 2005 Management Studio

2) In Object Explorer; expand Replication ==> Publications Tab

3) Right Click on the publication you are interested to subscribe to

4) Choose 'View Snapshot Agent Status'

5) Make sure that 'Snapshot is 100% generated'. If it is already, regenerate again!

Just finishing 'New Publication Wizard' does not complete generation of snapshot. When you complete the above wizard, a snapshot agent job is created + started. Please make sure that the snapshot agent job is completed with 100% with above 'View Snapshot Agent Status'.

If you are getting some errors in generating snapshot, check the credentials of snapshot agent and make sure that snapshot (share or folder) has write security permissions for that user.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

[Please move this thread to SQL Server Mobile forum]

|||Hi there
I've got the same problem: I can't generate the snapshot.
ErrorMessage:
The replication agent failed to create the directory '\\<pcname>\snapshot\unc\<pcname>_SQLMOBILE_SQLMOBILEPUBLICATION\20060426091803\'.

I 've set the security permission for the snapshot folder according to the tutorial:
http://msdn2.microsoft.com/en-us/library/ms171908.aspx
for both users (just to make sure)

What i am unsure of, is why they create 2 users: the snapshot_agent (for the snapshot folder) an the IUSR_pcname (for securing the publication)
Which user is doing what and are they related to each other?

According to the MS tutorial (securing Publication step 6) you should see the IUSR in this list, well I couldn't see that user until I gave him the db_owner role, so is that correct, does that user need more roles?
Well I couldn't retrieve the publication, so I added the snapshot_agent user in step 6 an received the errormessage above.

I would be glad, if anyone could help me!
Thanks
Florian Weber, University of Computerscience, Rapperswil, Switzerland

|||Hi
well it seems clearer now, the snapshot_agent is for acessing the snapshot folder an the IUSR_pcname for the anonymous accessing over the IIS.
I also reconfigured the login accounts according to the tutorial.

Unfortunately I still receive the error message that the replication agent fails to create the directory for the snapshot.
The sharing and security settings should be right (write access for the snapshot_agent and the IUSR_pcname)

Has anyone an idea what could be the problem?

Another thing which I am not sure is if the snapshot directory must be the same directory as the virtual directory of the IIS (well I suppose so, because I should access the snapshot from a mobile sql database)

Florian Weber, University of Computerscience, Rapperswil, Switzerland|||

Hi, it looks like you don't have the write permission to the snapshot share. you can find the what is the snapshot folder by running sp_helpdistributor or from the UI to check the publisher's properties.

you will need to give the accout that run the snapshot agent the write permission to this folder.

thanks

yunwen

|||Hi Yunwen
firstly thanks for your fast reply!
I've checked the publisher's properties and the permissions, the account does have the write permission. I even tried to use the admininstrator account, still the same problem.

In my desperation i tried it on another machine and surprisingly it was running perfectly. So it seems that I have some kind of configuration problem with windows on my machine. I think I have to set it up and try it again.
At least I know now how it's working. so thank you!

Greets Florian
|||now my replication & agent are running, but when I deployed the sample program from the tutorial it shows error "Could not connect the database server through IIS" (or error something like that).
I have VS2003 installed on my computer. after my replication running,
I can't create new web project from VS2003. it say : "The Web server reported the following error when attemping to create or open the Web project located at the following URL 'http://localhost/WebApplication'. 'A connection with the server could not be established'."
(like tag IMG below "http://img142.imageshack.us/img142/5429/errorestablished3ma.jpg") any idea why it happen?coz before adjusting replication I can create project, I tried make a virtual directory but it doesn't help (all I know the IIS is still running)|||any body here?|||

i have the exactly same problem and i just have made a clean install i have formated the hard drive but i still having that problem

any advise for solving it?

|||It seem my shared folder can't be accessed, it say about permission!but the strange is..when I plug my LAN cable, that share folder can be accessed!!any clue?|||

Seems like we are all having the same problem. I need to run LAN and Web Sync, so I am using RMO to build out the LAN system now. I have permissions for the share and system at full for testing. When the pull subscription is created from the subscriber machine the subscription is left uninitialized the only feedback I have is a failure to create a new snapshot directory.

Event Type: Error
Event Source: <MS SQL SERVER 2005 Instance Name>

Event Category: (2)
Event ID: 14151
Date: 9/20/2006
Time: 10:31:15 AM
User: N/A
Computer: <MS Windows Server 2003 Machine Name>
Description:
Replication-Replication Snapshot Subsystem: agent <merge replication snapshot agent name> failed.

The replication agent had encountered an exception.

Source: Replication
Exception Type: Microsoft.SqlServer.Replication.ReplicationAgentException
Exception Message: The replication agent failed to create the directory <new sub directory name within replication shared directory>

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Replication -- New Subscription Wizard SQL Mobile error, please help..

I'm following the steps of sample SQL Server Mobile Tutorials..
error on my replication subscription wizard :

"Initialiazing SQL Server Reconciler has failed
HRESULT 0x80045003 (29045)

The initial snapshot for publication 'SQLMobile' is not yet available. Start the Snapshot Agent to generate the snapshot for this publication. If this snapshot is currently being generated, wait for the process to complete and restart the syncronization.
HRESULT 0x80045003 (0)"

error while waiting synchronizing Data in New Subcription Wizard!!
anyone can help?how to solve this problem?the error says the snapshot wasn't available. Did you create the snapshot already?|||of course I did create the snapshot (I succeed create publication on database engine), like I said..I exactly followed the instruction from the SQL Server Mobile tutorial (MSDN Help).
but when I came to New Subscription Wizard step, It fail to synchronize.

please help me "_"|||

Hi feby,

Check and do the following:

1) Open SQL Server 2005 Management Studio

2) In Object Explorer; expand Replication ==> Publications Tab

3) Right Click on the publication you are interested to subscribe to

4) Choose 'View Snapshot Agent Status'

5) Make sure that 'Snapshot is 100% generated'. If it is already, regenerate again!

Just finishing 'New Publication Wizard' does not complete generation of snapshot. When you complete the above wizard, a snapshot agent job is created + started. Please make sure that the snapshot agent job is completed with 100% with above 'View Snapshot Agent Status'.

If you are getting some errors in generating snapshot, check the credentials of snapshot agent and make sure that snapshot (share or folder) has write security permissions for that user.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

[Please move this thread to SQL Server Mobile forum]

|||Hi there
I've got the same problem: I can't generate the snapshot.
ErrorMessage:
The replication agent failed to create the directory '\\<pcname>\snapshot\unc\<pcname>_SQLMOBILE_SQLMOBILEPUBLICATION\20060426091803\'.

I 've set the security permission for the snapshot folder according to the tutorial:
http://msdn2.microsoft.com/en-us/library/ms171908.aspx
for both users (just to make sure)

What i am unsure of, is why they create 2 users: the snapshot_agent (for the snapshot folder) an the IUSR_pcname (for securing the publication)
Which user is doing what and are they related to each other?

According to the MS tutorial (securing Publication step 6) you should see the IUSR in this list, well I couldn't see that user until I gave him the db_owner role, so is that correct, does that user need more roles?
Well I couldn't retrieve the publication, so I added the snapshot_agent user in step 6 an received the errormessage above.

I would be glad, if anyone could help me!
Thanks
Florian Weber, University of Computerscience, Rapperswil, Switzerland

|||Hi
well it seems clearer now, the snapshot_agent is for acessing the snapshot folder an the IUSR_pcname for the anonymous accessing over the IIS.
I also reconfigured the login accounts according to the tutorial.

Unfortunately I still receive the error message that the replication agent fails to create the directory for the snapshot.
The sharing and security settings should be right (write access for the snapshot_agent and the IUSR_pcname)

Has anyone an idea what could be the problem?

Another thing which I am not sure is if the snapshot directory must be the same directory as the virtual directory of the IIS (well I suppose so, because I should access the snapshot from a mobile sql database)

Florian Weber, University of Computerscience, Rapperswil, Switzerland|||

Hi, it looks like you don't have the write permission to the snapshot share. you can find the what is the snapshot folder by running sp_helpdistributor or from the UI to check the publisher's properties.

you will need to give the accout that run the snapshot agent the write permission to this folder.

thanks

yunwen

|||Hi Yunwen
firstly thanks for your fast reply!
I've checked the publisher's properties and the permissions, the account does have the write permission. I even tried to use the admininstrator account, still the same problem.

In my desperation i tried it on another machine and surprisingly it was running perfectly. So it seems that I have some kind of configuration problem with windows on my machine. I think I have to set it up and try it again.
At least I know now how it's working. so thank you!

Greets Florian
|||now my replication & agent are running, but when I deployed the sample program from the tutorial it shows error "Could not connect the database server through IIS" (or error something like that).
I have VS2003 installed on my computer. after my replication running,
I can't create new web project from VS2003. it say : "The Web server reported the following error when attemping to create or open the Web project located at the following URL 'http://localhost/WebApplication'. 'A connection with the server could not be established'."
(like tag IMG below "http://img142.imageshack.us/img142/5429/errorestablished3ma.jpg") any idea why it happen?coz before adjusting replication I can create project, I tried make a virtual directory but it doesn't help (all I know the IIS is still running)|||any body here?|||

i have the exactly same problem and i just have made a clean install i have formated the hard drive but i still having that problem

any advise for solving it?

|||It seem my shared folder can't be accessed, it say about permission!but the strange is..when I plug my LAN cable, that share folder can be accessed!!any clue?|||

Seems like we are all having the same problem. I need to run LAN and Web Sync, so I am using RMO to build out the LAN system now. I have permissions for the share and system at full for testing. When the pull subscription is created from the subscriber machine the subscription is left uninitialized the only feedback I have is a failure to create a new snapshot directory.

Event Type: Error
Event Source: <MS SQL SERVER 2005 Instance Name>

Event Category: (2)
Event ID: 14151
Date: 9/20/2006
Time: 10:31:15 AM
User: N/A
Computer: <MS Windows Server 2003 Machine Name>
Description:
Replication-Replication Snapshot Subsystem: agent <merge replication snapshot agent name> failed.

The replication agent had encountered an exception.

Source: Replication
Exception Type: Microsoft.SqlServer.Replication.ReplicationAgentException
Exception Message: The replication agent failed to create the directory <new sub directory name within replication shared directory>

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Replication -- New Subscription Wizard SQL Mobile error, please help..

I'm following the steps of sample SQL Server Mobile Tutorials..
error on my replication subscription wizard :

"Initialiazing SQL Server Reconciler has failed
HRESULT 0x80045003 (29045)

The initial snapshot for publication 'SQLMobile' is not yet available. Start the Snapshot Agent to generate the snapshot for this publication. If this snapshot is currently being generated, wait for the process to complete and restart the syncronization.
HRESULT 0x80045003 (0)"

error while waiting synchronizing Data in New Subcription Wizard!!
anyone can help?how to solve this problem?the error says the snapshot wasn't available. Did you create the snapshot already?|||of course I did create the snapshot (I succeed create publication on database engine), like I said..I exactly followed the instruction from the SQL Server Mobile tutorial (MSDN Help).
but when I came to New Subscription Wizard step, It fail to synchronize.

please help me "_"|||

Hi feby,

Check and do the following:

1) Open SQL Server 2005 Management Studio

2) In Object Explorer; expand Replication ==> Publications Tab

3) Right Click on the publication you are interested to subscribe to

4) Choose 'View Snapshot Agent Status'

5) Make sure that 'Snapshot is 100% generated'. If it is already, regenerate again!

Just finishing 'New Publication Wizard' does not complete generation of snapshot. When you complete the above wizard, a snapshot agent job is created + started. Please make sure that the snapshot agent job is completed with 100% with above 'View Snapshot Agent Status'.

If you are getting some errors in generating snapshot, check the credentials of snapshot agent and make sure that snapshot (share or folder) has write security permissions for that user.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

[Please move this thread to SQL Server Mobile forum]

|||Hi there
I've got the same problem: I can't generate the snapshot.
ErrorMessage:
The replication agent failed to create the directory '\\<pcname>\snapshot\unc\<pcname>_SQLMOBILE_SQLMOBILEPUBLICATION\20060426091803\'.

I 've set the security permission for the snapshot folder according to the tutorial:
http://msdn2.microsoft.com/en-us/library/ms171908.aspx
for both users (just to make sure)

What i am unsure of, is why they create 2 users: the snapshot_agent (for the snapshot folder) an the IUSR_pcname (for securing the publication)
Which user is doing what and are they related to each other?

According to the MS tutorial (securing Publication step 6) you should see the IUSR in this list, well I couldn't see that user until I gave him the db_owner role, so is that correct, does that user need more roles?
Well I couldn't retrieve the publication, so I added the snapshot_agent user in step 6 an received the errormessage above.

I would be glad, if anyone could help me!
Thanks
Florian Weber, University of Computerscience, Rapperswil, Switzerland|||Hi
well it seems clearer now, the snapshot_agent is for acessing the snapshot folder an the IUSR_pcname for the anonymous accessing over the IIS.
I also reconfigured the login accounts according to the tutorial.

Unfortunately I still receive the error message that the replication agent fails to create the directory for the snapshot.
The sharing and security settings should be right (write access for the snapshot_agent and the IUSR_pcname)

Has anyone an idea what could be the problem?

Another thing which I am not sure is if the snapshot directory must be the same directory as the virtual directory of the IIS (well I suppose so, because I should access the snapshot from a mobile sql database)

Florian Weber, University of Computerscience, Rapperswil, Switzerland|||

Hi, it looks like you don't have the write permission to the snapshot share. you can find the what is the snapshot folder by running sp_helpdistributor or from the UI to check the publisher's properties.

you will need to give the accout that run the snapshot agent the write permission to this folder.

thanks

yunwen

|||Hi Yunwen
firstly thanks for your fast reply!
I've checked the publisher's properties and the permissions, the account does have the write permission. I even tried to use the admininstrator account, still the same problem.

In my desperation i tried it on another machine and surprisingly it was running perfectly. So it seems that I have some kind of configuration problem with windows on my machine. I think I have to set it up and try it again.
At least I know now how it's working. so thank you!

Greets Florian|||now my replication & agent are running, but when I deployed the

sample program from the tutorial it shows error "Could not connect the

database server through IIS" (or error something like that).
I

have VS2003 installed on my computer. after my replication running,

I can't create new web project from VS2003. it say : "The Web server reported the following error when attemping to create or open the Web project located at the following URL 'http://localhost/WebApplication'. 'A connection with the server could not be established'."
(like tag IMG below "http://img142.imageshack.us/img142/5429/errorestablished3ma.jpg")

any idea why it happen?coz before adjusting replication I can create

project, I tried make a virtual directory but it doesn't help (all I know the IIS is still running)|||any body here?|||

i have the exactly same problem and i just have made a clean install i have formated the hard drive but i still having that problem

any advise for solving it?

|||It seem my shared folder can't be accessed, it say about permission!but the strange is..when I plug my LAN cable, that share folder can be accessed!!any clue?|||

Seems like we are all having the same problem. I need to run LAN and Web Sync, so I am using RMO to build out the LAN system now. I have permissions for the share and system at full for testing. When the pull subscription is created from the subscriber machine the subscription is left uninitialized the only feedback I have is a failure to create a new snapshot directory.

Event Type: Error
Event Source: <MS SQL SERVER 2005 Instance Name>

Event Category: (2)
Event ID: 14151
Date: 9/20/2006
Time: 10:31:15 AM
User: N/A
Computer: <MS Windows Server 2003 Machine Name>
Description:
Replication-Replication Snapshot Subsystem: agent <merge replication snapshot agent name> failed.

The replication agent had encountered an exception.

Source: Replication
Exception Type: Microsoft.SqlServer.Replication.ReplicationAgentException
Exception Message: The replication agent failed to create the directory <new sub directory name within replication shared directory>

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Replication -- New Subscription Wizard SQL Mobile error, please help..

I'm following the steps of sample SQL Server Mobile Tutorials..
error on my replication subscription wizard :

"Initialiazing SQL Server Reconciler has failed
HRESULT 0x80045003 (29045)

The initial snapshot for publication 'SQLMobile' is not yet available. Start the Snapshot Agent to generate the snapshot for this publication. If this snapshot is currently being generated, wait for the process to complete and restart the syncronization.
HRESULT 0x80045003 (0)"

error while waiting synchronizing Data in New Subcription Wizard!!
anyone can help?how to solve this problem?the error says the snapshot wasn't available. Did you create the snapshot already?|||of course I did create the snapshot (I succeed create publication on database engine), like I said..I exactly followed the instruction from the SQL Server Mobile tutorial (MSDN Help).
but when I came to New Subscription Wizard step, It fail to synchronize.

please help me "_"|||

Hi feby,

Check and do the following:

1) Open SQL Server 2005 Management Studio

2) In Object Explorer; expand Replication ==> Publications Tab

3) Right Click on the publication you are interested to subscribe to

4) Choose 'View Snapshot Agent Status'

5) Make sure that 'Snapshot is 100% generated'. If it is already, regenerate again!

Just finishing 'New Publication Wizard' does not complete generation of snapshot. When you complete the above wizard, a snapshot agent job is created + started. Please make sure that the snapshot agent job is completed with 100% with above 'View Snapshot Agent Status'.

If you are getting some errors in generating snapshot, check the credentials of snapshot agent and make sure that snapshot (share or folder) has write security permissions for that user.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

[Please move this thread to SQL Server Mobile forum]

|||Hi there
I've got the same problem: I can't generate the snapshot.
ErrorMessage:
The replication agent failed to create the directory '\\<pcname>\snapshot\unc\<pcname>_SQLMOBILE_SQLMOBILEPUBLICATION\20060426091803\'.

I 've set the security permission for the snapshot folder according to the tutorial:
http://msdn2.microsoft.com/en-us/library/ms171908.aspx
for both users (just to make sure)

What i am unsure of, is why they create 2 users: the snapshot_agent (for the snapshot folder) an the IUSR_pcname (for securing the publication)
Which user is doing what and are they related to each other?

According to the MS tutorial (securing Publication step 6) you should see the IUSR in this list, well I couldn't see that user until I gave him the db_owner role, so is that correct, does that user need more roles?
Well I couldn't retrieve the publication, so I added the snapshot_agent user in step 6 an received the errormessage above.

I would be glad, if anyone could help me!
Thanks
Florian Weber, University of Computerscience, Rapperswil, Switzerland|||Hi
well it seems clearer now, the snapshot_agent is for acessing the snapshot folder an the IUSR_pcname for the anonymous accessing over the IIS.
I also reconfigured the login accounts according to the tutorial.

Unfortunately I still receive the error message that the replication agent fails to create the directory for the snapshot.
The sharing and security settings should be right (write access for the snapshot_agent and the IUSR_pcname)

Has anyone an idea what could be the problem?

Another thing which I am not sure is if the snapshot directory must be the same directory as the virtual directory of the IIS (well I suppose so, because I should access the snapshot from a mobile sql database)

Florian Weber, University of Computerscience, Rapperswil, Switzerland|||

Hi, it looks like you don't have the write permission to the snapshot share. you can find the what is the snapshot folder by running sp_helpdistributor or from the UI to check the publisher's properties.

you will need to give the accout that run the snapshot agent the write permission to this folder.

thanks

yunwen

|||Hi Yunwen
firstly thanks for your fast reply!
I've checked the publisher's properties and the permissions, the account does have the write permission. I even tried to use the admininstrator account, still the same problem.

In my desperation i tried it on another machine and surprisingly it was running perfectly. So it seems that I have some kind of configuration problem with windows on my machine. I think I have to set it up and try it again.
At least I know now how it's working. so thank you!

Greets Florian|||now my replication & agent are running, but when I deployed the

sample program from the tutorial it shows error "Could not connect the

database server through IIS" (or error something like that).
I

have VS2003 installed on my computer. after my replication running,

I can't create new web project from VS2003. it say : "The Web server reported the following error when attemping to create or open the Web project located at the following URL 'http://localhost/WebApplication'. 'A connection with the server could not be established'."
(like tag IMG below "http://img142.imageshack.us/img142/5429/errorestablished3ma.jpg")

any idea why it happen?coz before adjusting replication I can create

project, I tried make a virtual directory but it doesn't help (all I know the IIS is still running)|||any body here?|||

i have the exactly same problem and i just have made a clean install i have formated the hard drive but i still having that problem

any advise for solving it?

|||It seem my shared folder can't be accessed, it say about permission!but the strange is..when I plug my LAN cable, that share folder can be accessed!!any clue?|||

Seems like we are all having the same problem. I need to run LAN and Web Sync, so I am using RMO to build out the LAN system now. I have permissions for the share and system at full for testing. When the pull subscription is created from the subscriber machine the subscription is left uninitialized the only feedback I have is a failure to create a new snapshot directory.

Event Type: Error
Event Source: <MS SQL SERVER 2005 Instance Name>

Event Category: (2)
Event ID: 14151
Date: 9/20/2006
Time: 10:31:15 AM
User: N/A
Computer: <MS Windows Server 2003 Machine Name>
Description:
Replication-Replication Snapshot Subsystem: agent <merge replication snapshot agent name> failed.

The replication agent had encountered an exception.

Source: Replication
Exception Type: Microsoft.SqlServer.Replication.ReplicationAgentException
Exception Message: The replication agent failed to create the directory <new sub directory name within replication shared directory>

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Replication - How to create objects as dbo.object when not SA

I just completed creating a replication job between a server at my location, where I have SA privileges, to a subscription server at a location where I have db_owner rights (no SA). When replication runs, the objects get created on the subscriber as userid.object rather then dbo.object. How do I cause replication to create the objects as dbo.object?

DaveHere is some additional information. The subscriber server is at a remote location managed by another IT department. I connected to the subscriber with a user id that was created in the role db_owner. The security was setup in Enterprise Manager by clicking on Replication and then right clicking on Publication. From there I chose "Configure Publishing, Subscibers and Distribution..." and then the Subscribers tab. For the subscriber I chose "Use SQL Server Authentication" and entered my dbo user id. Since I do not have SA rights on this server I need a way to have my dbo id created objects as dbo.objectname.

Hope this helps.

Dave|||When you create the publication (through 'Publication Properties' in SQL-EM) you can specify the owner of the articles to be created in the subscription database. You do this with the 'Article Defaults' button on the 'Articles' tab. Enter dbo in destination table owner field (or destination stored procedure owner field for stored procedures). If you leave these fields blank then the destination objects will be created with the current user as their owner.|||Shortly after I submitted my question I discovered exactly what you indicated, but I found that SQL Server is creating its own stored procedures (sp_MSDel_tablename, sp_MSIns_tablename) using my userid and not dbo. I noticed the Commands tab lists these stored procedures for each table. I assume this is the place where I must prefix each procedure with dbo.. Does this sound correct or is there another way to address SQL Server created procedures?

Thanks, Dave

REPLICATION

DEAR ALL,

I SET UP A PUBLICATION SERVER (SQL 2005) AND A SUBSCRIPTION SERVER SQL2005 BOTH WITH SERVICE PACK. THE SETTINGS SEEM TO BE OK , AND I ALREADY SET THE TABLE WHICH I WANT TO REPLICATE. I AM USING THE TRANSACTIONAL MODE. AT THE BEGINING I COULD INSERT RECORD IN PUBLIC SERVER AND THERE WERE VISIBLE IN SUB SERVER. NEVERTHELESS WHEN I WAS TRYING TO INSERT IN THE TABLE FROM THE SUB SERVER I WAS NOT ABLE TO VIEW THE CHANGES IN PUBLISHER. ANY IDEAS PLS ?

MOREOVER, NOW I CAN NOT REPLICATE AT ALL. I DO NO KNOW IF I CHANGED ANYTHING, BUT I CAN NOT FIND IT. ANY HELP ON THIS PLS

THANKS IN ADVANCE FOR YOUR TIME

GREG

You need to use merge replication. With transactional replication you should not make changes on your subscriber - you should treat is as read only. Also check to see if your change on the subscriber has caused the distribution agent to fail.

You might want to switch to the continue on data consitency error profile to clear the problem.