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.
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. |
 |
|
|
|
|