Remote Connection Issue

I have researched over and over on how to solve the error code below. I have tried every suggestion under the moon and still get the same error. Please provide some insight. Here is exactly what I have done regarding the remote connection issue:

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)

History:

1. Created a test site on my local machine (using MS Visual Web Developer 2005 Express Edition) call WebSite8 for test purposes.

2. Simply created a single page to allow users to create an account by dragging and dropping the CreateUserWizard onto the designer screen.

3. Performed some basic formatting (font, theme, etc) on the web control.

4. Ensure that TCP/IP and allow remote connection defaults were changed to allow remote connections.

5. Verfied that the login control worked on my local machine. Everything worked fine. I was able to create two new users and was sent to the "complete" portion of the control.

6. Opened the aspnet_memberships and aspnet_users databases to ensure that the two test accounts were created....everything good so far.

7. Copied all files from WebSite8 (1. App_Data Folder - includes ASPNETDB.MDF file created by Developer when I dragged and dropped the CreateUserWizard onto the designed sreen, 2. the main asp web page I called createaccount.aspx, and 3. web,config file) via ftp to my test web site hosted by 1and1. My test web site is named something different that WebSite8.

8. I created a test.htm page on the 1and1 web site to link to the createaccount.aspx page which is in the same path as the test.htm.

9. The process let me enter the user name, password, etc but when I hit submit, I get the error listed below.

10. Followed some other research suggestions and verified that ApplicationName in the aspnet_Membership was set to "/". It is.

11. I checked the web.config file and it does not seem that any connection strings were created when I dragged the CreateUserWizard onto the screen. Not sure if this is an error on this control or not or if it is ok as is(?)

I believe there is some sort of issue on the hosted web site where the sql server is not linking to the database on the hosted site and is likely trying to link back to my "local" server.....just a feeling.

I have tried everything that I can think of after performing relentless research on this error. I am new to database programming, ASPNET 2.0, SQL, etc but I catch onto things very quickly.

Did you try this:

right click on the server in the object explorer, properties, select a page -- connections and make sure the allow remote connections is checked...hope this helps -- jp

|||I have enabled remote conections as mentioned in my step-step process and trouble shooting above.