Authentication issues

Automated deployment for web applications and databases

Authentication issues

Postby dippies » Tue Jun 03, 2014 2:19 am

Hi All,
new_bee question.

When installing deployment manager I can choose between either SQL auth or windows auth.

I understand that if I want to use windows auth it will use the machine account (connecting as networkservice I assume).

This is not ideal for security purposes, as it means whoever is logged on to the machine will connect to SQL using whatever permissions are required by deployment manager, which would be sysadmin.

Is there no way to have the deployment manager connect to the target machine using integrated security (ie, using the credentials of the currently logged on user)? If not, it seems there is no way to ensure that people using deployment manager are in fact, for example, database administrators.


thanks
dippies
dippies
 
Posts: 7
Joined: Sun Jun 19, 2011 11:12 pm

Postby robin » Tue Jun 03, 2014 8:20 am

Hi,

Unfortunately Deployment Manager does not support impersonation for SQL connections. You can use the Project teams feature to control who can deploy projects to particular environments (this feature is only available in the paid for edition)

Robin
Robin Hellen
Test Engineer
Deployment Manager
robin
 
Posts: 20
Joined: Fri Nov 16, 2007 12:02 pm


Return to Deployment Manager

Who is online

Users browsing this forum: No registered users and 0 guests