Sorry, this is something of a newbie question which I'll post background to if required - but see first if the problem is just straightforward.
A new episerver site has been created and the rolemanger is windowsprovider. This allows the locally logged in user ability to get to edit/admin modes. Under admin mode however, the windows provider is not able to create new users. Fair enough. So, change to sqlserver provider in web config but then am unable to get to edit/admin at all, as no exists under that provision.
How to get new site installs (whether through episervermanager or visual studio using episerver item) to default to sqlserverprovider as the role and user manager?
How to add a user for an install that has defaulted to windowsprovider but subsequently changed to sqlserverprovider?
I don't think the first option is possible.
For creating sql server users/roles, you need to open the project in visual studio.
Click on menu Project->ASP.NET configuration manager and you can use the security options to create roles/users. Remeber to create a role called 'Administrators' and add a user to that role. You may run the EPiServer application and login with that user id.
Another way if you don't have access to visual studio, is to switch your provider to MultiplexingRoleProvider and MultiplexingMembershipProvider (in web.config).
This will allow you to access both windows & sql server roles and users. Then you can login to EPiServer Admin mode using a local Administrator, create the necessary groups and users and then switch into full sqlserver provider.