[olug] [OT] Re: SQL Server Connectivity issues

[Justin Reiners]

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
> https://lists.olug.org/mailman/listinfo/olug
>