Solved

Windows Services

Posted on 2014-02-25
2
167 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
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

Integrate social media with email signatures

Is your company active on social media? Do you also use email signatures? Including social media icons in your email signature is a great way to get fans for free. Let all your email users know you’re on social media quickly and easily, in a single click.

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now