Hello, all I have a development server with several DB services (v16) running on it. There is no problem connecting to any of the servers on this machine via "find server", for the exception of a single service. Question: why would broadcasting differ for different services on the same machine. Below is the extract of the log:

//--------------------------

13:49:36 Attempting to connect using:
UID=dba;PWD=********;ServerName=g4_center_local;CON='SQL Central 8';LOG=c:\temp\g4_center.txt;LINKS=TCPIP();ASTART=NO
13:49:36 Attempting to connect to a running server...
13:49:36 Attempting TCPIP connection (no sasrv.ini cached address)
13:49:36 Looking for server with name g4_center_local
13:49:36 Sending broadcast to find server
13:49:36 Using broadcast address of: 20.20.21.255:2638
13:49:36 Using broadcast address of: 127.255.255.255:2638
13:49:36 Using broadcast address of: (ff02::1):2638
13:49:37 Resending
13:49:38 Resending
13:49:39 Resending
13:49:40 Resending
13:49:41     Server not found (no reply received)

//--------------------------

Thank you

Arcady

asked 22 Apr, 06:56

Arcady%20Abramov's gravatar image

Arcady Abramov
861413
accept rate: 0%

edited 22 Apr, 07:35

Breck%20Carter's gravatar image

Breck Carter
29.3k486649957

Was the server started with -sb=0?

(22 Apr, 07:41) Breck Carter

No. Must it be?

(22 Apr, 07:48) Arcady Abramov
Replies hidden

Not in your case... if it was set to 0 it might explain your symptom.

(23 Apr, 09:29) Breck Carter

If more than one DB server is running on the same Windows machine, sometimes one of them will not receive UDP broadcasts, which is how dblocate finds servers. This has been a problem on Windows forever and we have never been able to find a solution or even replicate the problem reliably.

permanent link

answered 23 Apr, 08:21

Graeme%20Perrow's gravatar image

Graeme Perrow
9.3k377119
accept rate: 53%

So no -sb=-1 switch aka "Ignore all Windows Broadcast issues"? :)

(23 Apr, 09:58) Volker Barth

Have you tried using DBLocate to see what servers (addresses & ports) exist on your network?

-sb=0 means "Ignore all broadcasts", -sb=1 means "Ignore all DBLocate broadcasts"

Starting without -sb anything means machines can find a server more easily.

permanent link

answered 23 Apr, 02:12

BradM's gravatar image

BradM
465
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×96

question asked: 22 Apr, 06:56

question was seen: 192 times

last updated: 23 Apr, 09:58