Error 229greenspun.com : LUSENET : SQL Server Database Administration : One Thread |
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
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