SQL Server 2008 Replication using WORKGROUPS

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Replication (2008)

SQL Server 2008 Replication using WORKGROUPS

Author

Topic

derrickcmg
Starting Member

3 Posts

Posted - 2009-07-09 : 14:39:57

Info:
SQL Server: I am running 2 copies of SQL 2008 Enterprise Edition - SP1
OS: Windows Server 2008 Standard
Domain: No domain, workgroup mode

Setup Description:
1) I created a Windows admin account on both servers with the same username and password.
2) The sa accounts on both SQL Servers have the same password.

On subscriber Server
3) I specify "Run each agent as its Subscriber"

Under Distibution Agent Security
4) I use the account created in step 1 above.
Tried both SQL2K8Dev\username and SQL2K8Prod\username formats.

Connect to the Distributor
5) I used the account in step 2 above.

Error Message:

TITLE: New Subscription Wizard
------------------------------

SQL Server could not create a subscription for Subscriber 'SQL2K8PROD'.

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

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

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

The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "REPLLINK_SQL2K8DEV-672319063_WORKTRACKE1663540475_WORKPUB885749874_WORKREPTIL586061788" was unable to begin a distributed transaction.
Changed database context to 'WorkReptile'.
OLE DB provider "SQLNCLI10" for linked server "REPLLINK_SQL2K8DEV-672319063_WORKTRACKE1663540475_WORKPUB885749874_WORKREPTIL586061788" returned message "No transaction is active.". (Microsoft SQL Server, Error: 7391)

sqltom
Starting Member

1 Post

Posted - 2009-07-13 : 09:08:29

Hi,

Can make sure that you have provided an account to run the report and not use the Integrated Security To be able to use Subscriptions, Reporting Services requires you to provide a fixed account.

Or you try sql server backup, it can help you to backup and restore utility for SQL Server.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources