title: OPENROWSET & SQL Server 2008 Security (SSAS)
body: <p>I try to fill a SSAS Mining  Model with Data from a (local) SQL Server Table</p>
  
  <p>Both SQL Server and SSAS (all 2008) are on the same (devlopment machine) WinXP64.
  SQL Server Security is 'Windows Authentication'</p>
  
  <p>MDX Code:</p>
  
  <pre><code>INSERT INTO MINING STRUCTURE [ttseries]
  (
  [col1],
  [col2],
  [col3],
  [col4]
  )
   OPENROWSET(
  'SQLOLEDB',
  'Server=(local);Trusted_Connection=YES',
  'SELECT col1, col2, col3, col4 FROM  [MYDB].[dbo].[MYTable]')
  </code></pre>
  
  <p>If I execute the statement I recieve the error message:</p>
  
  <blockquote>
    <p>Error (Data mining): Ad hoc
    connections as specified in OPENROWSET
    clauses cannot be used on this server.</p>
  </blockquote>
  
  <p>I already adjusted the SQL Server Setting for Key</p>
  
  <blockquote>
    <p>"Ad Hoc Distributed Queries" to 1</p>
  </blockquote>
  
  <p>-> this was one of the common problems I found during my research, but it didn't help.</p>
  
  <p>What else do I have to change or setup?</p>
  
  <p>Thanks for your help!
  alex</p>