Monday, March 19, 2012

Locating S

I recently uploaded my site to the internet. But now, when I try to to log in, I receive the following error message:

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

How do I fix this?


I assumed you mean you get this error when you uploaded your site to your hosting service.

This error usually means that your ASP.NET application is trying to connect to a SQL Express database. In general, very few webhosting provider support SQL Express because it is not intended for production use. Does your host offer SQL 2005? If so, migrate your data to the SQL 2k5 database and update your application's connection string in the web.config (or in the code itself) to point to the SQL 2k5 database.

Hope this helps.

|||You're right. Thanks for the help. Fixed it now.

No comments:

Post a Comment