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 |
|
RobMarsh
Starting Member
28 Posts |
 Posted - 2002-06-17 : 15:08:55
|
| We've got a new server that we are testing with a SQL7 installation. It works fine up until this morning when we discover that we have to change the IP address. So, this we do and find we can no longer connect to the database over the network. This is dispite being able to see the machine fine on the netwok in all other respects.We changed the address back to its original value, and SQL Server worked fine.Do you have any idea why this would not work?Thanks,Rob |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-06-17 : 15:42:02
|
| Not to point out the painfully obvious, but how are you attempting to connect to the server? By name or by IP address?setBasedIsTheTruepath<O> |
 |
|
|
RobMarsh
Starting Member
28 Posts |
Posted - 2002-06-17 : 15:45:02
|
| We are connecting via an ODBC link that uses the Server Name. No problem about the question though - its the simple ones that usually do the most damage... |
|
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-06-17 : 16:13:26
|
| Well, if pinging the server name returns the desired address, then perhaps re-creating the ODBC link might do the trick.setBasedIsTheTruepath<O> |
|
|
|
|
|
|
Losing the SQL Connection