Connecting to ASPNETDB.MDF

Replace your connection strings section with this and see what you get:

 

Spooky but I'd suspect something like that.
Do you have SQL Server locally so you can re-sync everything?

 

Yes, I did, I uploaded it again. I can now check the stored procedure and it's there, on the server, but I still get the error! /emoticons/cry.gif

 

Cheers! That 'seems' to have worked. Now when I try to login it comes up with this!

Weirdly, When I connect to the database on the server in Visual Studio, and go to the stored procedure folder, visual studio crashes! Think my server-side database is corrputed?

 

Just checked and that SP error is shown in forum threads all over the net.

Does this one help?
http://forums.asp.net/p/1042979/1456396.aspx#1456396

 

Yeah, I saw them all over the internet as well.

His problem was that it stopped working after he had changed the database also he was accessing it locally. I do not have a customised aspnetdb and it works when stored locally.....

The only think I can think of is a permission issue, other topics had said dbo needs to be the owner of the database, no idea how to do this though

 

Hi,

I uploaded my ASPNETDB.MDF database, and attached it to MS SQL Server in the control panel. I have the connection string and I added it to the connection strings in my database. But how do I tell the aspnetdb.mdf database to use this new connection string? It still thinks it should be accessing it locally.

 

Post the connections section of your web.config, take out sensitive parts like your password.
We'll be able to help you then.
Salute,
Mark

 

<connectionStrings>
<add name='InsertTickets' connectionString='Data Source=tcp:sql2k512.discountasp.net;Initial Catalog=SQL2005_442327_data;User ID=SQL2005_442327_data_user;Password=*******'
providerName='System.Data.SqlClient' />
<add name='Membership' connectionString='Data Source=tcp:sql2k512.discountasp.net;Initial Catalog=SQL2005_442327_aspnetdb;User ID=SQL2005_442327_aspnetdb_user;Password=*******' providerName='System.Data.SqlClient'/>
</connectionStrings>

<membership defaultProvider='MyProvider'>
<providers>
<add
name='MyProvider'
type='System.Web.Security.SqlMembershipProvider'
minRequiredNonalphanumericCharacters='0'
connectionStringName='Membership'/>


</providers>