CODEWITHSUNDEEP
asp.netsql-server-2005
zod
zod

Reputation: 2788

Problem connecting to a SQL server database from a ASP.NET application

I get the following error whilst trying to connect from an ASP.NET web application from a particular server to an instance of SQL Server 2005 on a different server.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

This article lists 5 steps: http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

We have eliminated each of these (there is no firewall).

Running the application on a different web server (in the same network) and it can connect to the database. Similarly, running the database on a different server, and the application can see it. It appears to be a problem between these two servers.

The problem occurred at random. It was working one minute, then not, and hasn't been working since. Nothing was installed or changed (as far as I can work out) on the server.

Any ideas?

Thanks

Upvotes: 0

Views: 479

Answers (1)

Xhalent
Xhalent

Reputation: 3944

Have you tried connecting using an IP address rather than a qualified server name in the connection string? Sometimes the remote server can not be resolved but the IP address can be, depending on domain/network dns setup.

Upvotes: 2

Related Questions