Error when trying to compare using PPTP VPN

Brian Donahue

Hi Dan,

Thanks for your question. Data Compare uses distributed queries to get
the data from your servers, so even though you can see both servers and the
objects on the servers, Data Compare may still give you this error, because
it's unable to set up a linked server on one of your servers. You may need
to be a SYSADMIN or SECURITYADMIN.

I'd try using the Advanced button to change the server that the
databases will be accessed from to one that you have sufficient rights to
create a linked server on.

Yours,
Brian Donahue
Red Gate Tech Support

"Dan" <dan@test.com> wrote in message news:sGa9yAIUDHA.3396@server53...
> I receive the following error message when attempting to compare 1 local
> database and 1 database over a PPTP VPN connection using an ip address for
> the server name.
> "This object cannot be viewed as an error occured during the compare
> process:
> Error comparing [dbo].[gm_agt_names]
> [Microsoft][ODBC SQL Server Driver][SQL Server][DBNETLIB][ConnectionOpen
> (Connect()).]SQL Server does not exist or access denied."
>
> I have verified that there is indeed a connection to both servers when
> attempting to compare. Any ideas why this could be occuring?
>
> Thanks,
>
> Dan
>
>

Brian Donahue

Hi,

By the way, the latest version of SQL Data Compare (3.0) doesn't suffer
from this as it's written in .Net and doesn't use linked servers any more.

Brian Donahue
Red Gate Technical Support

"Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message
news:NkSy48RVDHA.1200@server53...
> Hi Dan,
>
> Thanks for your question. Data Compare uses distributed queries to get
> the data from your servers, so even though you can see both servers and
the
> objects on the servers, Data Compare may still give you this error,
because
> it's unable to set up a linked server on one of your servers. You may need
> to be a SYSADMIN or SECURITYADMIN.
>
> I'd try using the Advanced button to change the server that the
> databases will be accessed from to one that you have sufficient rights to
> create a linked server on.
>
> Yours,
> Brian Donahue
> Red Gate Tech Support
>
> "Dan" <dan@test.com> wrote in message news:sGa9yAIUDHA.3396@server53...
> > I receive the following error message when attempting to compare 1 local
> > database and 1 database over a PPTP VPN connection using an ip address
for
> > the server name.
> > "This object cannot be viewed as an error occured during the compare
> > process:
> > Error comparing [dbo].[gm_agt_names]
> > [Microsoft][ODBC SQL Server Driver][SQL Server][DBNETLIB][ConnectionOpen
> > (Connect()).]SQL Server does not exist or access denied."
> >
> > I have verified that there is indeed a connection to both servers when
> > attempting to compare. Any ideas why this could be occuring?
> >
> > Thanks,
> >
> > Dan
> >
> >
>
>