Cannot execute BizTalkHost task on a remote machine

Dec 30, 2010 at 10:39 PM
Edited Dec 30, 2010 at 11:46 PM

Hello,

Here's my script

 

  <PropertyGroup>
    <ServerName>REMOTE_SERVER</ServerName>
    <UserId>REMOTE_SERVER_LOGIN_ID</UserId>
    <Pwd>PASSWORD</Pwd>
  </PropertyGroup>

  <Target Name="default">
    <MSBuild.ExtensionPack.BizTalk.BizTalkHost UserName="$(UserId)" UserPassword="$(Pwd)" TaskAction="CheckExists" HostName="ProcessHost" MachineName="$(ServerName)"  >
      <Output TaskParameter="Exists" PropertyName="ProcessHostExists"/>
    </MSBuild.ExtensionPack.BizTalk.BizTalkHost>
  </Target>

 

Here's the output

Build FAILED.

SqlException: Login failed for user 'asunar'. 

It looks like the UserName and UserPassword properties are ignored and the script is running under my local domain account.

 

UPDATE:

When I log in to my local machine with the same REMOTE_SERVER_LOGIN_ID used in the script, it succeeds.

Any ideas?

 

Coordinator
Dec 30, 2010 at 11:07 PM

Hi

I've looked through the code and it looks like it uses integrated security to make the connection. 

                this.explorer.ConnectionString = string.Format(CultureInfo.CurrentCulture, "Server={0};Database={1};Integrated Security=SSPI;", this.DatabaseServer, this.Database);

As far as I can see (after a quick look), the credentials are not handled, so the calling identity must have access.

Feel free to raise this as an issue if it's something you need.

Mike

Jan 4, 2011 at 3:19 PM

Hi Mike,

Thanks for the response. If the code is using integrated security,are UserName, UserPassword and MachineName values being used at all?