Welcome to ISAserver.org

SQL Replication, Netbios denied

Users viewing this topic: none

Logged in as: Guest

Printable Version

All Forums >> [ISA Server 2004 Firewall] >> Access Policies >> SQL Replication, Netbios denied

Page: [1]

Message

<< Older Topic Newer Topic >>

SQL Replication, Netbios denied - 21.Jan.2010 8:34:12 AM

afterburn

Posts: 4
Joined: 21.Jan.2010
Status: offline

I have been trying to get an external and internal SQL 2008 server to replicate; the issue is that the Linked Server related to it fails because it can not resolve the netbios name.

I need help getting ISA to allow SQL to communicate together from a specified source only to an internal source with SQL protocol and Netbios.

I have created a rule to allow netbios through but it fails never the less.

Post #: 1

Featured Links*

RE: SQL Replication, Netbios denied - 21.Jan.2010 8:49:33 AM

Jason Jones

Posts: 4663
Joined: 30.Jul.2002
From: United Kingdom
Status: offline

You probably need to configure each server with approprite LMHOSTS files, as you cannot rely on broadcast traffic.

Cheers

JJ

_____________________________

Jason Jones | Forefront MVP | Silversands Ltd
My Blogs: http://blog.msedge.org.uk/ and http://blog.msfirewall.org.uk/

(in reply to afterburn)

Post #: 2

RE: SQL Replication, Netbios denied - 21.Jan.2010 9:04:51 AM

afterburn

Posts: 4
Joined: 21.Jan.2010
Status: offline

I made an entry in both LMHOST files and still get denied

x.x.x.x RemoteServerName #PRE

Still denied in ISA 2004 monitoring

(in reply to Jason Jones)

Post #: 3

RE: SQL Replication, Netbios denied - 21.Jan.2010 9:44:42 AM

afterburn

Posts: 4
Joined: 21.Jan.2010
Status: offline

Ok, so i got the LMHOST file working correctly; i can resolve the name now.

However traffic still tries to come in on Port 138 from that machine and is being denied.

anyone know how to resolve this one?

(in reply to afterburn)

Post #: 4

RE: SQL Replication, Netbios denied - 21.Jan.2010 2:12:18 PM