Networks

Ask something
Discussion Locked

SQL Server registration time out

0 helpful
3 replies

by ohjani

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Where do i configure the server registration time out option? this server always has problem connecting to the other servers around the same domain tree (around 20+ computer in the whole domain), and even a simple Ping will takes at least 1-2 mins to return the result. i want to Register another SQL Server into this current server through the Enterprise Manager Console, may i know how do i overcome the time out problem?

3 replies

by timthetoolman

Hi,

You should fix your problem by fixing the network issues on that server.... Is it just the one server that has problems? Or are there others as well?

Do you get similar results if you ping by IP address rather than computer name?

If youdo, then without knowing your network, I would guess you may have a faulty or badly installed nic in that machine.

If the ping by IP address is quick, then I would guess that you have a name resolution problem and would look at how WINS is configured, which machine is acting as the master browser on your network and how busy it is and the DNS configuration if you're using that...

What I wouldn't do is force SQLServer to not timeout, as you'll be adding to the problem rather than fixing it.

Cheers,
Tim.

This discussion is closed to new replies.