Access to Server 2008 cannot get database list

dedline · June 25, 2011 11:33AM

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 · June 26, 2011 12:17PM

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...

Eddie D · June 27, 2011 6:46AM

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

Access to Server 2008 cannot get database list

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk