3 Replies Latest reply: Apr 30, 2013 8:23 AM by goodrum RSS

WFA MS SQL Datasource authentication

Francois Egger Cyclist
Currently Being Moderated

I tried without chance to acquire from MS SQL datasource with windows authentication.

It work fine with a local SQL account.

 

Help appreciate,

François

  • Re: WFA MS SQL Datasource authentication
    abhit NetApp Employee Cyclist
    Currently Being Moderated

    Hi Fancois:

    Thanks for your question. Can you please elaborate what is the problem.

    It will help us to understand better.

     

    Abhi

    • Re: WFA MS SQL Datasource authentication
      Francois Egger Cyclist
      Currently Being Moderated

      Hi Abhi,

       

      I created a custom Shema that content tables used for workflow. The source become form a MS SQL server and actualy I have to use a local user in SQL server for import, i tried with Active Directory User without chance. Access denied

      Capture.PNG

      Thx for your help

      • Re: WFA MS SQL Datasource authentication
        goodrum NetApp Employee Cyclist
        Currently Being Moderated

        If you haven't taken a look yet, the steps for setting up a vCenter Data Source is actually quite helpful here.  The steps required to use that Data Source are the same required to connect to most MsSQL environments.  If you are creating a new user then you will need to confirm that the user has the appropriate credentials on the database as well as logging into SQL  Look at the 2.0 version of the IAG since it looks like half the steps were removed in the 2.0.1 version. 

         

         

        Jeremy Goodrum, NetApp

        The Pirate

        Twitter: @virtpirate

        Blog: www.virtpirate.com

More Like This

  • Retrieving data ...

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points