Solved

Windows Services

Posted on 2014-02-25
2
178 Views
Last Modified: 2014-02-25
I have a issue with SQL 2005 windows service. To start the service, I have to enter the domain user name and password everytime.

So in case I restarted the server, it won't work unless I manully enter the username and password. Note that I've saved the username and password but still not working. Any idea?
Thanks
0
Comment
Question by:ramziabk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 8

Expert Comment

by:jbvernej
ID: 39885042
hello,

on Which operating system ?

Did you change/type service /password with the right tool ?
With SQL Server, it MUST be done via the "SQL Server Configuration Manager" Tool and not via the usual Windows Services MMC console.

Changing the Service Account in SQLServer need some another internal actions (in the registry, probably) that the classic Windows Services MMC cann't do.

Could you try to re-change/re-type service account  and password for this SQL with only the SQL Server Configuration Manager tool ?
(and don't forget to launch this tools with the "Run As Administrator" option )
0
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 500 total points
ID: 39885059
You also need to make sure that the account is granted "Log on as a service" permissions at the group policy level, otherwise they will be lost every time the machine restarts - hence you have to enter the details again.
0

Featured Post

Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question