Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

3930 when pushing subscription to a snapshot replication p..

 
   Database Forums (Home) -> Replication RSS
Next:  GEMS sponsoring H1-B visa  
Author Message
Rick Lowe

External


Since: Jan 11, 2008
Posts: 1



(Msg. 1) Posted: Fri Jan 11, 2008 9:42 am
Post subject: 3930 when pushing subscription to a snapshot replication publicati
Archived from groups: microsoft>public>sqlserver>replication (more info?)

We are attempting to use snapshot replication to push data from one SQL
Server 2005 server to another SQL Server 2005 server. We had no trouble
creating the publication, but when we try to create a new push subscription
we get the failure below (machine, database, etc.. names replaced with
elipses).

The credentials we are using to push the subscription is a member of
sysadmin on the publisher and a member of db_owner in the target database of
the subscriber. Push subscription. Has anyone seen anything like this before?

-------------------------------------------
Creating Subscription(s)...

- Creating subscription for '...' (Error)
Messages
* SQL Server could not create a subscription for Subscriber '...'. (New
Subscription Wizard)

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)

------------------------------

The current transaction cannot be committed and cannot support operations
that write to the log file. Roll back the transaction.
The current transaction cannot be committed and cannot be rolled back to a
savepoint. Roll back the entire transaction.
Changed database context to '...'.
Job '...-...-...-...-8' started successfully.
Warning: The distribution agent job has been implicitly created and will
run under the SQL Server Agent Service Account. (Microsoft SQL Server, Error:
3930)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=0...0.3054&

 >> Stay informed about: 3930 when pushing subscription to a snapshot replication p.. 
Back to top
Login to vote
Display posts from previous:   
   Database Forums (Home) -> Replication All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]