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

An error 1059 - (The Service did not Start due to a logon failure)

I installed SQL Server on my PC and it has been running fine for a few
months. Now I cannot start it but get this message:
----
--
An error 1059 - (The Service did not Start due to a logon failure) occurred
while performing this Service Operation on the MSSLQServer)
----
--
I recently changed by network password; Is there something that has to be
done to SQL Server when this is done ?It sounds like the services are running under your windows
account. If that's the case, you need to change the password
for the service accounts if they are the same as yours.
Looks like this is SQL Server 2005 so you can use the SQL
Server Configuration Manager to change the password for the
services.
-Sue
On Thu, 27 Jul 2006 12:19:02 -0700, rmcompute
<rmcompute@.discussions.microsoft.com> wrote:

>I installed SQL Server on my PC and it has been running fine for a few
>months. Now I cannot start it but get this message:
>----
--
>An error 1059 - (The Service did not Start due to a logon failure) occurred
>while performing this Service Operation on the MSSLQServer)
>----
--
>I recently changed by network password; Is there something that has to be
>done to SQL Server when this is done ?