What are the challenges you face when working across database platforms? Take the survey
Options

Access to Server 2008 cannot get database list

dedlinededline Posts: 3
edited June 27, 2011 6:46AM in SQL Compare Previous Versions
Hi,

I am trying to connect to a new Windows server 2008 / Sql server 2008 machine.

I can use query analyser to login with the sa user and password, however on attempting to use SqlCompare I get the error : Aborting registering databases, timeout expired.

I have checked that the firewall allows Sql server access, TCP/IP is working, in fact all of this must be working for Query Analyser to work. Do you know what extra permissions are required to allow access ?

Many thanks,
Greg

Comments

  • Options
    In fact it's a firewall problem. Turning the firewall off fixes it so I need to know what service and ports it needs access to that woud be different from query annalyser...
  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5
    Thank you for your post into the forum.

    SQL Compare by default will connect to your SQL Server on port 1433. If your SQL Server listens on a different port number, you can specify the port number in this manner:

    <server_name>,<port_number>
    or for a named instance
    <server_name>\<Instance_Name>,<port_number>

    For account permissions, use this LINK to a knowledge base article on the account permissions require for SQL Compare.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.