Error 916 - push replication from 2000 adv sp3 to 2005 express

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kk - 29 Apr 2008 19:36 GMT

using sa id (mixed security) on both

went to 2005 created push replication from 2000 (you do not see it on 2005,
but you see it on 2000 - enterprise)

replication is failing with dreaded Error 916

The server principal "MYDOMAIN\MYSERVER2000$" is not able to access the
database "MYDB" under the current security context.
(Source: MYSERVER2005\SQLEXPRESS (Data source); Error number: 916)

- bug #395119 - applies here too ?
- i think i should be able to push replicate from 2000 to 2005 express?

thank you for any sugestions

Signature

Reply to this Message

kk - 29 Apr 2008 22:06 GMT

my comunity service:

http://technet.microsoft.com/en-us/library/ms143241.aspx

http://technet.microsoft.com/en-us/library/ms189503.aspx

select * from dbo.MSsubscriber_info

-- login is already 'sa'
-- 0 - for sql servr autentication

sp_changesubscriber @subscriber = 'MY2005SERVER\SQLEXPRESS', @security_mode
= 0, @password= 'password'

Signature

> using sa id (mixed security) on both
>
[quoted text clipped - 11 lines]
>
> thank you for any sugestions

Reply to this Message