Cannot login to the Analysis Center Console with SQL Authentication. (NETIQKB49980)

Cannot login to the Analysis Center Console with SQL Authentication.

Logging in to the Analysis Center Console with Windows Authentication fails.

Error: 'The request failed with HTTP status 401: Unauthorized.'

Error: 'The request failed with HTTP status 404.'

Console freezes when I select a data source.

You must configure MSDTC for network access on any Windows 2003 computer hosting an Analysis Center SQL Server or Analysis Server, or the console will lock up when you select a Data Source that references the SQL or Analysis Server on that computer. These changes require rebooting the computer, so plan a time when you can reboot.

To configure security settings:

1. Configure MSDTC for network access:
   a. Click Start > Programs > Administrative Tools > Component Services.
   b. Expand Component Services > Computers.
   c. Right-click My Computer.
   d. Click Properties.
   e. Select the MSDTC tab.
   f. Click Security Configuration.
   g. Select Network DTC Access and enable (check) the following options:
   
   Under Client And administration, the Allow Remote Administration 
   Under Transaction Manager Communication, both Allow Inbound and Allow Outbound (and Mutual Authentication Required) 
   Enable XA Transactions
   
   h. Click OK to close the Security Configuration window.
   i. Click OK to close the My Computer Properties window.
   j. Reboot the computer for the changes to take effect.

2. Verify that Anonymous Access is disabled for the ACWebService virtual directory.

   By default, the ACWebService virtual directory, under the IIS Web site you chose to host the Web Service, is configured with anonymous access disabled. If you enable anonymous access for the ACWebService virtual directory, you will not be able to start the console.

3. Verify that the ACWebService virtual directory has Windows Integrated Authentication enabled.

   By default, the ACWebService virtual directory, under the IIS Web site which hosts the Web Service, is configured with Windows Integrated authentication enabled. Windows Integrated Authentication must be enabled to start the console and successfully connect to the Web Service.

The security settings are not properly configurated. Either IIS Virtual Directory Security is incorrectly configured or MSDTC is not enabled for Network Access.

Formerly known as NETIQKB49980