Setup mdf attachment steps

Can anyone give me the steps for making my mdf database work.
This is what I did? I already have my database working on my local machine.
these are the steps I perform:
1.I upload them to my web site database/app_data area on my web site.
2.I went to my addon database area use the tool to attach mdf database.

when i go to my web site and try to add new user to my web site database, I get this error:

http://www.mybuddplant.com:80/error.htm?aspxerrorpath=/login.aspx
Physical Path E:\web\mybuddplant\htdocs\error.htm
Logon Method Anonymous
Logon User Anonymous

HTTP Error 404.0 - Not Found
The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.

I really appreiate some help!
Thanks

 

Customerror to Off

Thanks bruce i turn the customerrror="Off" and got the correct error here it is. can anyone tell what wrong.


A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

 

my connectionstring is:

<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=tcp:sql2k802.discountasp.net;Initial Catalog=*****USER*****;User ID=username; Password=*******;" providerName="System.Data.SqlClient"/>


what do you mean post your connection string in the web.config(mask out uid/ password pls). please explain?

 

I've masked the Username for you. Basically means to hide the username and password for security reasons.

 

Connection Good

Thank again Bruce and everyone else that help, I find out how to connection my database and they are working fine now...you guy r Great!
I really appreciated it.

 

Hi Bruce,
Did you mean that with the <configuration > tag or those extra tags are there coz you just copy pasted the block ?

 

Login failed

I'm trying to get my website login to function.

Here is what i have tried:

*Uploaded aspnetdb via visual studio 2008
*connected aspnetdb via data base management
*added the following tags in web config:

<connectionStrings>
<clear />
<add name="LocalSqlServer" connectionString="Data Source=tcp:sql2k803.discountasp.net;Initial Catalog=SQL2008_721788_aspnetdb;User ID=SQL2008_721788_aspnetdb_user;Password=******;" providerName="System.Data.SqlClient" />
</connectionStrings>

I get the following error:

Server Error in '/' Application.
--------------------------------------------------------------------------------

Login failed for user 'SQL2008_721788_aspnetdb_user'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'SQL2008_721788_aspnetdb_user'.

help please!

 

@h2owells. . .

What is the current status?
If it is still not working I'd suggest verifying the remote files and records.
If you don't have a local SQL Server to do this with you can use the DASP on-line tool.
https://sqlwebadmin.discountasp.net/

We can get you through this, may not be easy but we'll get'er done ;-)
All the best,
Mark