Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SQL Service Account Expand / Collapse
Author
Message
Posted Thursday, March 20, 2008 5:23 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, October 17, 2014 6:04 AM
Points: 612, Visits: 465
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

Post #472160
Posted Thursday, March 20, 2008 5:39 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 6:23 AM
Points: 870, Visits: 912
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
Post #472167
Posted Thursday, March 20, 2008 5:40 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, November 14, 2014 8:57 AM
Points: 1,391, Visits: 609
goto windows services and select SQL Server instance, choose properties and navigate to Log on tab...


Post #472168
Posted Thursday, March 20, 2008 6:44 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, October 17, 2014 6:04 AM
Points: 612, Visits: 465
Changed using the Configuration Manager...
Also tried using the Services but sql server is not starting....



Kindest Regards,

Jeetendra

Post #472198
Posted Thursday, March 20, 2008 6:46 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 6:23 AM
Points: 870, Visits: 912
what error message are you getting in event viewer?

Karl
source control for SQL Server
Post #472199
Posted Friday, March 21, 2008 6:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, November 17, 2014 12:22 PM
Points: 138, Visits: 441
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.
Post #472763
Posted Friday, March 21, 2008 7:16 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, January 2, 2013 12:15 PM
Points: 1,443, 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.
Post #472773
Posted Friday, March 21, 2008 8:08 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 11:02 AM
Points: 2,278, Visits: 3,065
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
Post #472821
Posted Friday, March 21, 2008 8:17 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 11:02 AM
Points: 2,278, Visits: 3,065
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
Post #472828
Posted Friday, March 21, 2008 8:20 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, January 2, 2013 12:15 PM
Points: 1,443, 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.
Post #472831
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse