Deploy an Application using a Service Account

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?

Answer 1

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

Thanks

Best Regards

Answer 2

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.