(copy the whole link) this is on Go Daddy's help site and it helped me get set up. But fist thing is that you have to set up sql on godaddy inorder for you to connect to it.
(copy the whole link) this is on Go Daddy's help site and it helped me get set up. But first thing is that you have to set up sql on godaddy inorder for you to connect to it.
I'm now able to get the site to run, but when I'm now trying to follow the instructions from Godaddy's help page - "Grant administrator privileges to ASP.NET 2.0 Personal Web Site User Account", I'm receiving an error when I'm trying to insert the record
into aspnet_UsersInRoles table.
I"m using this format of the command and I'ver used the roleids and userids that are in the files.
INSERT INTO aspnet_UsersInRoles (RoleId, UserId) VALUES ('<roleID>', '<userID>')
The error i'm receiving is below. It doesn't make sense to me that its complaining about a key on the aspnet_Roles table when I'm trying to insert a record into aspnet_UsersInRoles table.
Why am I unable to insert the record into aspnet_UsersInRoles table?
Error -2147217873
INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK__aspnet_Us__RoleI__31EC6D26'. The conflict occurred in database 'DB_90609', table 'aspnet_Roles', column 'RoleId'.
INSERT INTO aspnet_UsersInRoles (RoleId, UserId) VALUES ('{55B830DF-E550-4BAF-B1BD-D2A06E8FA0F1}', '{3A96F0DE-FF93-4DCD-85D3-FF5FB0F56EBC}')
No, within sql on godaddy you have to make sure that the role of administrator is you. There is a table called role(not sure of complete name) check on that.
That's what i'm trying to do - set my username as an administrator within the PWS tables. My username is in the aspnet_users and there is an administrator found in aspnet_roles. Now I need to set my user as an administrator by inserting a record into aspnet_UsersInRoles.
That's where I get the error.
Error -2147217873
INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK__aspnet_Us__RoleI__31EC6D26'. The conflict occurred in database 'DB_90609', table 'aspnet_Roles', column 'RoleId'.
INSERT INTO aspnet_UsersInRoles (RoleId, UserId) VALUES ('{55B830DF-E550-4BAF-B1BD-D2A06E8FA0F1}', '{3A96F0DE-FF93-4DCD-85D3-FF5FB0F56EBC}')
check your syntax on the Values clause. You don't need ('[ if I remember correctly. There is a Go Daddy walk through on these forums that outlines the appropriate statement. I believe it is step 26. I'll look for it and post if I find it.
Here you go. It was actually in the Club Starter Kit area
Go to your public website and create an account for each admin you created on your local database. (make sure the usernames and passwords are the same!!!)
Log back into Query Analyzer
Input
SELECT RoleId FROM aspnet_Roles WHERE RoleName="Administrators"
Copy bracketed response into a text document and include the brackets
Reset QA and Input
SELECT UserId FROM aspnet_Users WHERE UserName="username"
Copy each bracketed response to your text document
Reset QA again and Input
INSERT INTO aspnet_UsersInRoles (RoleId, UserID) VALUES ('copied text from 29', 'copied text from 31')
lisa1980
Member
174 Points
227 Posts
Re: newbie - trying to publish to Godaddy
Oct 08, 2006 01:55 PM|LINK
Try this
http://help.godaddy.com/article.php?article_id=689&topic_id=&&
(copy the whole link) this is on Go Daddy's help site and it helped me get set up. But fist thing is that you have to set up sql on godaddy inorder for you to connect to it.
lisa1980
Member
174 Points
227 Posts
Re: newbie - trying to publish to Godaddy
Oct 08, 2006 01:55 PM|LINK
Try this
http://help.godaddy.com/article.php?article_id=689&topic_id=&&
(copy the whole link) this is on Go Daddy's help site and it helped me get set up. But first thing is that you have to set up sql on godaddy inorder for you to connect to it.
mtnrunner1
Member
40 Points
8 Posts
Re: newbie - trying to publish to Godaddy
Oct 08, 2006 02:16 PM|LINK
I'm now able to get the site to run, but when I'm now trying to follow the instructions from Godaddy's help page - "Grant administrator privileges to ASP.NET 2.0 Personal Web Site User Account", I'm receiving an error when I'm trying to insert the record into aspnet_UsersInRoles table.
I"m using this format of the command and I'ver used the roleids and userids that are in the files.
INSERT INTO aspnet_UsersInRoles (RoleId, UserId) VALUES ('<roleID>', '<userID>')
The error i'm receiving is below. It doesn't make sense to me that its complaining about a key on the aspnet_Roles table when I'm trying to insert a record into aspnet_UsersInRoles table.
Why am I unable to insert the record into aspnet_UsersInRoles table?
Error -2147217873
INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK__aspnet_Us__RoleI__31EC6D26'. The conflict occurred in database 'DB_90609', table 'aspnet_Roles', column 'RoleId'.
INSERT INTO aspnet_UsersInRoles (RoleId, UserId) VALUES ('{55B830DF-E550-4BAF-B1BD-D2A06E8FA0F1}', '{3A96F0DE-FF93-4DCD-85D3-FF5FB0F56EBC}')
lisa1980
Member
174 Points
227 Posts
Re: newbie - trying to publish to Godaddy
Oct 08, 2006 02:39 PM|LINK
mtnrunner1
Member
40 Points
8 Posts
Re: newbie - trying to publish to Godaddy
Oct 08, 2006 02:52 PM|LINK
lisa1980
Member
174 Points
227 Posts
Re: newbie - trying to publish to Godaddy
Oct 08, 2006 02:55 PM|LINK
mtnrunner1
Member
40 Points
8 Posts
Re: newbie - trying to publish to Godaddy
Oct 08, 2006 03:16 PM|LINK
That's what i'm trying to do - set my username as an administrator within the PWS tables. My username is in the aspnet_users and there is an administrator found in aspnet_roles. Now I need to set my user as an administrator by inserting a record into aspnet_UsersInRoles. That's where I get the error.
Error -2147217873
INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK__aspnet_Us__RoleI__31EC6D26'. The conflict occurred in database 'DB_90609', table 'aspnet_Roles', column 'RoleId'.
INSERT INTO aspnet_UsersInRoles (RoleId, UserId) VALUES ('{55B830DF-E550-4BAF-B1BD-D2A06E8FA0F1}', '{3A96F0DE-FF93-4DCD-85D3-FF5FB0F56EBC}')rhhanson63
Member
354 Points
76 Posts
Re: newbie - trying to publish to Godaddy
Oct 09, 2006 12:16 AM|LINK
check your syntax on the Values clause. You don't need ('[ if I remember correctly. There is a Go Daddy walk through on these forums that outlines the appropriate statement. I believe it is step 26. I'll look for it and post if I find it.
Bob
rhhanson63
Member
354 Points
76 Posts
Re: newbie - trying to publish to Godaddy
Oct 09, 2006 12:21 AM|LINK
Here you go. It was actually in the Club Starter Kit area
Go to your public website and create an account for each admin you created on your local database. (make sure the usernames and passwords are the same!!!)
Log back into Query Analyzer
Input
SELECT RoleId FROM aspnet_Roles WHERE RoleName="Administrators"
Copy bracketed response into a text document and include the brackets
Reset QA and Input
SELECT UserId FROM aspnet_Users WHERE UserName="username"
Copy each bracketed response to your text document
Reset QA again and Input
INSERT INTO aspnet_UsersInRoles (RoleId, UserID) VALUES ('copied text from 29', 'copied text from 31')
Repeat 28-32 for each admin account.
Welcome to your club site on GoDaddy!
That should do it.
mtnrunner1
Member
40 Points
8 Posts
Re: newbie - trying to publish to Godaddy
Oct 09, 2006 01:04 AM|LINK
Yes, those are the steps i'm following. Its step 9 that is generating the error message.
Thanks