Deployment Center Not Listing db Users

Vote:
 

Hi,

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?

#79769
Jan 06, 2014 0:01
Vote:
 

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.

#80162
Jan 16, 2014 4:48
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.