ASP.NET 2.0 database with login

Hi,

I very new with ASP.Net 2.0 and I am CONFUSED. I have a website that includes a login that works fine locally, but when I uploaded it to my web host (GoDaddy) the login fails. I get the error

Server Error in '/' Application.

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)

(I checked to make sure that remote connections ARE allowed. I'm using SQL Server 2005.)

The site was done using VS 2005. The ASPNETDB.MDF database was created the the App_Data folder for the login info. I thought that because this was created automatically that I didn't need to create another database on the server. I haven't found any beginner tutorials that go into enough detail about this. Can someone PLEASE point me in the right direction. Some of the FAQ's on the GoDaddy site give information about importing data into a SQL Server Database, saying to use the CSV wizard. Can an .mdf file be converted to a .csv file, and if so, how is it done? I did create a database in my GoDaddy account today, but I'm not sure how to import the data or even if I need to. Do I need to change the name of the ASPNETDB.MDF database to the same as the one on the server?

hi,

You should appropriate an applicationName to each provider :

<membership defaultProvider="CustomizedMembershipProvider">

<providers>

<add name="CustomizedMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="conStr"applicationName="YourApplicationName"/>

</providers>

</membership>

|||

Hi,

I have done this. It still doesn't work.

|||

Hi,

From your description, you are using ASPNETDB in your project, right?

Before deploying your project onto the live server, could you please make sure if your host support Microsoft SQLExpress?

If not, you should convert your ASPNETDB database to Microsoft SQLServer. You can use aspnet_regsql.exe tool to achieve that. And then, then you can upload the database to your server by using DTS(For SQL2000) or SSIS (For SQL2005).

For more information on this tool, see:
http://msdn2.microsoft.com/en-us/library/ms229862(VS.80).aspx

Thanks.