Compare error - permissions

Brian DonahueBrian Donahue Posts: 6,590 New member

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 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
> buy the product.
> Michael Bahn
> (925) 865-6447
This discussion has been closed.