[olug] [OT] Re: SQL Server Connectivity issues
justin at hotlinesinc.com
Thu May 19 16:51:46 UTC 2011
We do not run active directory, we are a small company less than 20
computers, looking for a way to get this working without issue, we really do
not want to switch to active directory!! lol After looking at SQL config I
am showing static of 1433 on all adaptors, Dynamic is disabled. All
computers are on same workgroup.
On Thu, May 19, 2011 at 10:57 AM, Rob Townley <rob.townley at gmail.com> wrote:
> Do you have MS ActiveDirectory? MS SQL Server uses name based dynamic
> ports registered in the ldap portion of ADS ( i have not see SRV
> records in DNS for MSSQL server db names, so it has got to be ldap).
> Dynamic means the actual port number changes frequently. The numeric
> port number can be changed in the middle of the day and the client app
> may not skip a beat. Clients find the numeric port number to use by
> looking up the name of the database in LDAP.
> I would also look into whether there are extra dns/winbind entries for
> your server on your lan.
> If using ADS, run repadmin /syncall and repadmin /test:* to make sure
> there is syncing between ADS servers.
> The default is 1433 and 1434. You may want to configure MSSQL to not
> be dynamic and use these static ports.
> OLUG mailing list
> OLUG at olug.org
More information about the OLUG