I have put something similar in place a couple of years ago.. I do a simple count on Publisher tables, and a count at the destination, then query to find...

I seem to remember hitting a similar problem. Can you tell me what you have in the connection settings for the subscriber?

Open subscription Properties - Security section

You choose the agent...

we failed back over to node a and the problem has gone... I guess it could be an issue with Node B and we wont find out till we failover...

no it has not failed over (well its running on B the failover node anyway not A) ..

cannot access any sql error logs via SSMS get the error I mentioned...

No doesnt seem to be any change. we have servers on SP3 + various CU's and the MDAC version is still the same...2.82.3959.0 for all components.

maybe something like this...

select

i.[object_id],

i.index_id,

p.partition_number,

p.rows as [#Records],

a.total_pages * 8 as [Reserved(kb)],

a.used_pages * 8 as [Used(kb)]

from

sys.indexes as i

inner join

sys.partitions as p

on i.object_id = p.object_id

and i.index_id = p.index_id

inner join

sys.allocation_units as a

on p.partition_id =...

Yes thanks Greg, was rushing a bit with that one!

One thing also to note... you say you only want them to have permissions to run and edit the jobs.. and...

Can you log onto the server/ remote it using one of the domain accounts that are failing? (when failed over)

If that works then maybe the password(s) on the proxy user/credentials...

has the server got an instance name?

i.e. D-DB01\CORP ?

If so the connection will need to be example:

10.250.15.26\CORP

or using the Port so

10.250.15.26,1433 or 10.250.15.26,2080 (depending on...

all replication tasks create sql agent jobs..

all I have done is add steps before/after the replication jobs for snapshot generation and the distrubution to a remote server\database that call either...

Assign these roles to the user/login..

SQLAgentOperator, SQLAgentReader, and SQLAgentUser

SQLAgentOperatorRole Permissions

SQLAgentOperatorRole is the most privileged of the SQL Server Agent fixed database roles. It includes all the permissions of SQLAgentUserRole and...

Yes I have just hit this issue and am looking for a good way around it...

as for giving them admin we did not allow this - we simply added the...

You are already the 'dbo' of the database so why are you trying to add yourself in again?

If you wish to change who the dbo is then you need to...

.

Hi Everyone!

Just thought I would update you, I tried a clean restore of the database and ran a rebuild index job then a shrink, and blow me down with a...