Re: Change SQL Service Account
- From: kalvin.tuel@xxxxxxxxx
- Date: Thu, 10 Jul 2008 14:25:45 -0700 (PDT)
A follow up to my own question to state what I found worked.
I finally downloaded from Microsoft the eval version of SQL Server
2000 from: http://www.microsoft.com/downloads/details.aspx?familyid=D20BA6E1-F44C-4781-A6BB-F60E02DC1335&displaylang=en
When installing it I only installed the client tools which installed
Enterprise Manager. I used EM to change the Service Account to my new
user. EM takes care of permissions.
You do have to make sure if you have your database (.mdf or .ldf)
files anywhere other than the default data directory for SQL Server
that your new user has permissions to those folders.
I couldn't find anything else that worked for SQL Server 2000 MSDE.
Including following Microsofts recommendations of how to do it at
http://support.microsoft.com/kb/283811 I also gave full control to my
new account to everything on the C: drive and anything in the registry
that had the word SQL in it as well as the WindowsNT\peflib node.
Nothing worked except using EM.
Hopefully that helps someone else in distress.
Kalvin
On Jul 10, 11:51 am, kalvin.t...@xxxxxxxxx wrote:
Thank you very much for your response.
I can't find Configuration Manager for SQL 2000 MSDE. Where would I
find the Management Studio or Configuration Manager for MSDE?
Kalvin
On Jul 3, 11:42 pm, "bass_player" <bass_pla...@xxxxxxxx> wrote:
There are a lot of reasons for this. One could be that the account you are
using does not have permissions to start a service or your account has been
locked out due to other reasons while you are logged in (I've seen this a
lot of times where a generic account is used and then it gets locked out
while a user is logged in using the same account). Another is not enough
permissions on the account to do what it needs to do as a SQL Server service
account. It is recommended to use the SQL Server tools (Management Studio
or Configuration Manager) when configuring user accounts as the tools
resolve the necessary ACLs needed by the account to
run as a SQL Server service account.
<kalvin.t...@xxxxxxxxx> wrote in message
news:950f4759-0402-4675-ae46-014024cd9961@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I need to change the SQL Service Account for SQL Server 2005 Express
to something that is not Admin or LocalSystem. I have followed the
steps outlined inhttp://support.microsoft.com/kb/283811andin the
BOL. When I attemp to start the service using the new limited priv
account I get error 5 "Access is Denied". I think this is a Windows
permissions issue but I don't know what else to check. Just to be
sure I gave the new account Full Control on the installation drive but
still couldn't start the service. What could I be missing? Is there
a handy tool somewhere that will do this for me, in SQL 2005 Express.
Thanks.
Kalvin- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -
.
- References:
- Change SQL Service Account
- From: kalvin . tuel
- Re: Change SQL Service Account
- From: bass_player
- Re: Change SQL Service Account
- From: kalvin . tuel
- Change SQL Service Account
- Prev by Date: RE: Time Slicing
- Next by Date: Re: Custom default data folder
- Previous by thread: Re: Change SQL Service Account
- Next by thread: Data Analyst III: Contract Position with SolutionsIQ in Kirkland, WA
- Index(es):
Relevant Pages
|
