Considerations for modifying the SQL Server service account

Source: Internet
Author: User

=========================================================================

If you are modifying the SQL Server database engine and SQL Server Agent service accounts, you can modify them in SQL Server Configuration Manager.

Here is an example of modifying the Proxy service account:

Right-click the Proxy service for the default instance and select Properties.

650) this.width=650; "title=" clipboard "style=" Border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clipboard "Src=" Http://img1.51cto.com/attachment/201410/2/639838_1412236291PCQ5.png "height=" 432 "/>

Then browse to select the new agent service account you want to use.

650) this.width=650; "title=" clipboard[1] "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clipboard [1] "src=" Http://img1.51cto.com/attachment/201410/2/639838_1412236296Dsvq.png "height=" 484 "/>

If you are modifying a service account for Reporting Services, there is no way to modify it in Configuration Manager.

650) this.width=650; "title=" clipboard[2] "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clipboard [2] "src=" Http://img1.51cto.com/attachment/201410/2/639838_14122363059B5q.png "height=" 435 "/>

You will find the attribute inside, where there is no modification to the account.

650) this.width=650; "title=" clipboard[3] "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clipboard [3] "src=" Http://img1.51cto.com/attachment/201410/2/639838_1412236310LYrO.png "height=" 484 "/>

This time we need to open the Reporting Service Management tool, select "Service Account", make relevant changes.

650) this.width=650; "title=" clipboard[4] "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clipboard [4] "src=" Http://img1.51cto.com/attachment/201410/2/639838_1412236320zNY1.png "height=" 484 "/>

=========================================================================

This article from "Zeng Hung Xin Technical column" blog, declined to reprint!

Considerations for modifying the SQL Server service account

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.