Compare error - permissions

Brian DonahueBrian Donahue Posts: 6,590 New member
Michael,

I guess that you're still using Windows Authentication? Can you try it
with SQL authentication for both databases?

-Brian Donhaue

"Michael Bahn" <[email protected]> wrote in message
news:[email protected]
> I am getting an error when trying to compare two databases on different
> servers:
>
> The obect cannot be viewed as an error occured during the compare process:
> Error Comparing <table>
> User does not have permission to perform this action.
>
> I tried the Access the databases from this location but I still get a
> permissions error.
>
> I am a sysadmin on both databases...is there security that I can change on
> the DB to enable the compare process?
>
> Thanks for your help. I am a new user hoping to get this to work so we
can
> buy the product.
>
> Michael Bahn
> (925) 865-6447
>
>
>
>
This discussion has been closed.