Competition: What’s your favorite Redgate tool? Enter now.

Registering server

Brian DonahueBrian Donahue Posts: 6,590 New member
edited December 17, 2002 1:27PM in DTS Compare 1.x
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.

Brian Donahue.

"Robert Djabarov" <[email protected]> wrote in message
news:[email protected]
> 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.