Registering server
Brian Donahue
Posts: 6,590 Bronze 1
Hi Robert,
Thanks for your enquiry. This almost certainly seems like a rights
issue. You can script databases in SQL Compare with any user who has access
to the databases, but the login that you need to use DTS Compare has to be a
member of the sysadmin or serveradmin roles because of the security on the
objects that DTS Compare must query. I'd suggest logging into your server
without integrated security as 'sa', and see if it works.
If this doesn't work, post back here and we can try something else.
Regards,
Brian Donahue.
"Robert Djabarov" <Robert.Djabarov@iccs-consulting.com> wrote in message
news:dMSp1PNpCHA.1428@server53...
> Hi,
>
> I am trying to register a server (SQL 2000) and am getting either Access
> denied or Timeout expired error. The same server gets successfully
> registered in both SQLCompare and in SQLDataCompare.
>
> Thanks in advance,
>
> Robert Djabarov
>
>
Thanks for your enquiry. This almost certainly seems like a rights
issue. You can script databases in SQL Compare with any user who has access
to the databases, but the login that you need to use DTS Compare has to be a
member of the sysadmin or serveradmin roles because of the security on the
objects that DTS Compare must query. I'd suggest logging into your server
without integrated security as 'sa', and see if it works.
If this doesn't work, post back here and we can try something else.
Regards,
Brian Donahue.
"Robert Djabarov" <Robert.Djabarov@iccs-consulting.com> wrote in message
news:dMSp1PNpCHA.1428@server53...
> Hi,
>
> I am trying to register a server (SQL 2000) and am getting either Access
> denied or Timeout expired error. The same server gets successfully
> registered in both SQLCompare and in SQLDataCompare.
>
> Thanks in advance,
>
> Robert Djabarov
>
>
This discussion has been closed.
