I changed the nic on a sql server 2008 server and gave the server a new
ip address. The server has access to the LAN and the internet, but I
can't connect to it using odbc from any other box on the lan. The sql
server can be pinged from other machines and is generally ok on the
network, other than the sql server aspect.

I read somewhere that sql server does not keep an eye out for IP address
changes, but so far have not found anything definitive re this issue or
a fix.

On the server-side you may need to register

ipconfig /registerdns


Client-side you may need to flush

ipconfig /flushdns



--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"mat" wrote:

Thanks for the reply. Those commands did not help.

Something else that is strange is that even though the sql server
browser service is running on both boxes, the expected server is not
shown on the client side odbc dialog when the server dropdown list is
opened.

The server is called Server02. It's sql server is 2008 express. I would
expect to see Server02\sqlexpress listed, but it's not there. Instead I
see "Server02", as if it'd been set up as the default instance. Using
Server02 as the server name fails also. And, on the server02 box, the
odbc server dropdown list does show the sql instance as Server02
\sqlexpress.

Hopefully that provides enough of a clue for someone to diagnose this.

In article <Odlz0PYkKHA.3792 (AT) TK2MSFTNGP02 (DOT) phx.gbl>,
DSPatrick (AT) nospam (DOT) gmail.com says...

Try substituting the ip address for the server name. If that works then it
is probably a stale DNS records issue.



--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"mat" wrote:

I should have mentioned that I tried that 'long ago'. Using the IP
address does not help. This is really vexing...

In article <uVxlvpYkKHA.4380 (AT) TK2MSFTNGP04 (DOT) phx.gbl>,
DSPatrick (AT) nospam (DOT) gmail.com says...

Maybe this one helps.

http://support.microsoft.com/kb/244980



--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"mat" wrote:

It's not a cluster of course. But I did poke around in that area. Not
sure if anything is wrong there or not, everything looks ok.

I decided to change the ip address back to the original and it's still
not visible or available to other machines on the lan. The sql server is
set to allow remote connections. What else can I try?

In article <#gAbtuZkKHA.4500 (AT) TK2MSFTNGP06 (DOT) phx.gbl>,
DSPatrick (AT) nospam (DOT) gmail.com says...

Why was the NIC changed? What errors in the system event log?



--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"mat" wrote:

It's an older box with 100 gbit nic; newer is a gigabit lan card. The
built in nic is disabled now, and after it was disabled I changed it's
ip address, else couldn't assign that ip to the new nic.

There are no erros for sql server in the log.

In article <e9InmPakKHA.1536 (AT) TK2MSFTNGP06 (DOT) phx.gbl>,
DSPatrick (AT) nospam (DOT) gmail.com says...

Seems like it should have worked. You may want to examine logs from within
Management Studio under SQL Server Agent\Error Logs and or follow up with
the errors generated client side.


--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"mat" wrote: