Wednesday, March 7, 2012

Merge replication error

Hi,
I got this error from my SQL Server in merge replication:
[298] SQLServer Error: 8198, Could not obtain information about Windows NT
group/user 'DESIG\CHarchaoui'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
help please
Regards
is your merge agent on your subscriber listed in the PAL?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"chouaib harchaoui" <chouaibharchaoui@.discussions.microsoft.com> wrote in
message news:83785A78-D0B0-437A-9430-7284A260952B@.microsoft.com...
> Hi,
> I got this error from my SQL Server in merge replication:
> [298] SQLServer Error: 8198, Could not obtain information about Windows NT
> group/user 'DESIG\CHarchaoui'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
> help please
> Regards
>
|||Hilary ,
i'm a new DBA and is my first replication,
PAL?
"Hilary Cotter" wrote:

> is your merge agent on your subscriber listed in the PAL?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "chouaib harchaoui" <chouaibharchaoui@.discussions.microsoft.com> wrote in
> message news:83785A78-D0B0-437A-9430-7284A260952B@.microsoft.com...
>
>
|||Publication Access List - available on the publication properties. Basically
this is a list of the logins that are granted access to the publication.
When a user or replication agent attempts to log in to a Publisher, SQL
Server 2000 first checks to see if the login is in the PAL
HTH,
Paul Ibison
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thank's, now my replication start but i have some problems in merge agent,
because i have one table with a column data type : Timestamp , how change
this data type with another.
help me please .
"Paul Ibison" wrote:

> Publication Access List - available on the publication properties. Basically
> this is a list of the logins that are granted access to the publication.
> When a user or replication agent attempts to log in to a Publisher, SQL
> Server 2000 first checks to see if the login is in the PAL
> HTH,
> Paul Ibison
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>

No comments:

Post a Comment