Error Comparing
Brian Donahue
Posts: 6,590 Bronze 1
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:brian.donahue@red-gate.com
"Timothy Ross" <ross_timothy@hotmail.com> wrote in message
news:kjYHGQavCHA.1152@server53...
> 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
>
>
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:brian.donahue@red-gate.com
"Timothy Ross" <ross_timothy@hotmail.com> wrote in message
news:kjYHGQavCHA.1152@server53...
> 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.
