SQL Server Performance

SQL unavailable to clients

Discussion in 'General DBA Questions' started by daren.white, Jan 2, 2003.

  1. daren.white New Member

    To increase the IP range in our office we added a second subnet mask. When these machines attempt to connect to SQL we get timeouts does anybody know a way around this.
  2. satya Moderator

    What kind of errors you're getting? Which netlibs are listened to?
    Make sure there is no dropped packets in the network and use TCP/IP to connect on client and server.

    HTH

    Satya SKJ
  3. bradmcgehee New Member

    Using SQL Server over a subnet will not affect SQL Server, assuming that the router or switch and the DNS have been set up correctly. My guess is that you have a configuration problem causing your problem.


    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com

Share This Page