Search Unity

  1. Megacity Metro Demo now available. Download now.
    Dismiss Notice
  2. Unity support for visionOS is now available. Learn more in our blog post.
    Dismiss Notice

SQL Windows Authentication for Analyic Server

Discussion in 'Scripting' started by VulstaR, Oct 21, 2014.

  1. VulstaR

    VulstaR

    Joined:
    Sep 10, 2014
    Posts:
    4
    Hello, im working on a project where I need to use an Analysis server with Unity. But got some issues connecting to the sql analytics server 2012 from Microsoft.

    I hope someone knows how to connect using Windows Authentication with the standard unity library, if this is even possible (since analytics server can only be accessed with windows authentication).
    Also I cant set a provider= in the connection string.


    "Provider=SQLNCLI11.1;Data Source=localhost;Integrated Security=SSPI;Initial Catalog=AdventureWorksDW2012"

    Or

    "Provider=MSOLAP.5;Data Source=localhost;Integrated Security=SSPI;Initial Catalog=AdventureWorksDW2012"

    Are the connectionstrings I wanted to use. And I tried some different ones aswel, but Security to false with a login will not work!(cuz windows authentication).


    I hope someone knows how to do this, else I will have to check for a dll or lib that supports these functions. But then it will be harder to reach mobile platforms aswel I guess.
     
    Last edited: Oct 21, 2014