Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

i am getting following error in all my websites when i am trying to access the database from websites.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Actually i have changed my server IP address.

share|improve this question
    
Was this working before and just now stopped or is this a new database server for your websites? –  TopHat Aug 15 '12 at 11:30

1 Answer 1

If your web applications are calling the SQL server via IP, it is because you changed the IP and will need to change this in your application.

If your web applications are using DNS, it is probably because the DNS entries for the server have not been updated properly, or the old for the old IP address is still there, you could check this by running WireShark on the application server and seeing where the request is going.

  1. Make sure your domain controllers have no record of the old machine name in your forward lookup zones.

  2. Make sure there is not an entry in the DHCP table.

  3. Make sure the DNS entry is not locally cached, you can check if it is on a windows machine by opening command prompt and typing ipconfig /displaydns and clear it out of the list using ipconfig /flushdns. If it stays in your dns list, make sure you do not have a host file entry for this server.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.