Q: Dynamics CRM: how to add user if you cannot login as administrator long story short, employee left the company who was the only administrator to the beginning stages of microsoft dynamics crm 2011. we have one user that can log in but he does not have administrator rights. we need to be able to create a new, administrator account so we can begin to customize microsoft dynamics crm. how can i do this without interacting with the dynamics crm interface? 

A: If you are on-premise and still have sysadmin privileges on the SQL instance you can do this via SQL. If not, you'll need to work on getting privileges to SQL.
Once you are good in SQL you can add the System Administrator role to user that currently has access. Have them login and create new Users giving them System Administrator (as appropriate.) You are now back in business.
SELECT SystemUserId, FullName FROM SystemUser

SELECT RoleId, Name FROM [Role] WHERE Name = 'System Administrator'

INSERT INTO SystemUserRoles (SystemUserId, RoleId) VALUES ('User Id for the correct user in first query', 'Role Id from the second query')

