Re: sqlserver 2000 new subnet mask login problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 07/07/04 

Date: Wed, 7 Jul 2004 09:43:30 +0100

Hi

It seems that when you change the mask it stops you seeing the remote
system. You don't give a reason to change the mask, or what the IP addresses
are, but at a guess you are either changing the subnet in the wrong location
e.g in a VPN configuration rather than the local network or the mask is
wrong for your network.

John

"Hubert Mayr" <huma1@gmx.net> wrote in message
news:1089095587.822786@news.liwest.at...
> Hi!
>
> I have a windows 2000 server and must change my subnet mask from
> 255.255.255.0 to 255.255.248.0.
> I made that also on my client computer.
> My problem:
>
> when I link now with access (latest version) these sqlserver tables (with
> ODBC sqlserver) I get the following error message:
>
> Microsoft SQL Server Login:
>
> Sqlstate '01000' Sql Server Error: 53
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
> Error on Connection
> Sqlstate: '08001'
> Sql Server Error: 17
> ...
>
> when I change my subnet to the old value all is running.
> what is my problem?
>
> Thanks
>
>
>

Relevant Pages

  • Re: TCP/IP question,PLEASE!
    ... mask is and how to apply it to IP address. ... a subnet is. ... For hosts to be in the same subnet, they must have the same network address. ... A host address's components: ...
    (microsoft.public.windowsxp.general)
  • Re: VPN Clients and subnet, NOT the usual "255.255.255.255 subnet mask" question!
    ... subnet mask for your subnet route. ... The reason is that this mask is generated ... own local subnet through the VPN. ... Remember that even if you have a proxy server configured in your ...
    (microsoft.public.windows.server.networking)
  • Re: two subnets on one network
    ... Subnet MASKS, the subnets are the networks the masks are the 255.255.etc ... machines, but this may not even matter if you don't have a LOT of machines ... If a machine incorrectly thinks it is on a different network it will send ... That looks like NEITHER a Supernet nor a subnet, NOR a subnet mask. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Adding new subnets
    ... We already have routers for the point to point ... connect the 10.1.1.0 and 10.1.4.0 networks. ... >> up a new subnet for that office. ... >> networks to talk to each other I am going to change the subnet mask on our ...
    (microsoft.public.win2000.networking)
  • Re: DHCP configuration of superscopes
    ... > With a subnet mask of 255.255.255.0 ... and both machines I will use this mask: ... machine with 192.168.2.5 is the "sending host". ... destination host, but rather send it to the router. ...
    (microsoft.public.win2000.dns)