Deploy an Application using a Service Account RRS feed

  • Question

  • User-848295090 posted

    Can you use a service account to publish an application to IIS and SQL Server?

    I have an application that has a database back-end and want to publish it using a service acount. The publish wizard asks for username and password?

    Monday, August 5, 2013 9:24 AM

All replies

  • User-1454326058 posted

    Hi kjmcad,

    Thanks for your post!

    According to your description, I have some questions as follows:

    1. What tool that you are used? (e. g Visual studio, web matrix)
    2. Which way of you to publish an application? (e. g Web Deploy Package and create a package and import it into IIS, using the deploy.cmd)
    3. What is the service account used for?

    As far as I know, SQL Server account is specified in your configuration file and if you use the Web Deploy Package method there isn’t need to provide account in Visual studio publish wizard.(More information, please refer to: http://msdn.microsoft.com/en-us/library/dd465323.aspx )

    Base on your requirement, I suggest that you can publish (deploy) a web project by using the Visual Studio one-click publish feature, for more information, please refer to: http://msdn.microsoft.com/en-us/library/dd465337.aspx

    Some benefit information:

    Deploying a Web Application Project Using a Web Deployment Package, please refer to: http://msdn.microsoft.com/en-us/library/dd483479(v=vs.100).aspx

    Install a Deployment Package Using the deploy.cmd, please refer to: http://msdn.microsoft.com/en-us/library/ff356104.aspx


    Best Regards

    Thursday, August 8, 2013 5:46 AM
  • User-848295090 posted

     No. I should have put more details in my post. I am trying to setup a build definition in Visual Studio 2012 so that every time I check-in my code it deploys it to my web server.

    1. I created a publish xml file and tested it straight from VS (my machine) to the web server. - Works great!

    2. Created a build definition - Under Process --> 3. Advanced --> MSBuild Arguments I have

    /p:DeployOnBuild=true /p:AllowUntrustedCertificate=True /p:PublishProfile=Section3Admin_Dev /p:DeployTarget=MsDeployPublish /p:CreatePackageOnPublish=False /p:MSDeployPublishMethod=RemoteAgent

    When I execute the build script it says the USER NOT AUTHORIZED. 

    Now I had read somewhere where the account that the build agent runs under on the build server (which is a service account) needs admin permission to the web server. I added the service account to the admin group on the web server but it is still not working. 

    Please help me.

    Thursday, August 8, 2013 11:09 AM