none
BizTalk Server 2010 TCP/IP Adapter Installation Issue RRS feed

  • Question

  • I am having issue installing TCP/IP adapter in our BizTalk Server 2010 test environment. I've downloaded the source code from tcpipbz2010.codeplex.com, compiled it and created the installation file. The installation is failing on the step where BTSTask.exe command line tool is executing trying to add schema and assemblies to BizTalk Server, specifically when it tries to connect to BizTalk management database. The error message (Error message in the Application Log -> Screenshot) states that: 


    Error: Unable to validate the given database "BizTalkMgmtDb" and server "MSBTSQLTEST". 
    Login failed for user 'DOMAIN_NAME\MSBTTEST12$'. 

    For some reason installer is trying to use server's windows user account to connect to database. I tried running the installer as myself using runas command since my windows user account has sysadmin rights on the SQL server, I tried modifying the DeployBizTalkAssembly.cs in the project specifying domain, username and password to use when executing custom action during the installation, I tried right-clicking on the Setup.exe and run with elevated permissions as administrator but none of those solutions worked. At this point I am puzzled, my main concern is why the installer using server windows user account when connecting to database and what should be the work around for it? Any help would be appreciated. 

    Art

    • Edited by imlovinit Friday, March 1, 2013 3:00 PM
    Friday, March 1, 2013 2:56 PM

Answers

  • I tried giving that user access to BizTalk management db but it didn't work. The work around for my issue was to have to create 2 separate installers, one for adapter and another one is for BizTalk components. That way I was able to install everything. Thanks for looking into it.
    • Marked as answer by imlovinit Monday, March 4, 2013 3:22 PM
    Monday, March 4, 2013 3:21 PM

All replies

  • Hi,

    From your description, would you please tell us which user account do you want to use when you connect to database "BizTalkMgmtDb"? If you add 'DOMAIN_NAME\MSBTTEST12$' in your user in SQL Server, does you work fine? You could create this user account in the instance by below links in SSMS.

    http://msdn.microsoft.com/en-us/library/ms189751.aspx

    You could reference on below thread which has similar issues.

    http://social.msdn.microsoft.com/Forums/en-US/biztalkgeneral/thread/8a7691c7-a750-4502-aeab-8f25b805d769

    Best Regards,


    Chen Yu
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Monday, March 4, 2013 7:49 AM
    Moderator
  • I tried giving that user access to BizTalk management db but it didn't work. The work around for my issue was to have to create 2 separate installers, one for adapter and another one is for BizTalk components. That way I was able to install everything. Thanks for looking into it.
    • Marked as answer by imlovinit Monday, March 4, 2013 3:22 PM
    Monday, March 4, 2013 3:21 PM
  • I tried giving that user access to BizTalk management db but it didn't work. The work around for my issue was to have to create 2 separate installers, one for adapter and another one is for BizTalk components. That way I was able to install everything. Thanks for looking into it.

    Can you share what you removed how you split the objects in the installs?

    Thanks

    Wednesday, March 20, 2013 7:00 PM
  • I tried giving that user access to BizTalk management db but it didn't work. The work around for my issue was to have to create 2 separate installers, one for adapter and another one is for BizTalk components. That way I was able to install everything. Thanks for looking into it.

    Can you share what you removed how you split the objects in the installs?

    Thanks


    Figured it out.  The user the deploy was trying to use was in SQL so I just gave it dbo access to the "BizTalkMgmtDb", the install then required me to add the BizTalk application "BizTalk.Samples.Adapter.Tcp" prior to running setup.  I also changed the connection string in the app.config for "Microsoft.Samples.BizTalk.Adapter.Tcp" to point to the server where the BizTalk databases are located.
    • Proposed as answer by ParahT Friday, May 10, 2013 6:10 PM
    Wednesday, March 20, 2013 8:38 PM