Compare error - permissions
Brian Donahue
Posts: 6,590 Bronze 1
Michael,
I guess that you're still using Windows Authentication? Can you try it
with SQL authentication for both databases?
-Brian Donhaue
"Michael Bahn" <michael.bahn@pmigroup.com> wrote in message
news:YVKMBus$CHA.2800@server53...
> 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
>
>
>
>
I guess that you're still using Windows Authentication? Can you try it
with SQL authentication for both databases?
-Brian Donhaue
"Michael Bahn" <michael.bahn@pmigroup.com> wrote in message
news:YVKMBus$CHA.2800@server53...
> 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.
