How can we help you today? How can we help you today?

Access to Server 2008 cannot get database list

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
dedline
0

Comments

2 comments

Sort by
  • dedline
    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...
    dedline
    0
  • Eddie D
    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 D
    0

Add comment

Please sign in to leave a comment.