KB16552: How to configure MicroStrategy Intelligence Server 9.x to connect to a Microsoft SQL Server database using NT authentication

To configure Strategy Intelligence Server 9.x to connect to a Microsoft SQL Server metadata database using NT authentication, follow the steps below:
 

• Create a DSN to the Metadata. If users wish to test connectivity of this DSN, check the box 'Use Windows NT Authentication for login ID', as shown below.
   
  

• Go to the Strategy Service Manager to make sure Strategy Intelligence Server 9.x is running on an NT account which has proper privilege to access Metadata. Users can find Service Manager at Start > Programs > Strategy > Tools > Service Manager, as shown below:
  

•  
  NOTE: Metadata connections from the Strategy Intelligence Server 9.x will attempt to login using Strategy Intelligence Server service account. If this network account does not exist within SQL Server, the user will receive the 'Not a trusted SQL Server connection' error message.
   
  
• Launch the Configuration Wizard to configure Strategy Intelligence Server 9.x. After selecting the DSN created at step 1, users can leave 'User Name' and 'Password' blank and click Next to continue configuration, as shown below:
  

• Follow instruction in the Configuration Wizard to the end and restart Strategy Intelligence Server.