Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Changed IP Address Now Can't Connect

Author  Topic 

DaveGKeller
Starting Member

10 Posts

Posted - 2011-01-21 : 16:19:54
We updated our database from MSDE to SQL 2008 Express. All went well. Due to a change in the office (not my department) we have to change the IP address on the server. Now I can't connect (through VB code). The code is accurate because it worked without a problem on the old IP address. I have changed IP address in the SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for OurInstanceName -> TCP/IP -> IP Addresses to reference the new IP Address. I can connect using the IP Address (or Server Name), InstanceName, PortAddress through SQL Server Management Studio. The only thing I can think of is that the d/b was installed on one IP and now has a different one.

Is there anything a newbie (that's me) can do that might fix this problem. I am thankful for any help that anyone can give me.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-01-21 : 16:29:04
Try running "ipconfig/flushdns" on the command line on the machine that's trying to connect. After that, check the hosts file in its C:\Windows\System32\drivers\etc\ folder and see if there's an entry for the old IP address.
Go to Top of Page
   

- Advertisement -