We are having issues with listing the users when creating an EPiServer database. All the dropdown in the EPiServer Deployment Center lists is the sa users. This is only when trying to create a database on a network db server we use for development, it works fine with the local instance of SQL Server.
How does the tool get the list of users? Are there any special permissions needed or is it just doing a query on sys.database_principals?
We found the issue for this, the DBA's tell me that Sql Server will only list your user and sa with the default permissions unless your are a serveradmin. So if the user you are using with the installer is not a Server admin then that user will need to be given permissions to list the user that EPiServer will use.