Error Comparing

Brian DonahueBrian Donahue Posts: 6,590 New member
Hi Tim,

Thanks for your question. This is a security issue. Because you have to
traverse the first server to get to the second, you're logging onto the
second server as an anonymous user. To get around this, go to the 'Compare
Databases' window and click 'advanced'. Now select 'Access servers from this
location', and type in the name of the SQL server you are currently using.
This will create a linked server that will pass your credentials correctly
to SERVER2.

Please don't hesitate to contact me if you have further questions.

Brian Donahue

Technical Support Engineer

Red Gate Software Ltd.

T: +44 870 1600 037

E: mailto:[email protected]



"Timothy Ross" <[email protected]> wrote in message
news:[email protected]
> Very strange error (seams to me to be a bug).
>
> When I do a SQL data compare with:
> SERVER1 and
> SERVER2
>
> I get the following error:
> This object cannot be viewed as an error occured during the compare
process:
> Error comparing [dbo].[table_name]
> [Microsoft][ODBC SQL Server Driver][SQL Server][DBNETLIB][ConnectionOpen
> (ConnectOpen (Connect()).]SQL Server does not exist or access denied.
>
> if I do a SQL data compare with:
> SERVER2 and
> SERVER1
>
> The compare works fine!!!! I haven't done anything -- no re-register, no
> refresh -- just "flip-floped" the two servers being compared.
>
> Anybody know what going on with this error?
>
> Thank you in advance,
> TR
>
>
This discussion has been closed.