EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB9691: How to enable Windows Authentication for MicroStrategy Office in IIS.


Community Admin

• Strategy


This article describes how to enable Windows Authentication for MicroStrategy Office in IIS.

Like Strategy Desktop and Strategy Web, users can log into a project from Strategy Office using Windows Authentication mode when the Strategy Office Web Services are hosted on a Microsoft IIS Web Server.
To implement this feature, perform the following steps:
 

  • Link a Strategy user to a windows user in Strategy Developer, by going to Authentication - Metadata, as shown below:
ka04W000001MKyPQAW_0EM440000002HgP.png
  • Go to the Strategy Web Services machine and locate the ProjectSource.xml file under C:\Program files\Strategy\Web Services. Change the 'AuthMode' node to 'MWSNTCredential', as shown below:
     
    <ProjectSource>
    <ProjectSourceName>Strategy Tutorial</ProjectSourceName>
    <ServerName>localhost</ServerName>
    <AuthMode>MWSNTCredential</AuthMode>
    </ProjectSource>
  • Go to Internet Information Service management console and click on the Strategy Web Services virtual directory then go to Authentication:
ka04W000001MKyPQAW_0EM440000002Hge.png
  • Make sure that ASP.NET Impersonation and Windows Authentication are enabled and Anonymous disabled as seen below:
ka04W000001MKyPQAW_0EM440000002Hgj.png
  • Restart the Web Server.

Now open a Strategy Office application, such as Excel, and click on the Strategy button. Users then see the Connect to Strategy window.
 
Notice that Windows Authentication is now enabled for login to the Strategy Tutorial project. Users can click on the 'Get Projects' button to access the project without providing password:
 

ka04W000001MKyPQAW_0EM44000000293V.jpeg

 
The reason that the Connect to Strategy window is displayed is because Strategy Office can connect to multiple project sources even though different authentication modes might be used within a different project source. As the screen shot below indicates, My First Project is using Standard Authentication:

ka04W000001MKyPQAW_0EM44000000293X.gif

 


Comment

0 comments

Details

Knowledge Article

Published:

March 31, 2017

Last Updated:

March 31, 2017