Hello sir,

My probleme with a replication already existe. I install the replication between two servers (serv1,serv2); every thing is ok now; but when i want to subscibe serv2 i receive this message: ->Error 229:EXECUTE permission deniede on object sp_subsrcibe, database master, owner dbo. I am the administrator, i don't understand that???? I use SQL 6.5 and Windows NT 4.0. The mode security in both server is standard.

Any advice please.

-- Anonymous, October 08, 1999

Answers

Tezniti,

sp_subscribe checks that it is run from a remote server rather than locally. Make sure that you are not invoking in locally.

Hope this helps,

Eric

-- Anonymous, October 11, 1999