Attaching mdf data file kills logins

If you mean the db login you created on your local machine, I'm afraid it will not be able to carry over to our server. You will need to log into your discountasp control panel and under Database Manager create the SQL login and then login with the main db login and provide that newly created db login with dbo privilages.

rcp
DiscountASP.NET
www.DiscountASP.NET

 

Hi,

Thanks for the response. I'm actually talking about the security account that is created by discountasp.net (in my case 'SQL2005_313257_ewedding_user')

My current error is:
Cannot open database "SQL2005_313257_ewedding" requested by the login. The login failed.
Login failed for user 'SQL2005_313257_ewedding_user'.

And this is using the same authentication information that I've been using all along... just isn't working after I attached the new mdf.

Thanks,
Chad

 

When I upload the mdf, it loses my SQL login information. How would one take an mdf from a local database and make sure that when it's attached @ discountasp.net that the logins will still be there?

Thank you