I am using asp.net standard login component to access a password protected part of my site but when I try to login I get the error

"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) "

Everything works fine on my localhost computer but I get the error once I have uploaded it to the server

Any ideas what it could be? 

 Thank you in advance

SQL 2005 is not enable for remote connections, go to Surface Configuration and that's the place you enable Remote Connections.

Thanks for that, I checked with my host and remote connections are already enabled.

(by the way its me naamaGold just logged in again since I am logged in at work too)

Could it be that the database that is storing the login info has not been uploaded? Which database does it automatically create and store the info? 

Maybe there is a firewall between both computers or the port you are trying to connect is not availalble from that network. Can you give me more details?

Hello all.

Same issue. 

I am trying to upload a password protected ASP.NETwebsite to my web host.

Using MSEW with all the required settings.

As I started out with a large "membership" website, I rapidly realized that when I uploaded my folders and pages to my hosting service,  the password protected areas of the website returned errors. I am using ASP.NET controls provided in Expression Web. I was testing my ?local? site with the ASP.NET Development server and all was well. I thought that the ASP.NET Development Server was a testing tool to be used prior to upload to a hosting entity??!! My hosting service is compatible with Windows ASP.NET 2.0 with MS SQL server 2005 (I have actually tried more than one hosting service that supposed to be compatible with windows and ASP.NET 2.0 resulting in the same error) My hosting service provider tells me that there might be an error in the script but they are unable to assist any further.

To eliminate any conflicts I created a very simple 4 folder/page website to test the ability to register and login with registered name and password (all through ASP.NET controls [LOGIN] section). Not able to make it work once uploaded to hosting server. By the way I also used the MS Visual Web Developer 2008 Express to enter the ASP.NET Web Site Administration Tool to apply all the security settings. Still not able to apply the ?promising? feature of the [login] portion of ASP.NET controls.

If any of you fine people out there have a hint of where I should aim my hat, I would be truly grateful.

Thank You.

Johan

What type of details could I give you to help?

Hi

Have you specified ConnectionString in your web.config file?

Here is an example for referrence (I assume that you are using SQL 2005 Express)

    <connectionStrings><clear/>
        <add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
    </connectionStrings>

For more information, please view this link : http://msdn2.microsoft.com/en-us/library/aa478948.aspx

Hello all.

I will try once again to reach out for information how to use membership with ASP.NET 2.0. I do not master the script language and therfore was under the impression that I could use MS Expresion web together with MS Visual web Developer to try to create password protected pages/folders. My hosting service provides MS SQL 2005 database and is ASP.NET 2.0 compatible. When I run my "test" simple "membership" web site (as described in Jim Cheshire's Book Using Microsoft Expression Web) on my local machine all is well while testing it with the ASP.NET Development Server. Once I upload the site to the hosting entity, errors are returned upon trying to access the site. Is Microsoft promising to much to us less "script sawy" ??  I am not using MS SQL 2005 Express, I am truly not sure if this software is a to be on the hosting end or if this is some add on software I need to install on my local machine ? Any sugestions of literature or website that can assist in my search for success.

PS. In MS Front Page you were able to create sub sites that could be individually password protected, would like the same deal but with all the additional "bling" offered with ASP.NET 2.0.

Any help would be greatly appreciated 

Johan