Database access from BizTalk?

Discussion in 'Databases' started by Bruce, Jun 27, 2005.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Bruce

    Bruce DiscountASP.NET Staff

    hmm.. i do not have much experience w/ biztalk. i am sure biztalk can support SQL authentication but I can't be sure.

    sorry/.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Jun 27, 2005
    #1
  2. Nils

    Nils

    I am trying to follow a step-by-step guide on how to access an SQL server from BizTalk.
    However, it seems to work only for the local database. What do I need to do access the remote SQL server at DiscountAsp.net? (I am to able to connect to the remote databasefrom regular Visual Studio .NET applications)
    I suspect I need a Trusted Connection. How do I set up that?
     
    Nils, Jun 27, 2005
    #2
  3. Nils

    Nils

    But the question is how do I setup that for the SQL-server? I really don't know that I am talking about,
    but I looks like I should not logon with user id and password, right? Can I configure the database to accept a 'trusted connection'? In other words, arethereany changes I need to do on the server side? Do I need to set up some 'priviledges' or what? I am just a programmer.
     
    Nils, Jun 28, 2005
    #3
  4. Bruce

    Bruce DiscountASP.NET Staff

    trusted connection only work if domain user is used. you can rarely find this in shared hosting environment.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Jun 28, 2005
    #4
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page