Sql server 2000 setting up windows service accounts

The pendulum has swung again with SQL , especially if you install on Windows or above. On Windows , SQL uses a new concept of Service Sid, and you should always change the service account using Management Studio in order to get the proper security set up.

When I give food to the poor they call me a saint. I don't think the service account needs to be a local admin. If I remember correctly, we ran lots of SQL instances under a domain account that was not a local admin.

EM assigns the rights needed. I believe your account the account making the change needs to be an admin on the target box to create the service account. It worked after restarting the server. No authentication request was sent from the server to the AD.

You must be logged in to reply to this topic. Login to reply. October 25, at am Hi, I want to change service account and Agent service account, from local system account to windows authentication account.

Note that using local Windows accounts also just as with Local System accounts affects the ability to access remote resources over the network. In effect, domain user accounts are used most commonly in addition, management of local accounts in larger environments tends to be cumbersome.

Go to page: 1 2 Next. Search Search. This service serves all instances sharing the same physical computer. Full-Text Search Service MSSearch - facilitating full-text searches, including creation and management of index catalogs.

Microsoft Distributed Transaction Coordinator MSTDC - responsible for managing distributed transactions - also shared among all instances on a single physical computer. Acceptable Use Policy. Advertiser Disclosure:. SQL Etc. Installation fails if you launch setup through Remote Desktop Connection with the media on a local resource in the RDC client. To install remotely the media must be on a network share or local to the physical or virtual machine.

SQL Server installation media may be either on a network share, a mapped drive, a local drive, or presented as an ISO to a virtual machine. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback? Submit and view feedback for This product This page.