Should there be a record in aspnet_Users? When I try to activate the user account using the following:
SELECT UserId FROM aspnet_Users WHERE UserName = '<username>'
It finds 0 records.
I was able to grant administrator privileges using until I get to the specific user.
SELECT RoleId FROM aspnet_Roles WHERE RoleName = 'Administrators'
1 record affected
SELECT UserId FROM aspnet_Users WHERE UserName = '<username>'
0 record affected
What you need to do is run the select statement on your development DB, and the insert statement into your production site. For the username select, you need to pass a valid username in the select statement, like 'admin' if you are not. Based on the above,
it looks like you trying to select a user named 'username'.
You can use your SQL Server management studio to connect to the godaddy server where u have already created a database and then execute SQL queries from your local system, which i tried and worked perfectly.
hey, i got the same error once, its kinda annoying. But all i could do was to , uninstall and install SQl Server back again, You can get the back-up of your databases from
here (http://kenanbek.com/site/2011/09/asp-net-mvc-configure-and-publish/) you can find detailed information of how to publish ASP.NET (MVC) project to godaddy
rhhanson63
Member
354 Points
76 Posts
Re: newbie - trying to publish to Godaddy
Oct 10, 2006 04:12 PM|LINK
Here is your SQL response from above:
Should there be a record in aspnet_Users? When I try to activate the user account using the following:
SELECT UserId FROM aspnet_Users WHERE UserName = '<username>'
It finds 0 records.
I was able to grant administrator privileges using until I get to the specific user.
SELECT RoleId FROM aspnet_Roles WHERE RoleName = 'Administrators'
1 record affected
SELECT UserId FROM aspnet_Users WHERE UserName = '<username>'
0 record affected
What you need to do is run the select statement on your development DB, and the insert statement into your production site. For the username select, you need to pass a valid username in the select statement, like 'admin' if you are not. Based on the above, it looks like you trying to select a user named 'username'.
Bob
awsok
Member
62 Points
19 Posts
Re: newbie - trying to publish to Godaddy - Poor support from Godaddy
Jun 24, 2007 11:45 PM|LINK
Hi and thanks for the blog about generating the membership stored proceduers.
jinithjoseph
Member
2 Points
1 Post
Re: newbie - trying to publish to Godaddy
Dec 01, 2010 04:43 AM|LINK
Hi,
You can use your SQL Server management studio to connect to the godaddy server where u have already created a database and then execute SQL queries from your local system, which i tried and worked perfectly.
Hope this helps in some way!
tubby_aftab
Member
10 Points
5 Posts
Re: newbie - trying to publish to Godaddy
Dec 23, 2010 09:08 AM|LINK
hey, i got the same error once, its kinda annoying. But all i could do was to , uninstall and install SQl Server back again, You can get the back-up of your databases from
C:\ProgramFiles\MicrosoftSQLServer\MSSQL.1\MSSQL\Backup\your_database_name.bak
And also note that, C: could vary to D:, E: or watever, depending on wat your active partition is. But mostly, it is the C:
Just restore the database back again once you have re-installed SQL .
Kenan Bek
Member
2 Points
1 Post
Re: newbie - trying to publish to Godaddy
Sep 23, 2011 05:19 AM|LINK
here (http://kenanbek.com/site/2011/09/asp-net-mvc-configure-and-publish/) you can find detailed information of how to publish ASP.NET (MVC) project to godaddy