Export (0) Print
Expand All

How to Change the Credentials for SQL Server Analysis Services Account

Updated: November 1, 2013

Applies To: System Center 2012 - Service Manager, System Center 2012 R2 Service Manager, System Center 2012 SP1 - Service Manager

If the account that is used for the SQL Server Analysis Services account changes in System Center 2012 – Service Manager, you must also change the credentials for the account. Use the following procedure to change the credentials for the SQL Server Analysis Services account.

To change the credentials for the SQL Server Analysis Services account

  1. On the computer hosting SQL Server Analysis Server (SSAS), click Start, click All Programs, click Microsoft SQL Server 2008 R2, and then click SQL Server Management Studio.

  2. In the Connect to Server dialog box, complete these steps:

    1. In the Server Type list, click Analysis Services.

    2. In the Server Name list, select the server name for your Service Manager or data warehouse databases.

    3. In the Authentication list, select Windows Authentication, and then click Connect.

  3. In Microsoft SQL Server Management Studios, in the Object Explorer pane, expand Databases, expand DWASDataBase, expand Data Sources, and then double-click DWDataMart.

  4. In Data Source Properties – DWDataMart, under Security Settings, click the ellipsis button (…) next to ImpersonateAccount.

  5. In the Impersonation Information window, select Use a specific Windows user name and password, type the credentials for the new account, and then click OK.

  6. Click OK to close Data Source Properties – DWDataMart, and then close Microsoft SQL Server Management Studios.

-----
For additional resources, see Information and Support for System Center 2012.

Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.
-----
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft