An error occurred while established a connection

Hello

I am getting this err msg when trying to logon to my website on the web - on my machine there is no prob,

An error occurred while established a connection to the server.
When connection to Sql.S 2005, this failure may be caused by the fact that
under the default settings sql.s doesn't allow remote connection.
(provider ql.S Network interface, error:26- Error Location Server/Interface Specified)

(the files path is like in the web host s)

now this msg is related to the ASPNETDB.MDF (dont use sql.s db but this file)

thanks

Please check this blog for solutions:

http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

|||

Do you have tcp/ip enabled on the server? If you connect from the local machine, you probably won't see the problem but when connecting from a remote machine, you will need tcp/ip enabled. Here are the steps from msdn:

Enable the TCP/IP protocol in SQL Server 2005. To do this, follow these steps:

1. Open SQL Server Configuration Manager. 2. Expand SQL Server 2005 Network Configuration. 3. Click Protocols for SQLInstanceName. SQLInstanceName is a placeholder for the name of the instance of SQL Server 2005. 4. Enable TCP/IP.

HTH