473,569 Members | 2,466 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL Server 2005 Transactional Replication problem

First a bit about what I' trying to do.

I'm running SQL Server 2005 Developer edition on my dev box. I've got
two instances set up and am trying to set up transactional replication
(with both immediate and queued updates) between the two instances.

The windows account I'm using to run the replication agents (dist,
logreader, snapshot and queuereader) is a domain account with the same
rights as the SQLServerAgent on my box.

Thus far I've:

1) Distributor and publisher have been set up on the same instance
2) Given this account logins on both instances
3) Made it db_owner in the distribution database
4) Made sure its in the PAL
5) Made it a user in the replicated db on both the subscriber and
publisher.
6) Seems the process to set up the publication has set up all the
right crendentials for the proxies to use.

Using SSMS I tested the login on both instances. When setting up agent
security, I used this account for all of the above agents.

Snapshot and LogReader agents work fine. QueueReader and Distribution
agent fail with the following message:
"Unable to start execution of step 2 (reason: Error authenticating
proxy mydomain\window saccount, system error: Logon failure: unknown
user name or bad password.). The step failed.
"

Am I correct in assuming that the login failure is occurring on the
subscriber instance? If so, why's it happening?

Any insight would be hugely appreciated

Thanks,
Joe

Mar 8 '07 #1
0 4588

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2521
by: Michael Orlando | last post by:
Any help would be greatly appreciated. My problem is that I need to set up a backup SQL Server 2000 machine which can be used in case of a failure to my primary. All databases (30 as of now) must be an up to the minute exact copy of production and include most recent changes in data as well as any structure changes (Tables, Views, SP's,...
1
4746
by: KWilliams | last post by:
Hello, We are trying to set up replication between different versions of SQL Server (7 & 2000). This is how the 2 servers are now setup: DB1 - External web-server w/SQL Server 7 DB2 - Internal server w/SQL Server 2000 REPLICATION SETUP
0
2032
by: Philip Trim | last post by:
General Brief: 3 SQL Servers as MS SQL Server 2000 Standard Edition with Service Pack 3 All using FTP for snapshots All Servers are both Publishers and Distributors. Server A has the correct data needed to be replicated to Server B and C. Server B and C and have blank data. Server B and C are blank databases ready for replication. Server...
1
1726
by: chandrub78 | last post by:
Hello Everyone We have a third party tool which maintains its own custom database,DB1 on SQL Server 2000 on Server A (Windows 2000). We built an inhouse application which maintains a transactional database, DB2 also on Server A derived from DB1. Since the DB1 is frequently updated the synchronisation between the databases is currently...
1
1543
by: G.Fink.Nottle | last post by:
Hello, Being a bit of a SQL Server novice, need some advice with the following situation. Server A and Server B have SQLServer 2000 based databases. The vendor of the application/system has implemented their own replication process to ensure the 2 databases are in sync. However, there is no clustering with virtual IP addresses...
2
6937
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of attending interviews. If you own a company best way to judge if the candidate is worth of it. http://www.questpond.com/InterviewRatingSheet.zip
0
12875
Coldfire
by: Coldfire | last post by:
Since i cannot show the differences in a two-column like table. I am first putting MS SQL Server 2005 and then MySQL 5.x. MS SQL Server 2005 Brief Overview - SQL Server is a full-fledged database system developed specifically for large enterprise databases. All advanced features of a relational database are fully implemented. - Once...
1
1824
by: PatrickW | last post by:
Hi, I am trying to set up a Updatable Subscriptions for Transactional Replication with SQL 2005 (queued updating). I have a stored procedure "SYS_spShellTest" which is replicated to the subscriber via the replication option "Execution of the stored procedure": -------------------------------------------------------------
0
7703
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7618
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7926
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8132
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
6286
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5222
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
1
2116
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1226
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
944
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.