SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Service Account


SQL Service Account

Author
Message
Jeetendra
Jeetendra
Right there with Babe
Right there with Babe (720 reputation)Right there with Babe (720 reputation)Right there with Babe (720 reputation)Right there with Babe (720 reputation)Right there with Babe (720 reputation)Right there with Babe (720 reputation)Right there with Babe (720 reputation)Right there with Babe (720 reputation)

Group: General Forum Members
Points: 720 Visits: 472
HI,

I have installed a sql server 2005 EE and started the SQL Server as well as Agent Service with the domain accounts.

But Now i want to change the Services to start with a different domain accounts but its not giving me to change the Service account.

The Service is not restarting after changing the Domain accounts.

Please let me know what needs to be done.


Kindest Regards,

Jeetendra

SQLZ
SQLZ
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1658 Visits: 940
How did you change the service account? You should change the service account using SQL Server Configuration Manager because doing so will ensure that the new account is given the necessary permissions in SQL Server. If you changed the account using the Windows Services Applet this won't happen.

Karl
source control for SQL Server
Kishore.P
Kishore.P
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1889 Visits: 619
goto windows services and select SQL Server instance, choose properties and navigate to Log on tab...



Jeetendra
Jeetendra
Right there with Babe
Right there with Babe (720 reputation)Right there with Babe (720 reputation)Right there with Babe (720 reputation)Right there with Babe (720 reputation)Right there with Babe (720 reputation)Right there with Babe (720 reputation)Right there with Babe (720 reputation)Right there with Babe (720 reputation)

Group: General Forum Members
Points: 720 Visits: 472
Changed using the Configuration Manager...
Also tried using the Services but sql server is not starting....


Kindest Regards,

Jeetendra

SQLZ
SQLZ
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1658 Visits: 940
what error message are you getting in event viewer?

Karl
source control for SQL Server
Lowry Kozlowski
Lowry Kozlowski
SSC Veteran
SSC Veteran (276 reputation)SSC Veteran (276 reputation)SSC Veteran (276 reputation)SSC Veteran (276 reputation)SSC Veteran (276 reputation)SSC Veteran (276 reputation)SSC Veteran (276 reputation)SSC Veteran (276 reputation)

Group: General Forum Members
Points: 276 Visits: 495
Are you certain that SQL2005 EE will allow you the rights to do that function? We had some developers install SQL 2005 Express and some tasks and functions were not allowed. Verify what your version can do on the microsoft site.
SuperDBA-207096
SuperDBA-207096
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2257 Visits: 711
Check the rights on the machine for the new account.
Might need to give it more rights. Quick check is to add it to the local admin group on the box SQL is running on.
Adam Haines
Adam Haines
Hall of Fame
Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)

Group: General Forum Members
Points: 3846 Visits: 3135
You should be weary of ever changing any service account through any means other than SQL Configuration Manager, this includes the Windows services menu. SQL Configuration Manager does a lot more than change the service account for a windows service. When you make a change, the configuration manager actually adds the login to a local windows group(SQLServer2005MSSQLUser). This group has rights to make SQL run including binary/registry items, file_paths, etc.. You can directly add your user to this group but best practice suggests that you use the configuration manager.

I would try the configuration manager again. You could probably change the account back to the working domain account or local system and then change it to the new domain account. This should clear up the issues.



My blog: http://jahaines.blogspot.com
Adam Haines
Adam Haines
Hall of Fame
Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)

Group: General Forum Members
Points: 3846 Visits: 3135
Check the rights on the machine for the new account.
Might need to give it more rights. Quick check is to add it to the local admin group on the box SQL is running on.

The services do not require admin privelages. Giving the service account eleveated rights is not a best practice.


Use a domain user account
Specifies a domain user account that uses Windows Authentication to set up and connect to SQL Server. Microsoft recommends using a domain user account with minimal rights for the SQL Server service, as the SQL Server service does not require administrator account privileges.

The SQL Server Agent account must have administrator privileges if you create CmdExec and ActiveScript jobs that belong to someone other than a SQL Server administrator, or if you use the AutoRestart feature. If the above features are requirements in your environment, consider using separate service accounts for the SQL Server and SQL Server Agent services.


http://msdn2.microsoft.com/en-us/library/ms143691.aspx



My blog: http://jahaines.blogspot.com
SuperDBA-207096
SuperDBA-207096
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2257 Visits: 711
Adam Haines (3/21/2008)
[quote]Check the rights on the machine for the new account.
Might need to give it more rights. Quick check is to add it to the local admin group on the box SQL is running on.

The services do not require admin privelages. Giving the service account eleveated rights is not a best practice.

Agreed - However when troubleshooting it can help rule out permissions issues. Wouldn't advise leaving it like that.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search