I wasn't able to connect to my SQL server 2000 database (which reside in the network in a windows 2003 server) after the IP address of the server has changed and the server is shut down, moved and re-started.
I was able to connect to this server by using ADO using VB. I was able to register this server in my EM and was able to create ODBC connection. Just when using ADO.NET, I wasn't able to connect. Any ideas? Will there be any caching within ADO.NET still pointing to the old IP address?
Thank you for all the help in advance.There are a lot of variable possibilites here - -
are you using the same connection method in all scenarios (Windows/SQL authentication)?
Was the only change the IP address?
Was it working before the change?|||It was working before and I am using the same connection. What will the possible cause?
Thanks in advance.|||Have you rebooted your client? Could be the DNS/IP are cached on your client machine and need refreshing?|||I rebooted many many times and still didn't help. Any ideas?|||Someone else is having a similar problem. Have you tried using SQLProfiler to see if a connection attempt is been made and rejected or that no attempt has been made. If its the latter then that would point to .net.
