Last post Jul 05, 2008 01:30 PM by email@example.com
Jun 23, 2008 11:37 PMfirstname.lastname@example.org|LINK
When I execute in Godaddy's SQL Server Web Admin page the following T-SQL statement
SELECT RoleId FROM aspnet_Roles WHERE RoleName = 'Administrators'
No rows returned
I need the return value so i can grant administrator rights
This is the 4th SQL DB I've connected to asp.net sites I've set up on Godaddy.
I can't recall the wierd hoop they want me to jump through. Godaddy seems to do it their way
and not tell you how they did. In creating your tables, you have to replace dbo with SQL login name.
That is never mentioned. It's like teaching your kid the wrong way to speak english,
sure it's fun but they're gonna get the crap beat out of em at school.
Jun 24, 2008 02:16 PM|jeremyh|LINK
You need to make sure that you have a user defined and the account is approved then member of the admin group.
You will find the step on
Hope it helps
Jun 24, 2008 06:42 PMemail@example.com|LINK
Yes, but no rows returned on the 1st T-SQL query.
I did this and I have administrator now
exec aspnet_Roles_CreateRole '/', 'Administrator'
Jul 05, 2008 01:30 PMfirstname.lastname@example.org|LINK
The issue was administrator didn't exist