SQL 2000 & NetBIOS/Name Resolution

[ADB100]

With the following scenario will NetBIOS be required?

A Windows 2000 Server with SQL 2000 installed and a database configured. 2 Pull other W2K Servers with SQL 2000 configured to replicate the database (Pull). These servers are located in different IP Networks/Subnets so must traverse IP Routers to reach the Database Publisher.

I am quite happy DNS Name resolution is working OK but I would like to know whether I will need NetBIOS Name Resolution running (WINS or LMHosts file) for any of SQL 2000's underpinnings? I would ideally like to switch off NetBIOS on these 3 servers if possible.

Thanks

Andy

 

[rdroske]

No. If you did include netbios you would also need something in addition because its not routable on its own.

You don't need netbios to use WINS or LMHOST name resolution either. Netbios name resolution is seperate from all of these and DNS, done by broadcast which commonly doesn't work through routers.

 

[ADB100]

I think maybe you misunderstood the question - I am talking NetBIOS over IP - not Native NetBIOS/NetBEUI. I fully understand that NetBIOS/IP name resolution in a routed IP environment requires either WINS or LMHosts files (or IP Helpers etc). BUT, my question was whether SQL 2000 makes any 'calls' to the NetBIOS stack on the PC; and hence requires some form of NetBIOS/IP Name Resolution available.

Thanks

Andy

 

[rdroske]

Still No.

 

[ADB100]

OK. Let me ask another couple of questions then, bearing in mind that I have these Servers in a Router IP network and they are all located on different IP Subnets:

How can I tell if an SQL 2000 server is configured to use NetBIOS? And is this configurable once the Server has been installed?
If I completely disable NetBIOS (i.e. through TCP/IP Properties and check Disable NetBIOS over TCP/IP and also have no LMHosts files or WINS running) will SQL replication have any problems?

I apologise for stressing the point but the responses I am getting from the database people (I am really a networking guy) are that I MUST have NetBIOS Name Resolution configured (WINS or LMHosts). The problem is they can't seem to justify or explain why ???

Thanks

Andy