Monday, March 12, 2012

Error on (local)

An error occurred in the system, and last operation may not have completed: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)

The above error I get when I like to connect to a db for a wiki. It's on localhost and everything I found on the internet I tried. Remote connections are not relevant because it's local. Have I something forgotten?? SQL Server 2005, Asp.net 2.0

RoelAlblas:

Remote connections are not relevant because it's local. Have I something forgotten?? SQL Server 2005, Asp.net 2.0

Even on local, sometimes your website will use still use remote connection to connect to local SQL Server (for example websites deployed under IIS), so please do make sure you have enabled remote connection for the SQL instance.

No comments:

Post a Comment