Last post Aug 08, 2013 11:09 AM by kjmcad
Aug 05, 2013 09:24 AM|kjmcad|LINK
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?
Aug 08, 2013 05:46 AM|Starain chen - MSFT|LINK
Thanks for your post!
According to your description, I have some questions as follows:
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:
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:
Some benefit information:
Deploying a Web Application Project Using a Web Deployment Package, please refer to:
Install a Deployment Package Using the deploy.cmd, please refer to:
Aug 08, 2013 11:09 AM|kjmcad|LINK
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.