A small problem with Managed Service Accounts

re: A small problem with Managed Service Accounts

Dave Ryan — Fri, 01 Jun 2012 22:57:33 GMT

I was also able to add it to the groups for SQL Server and change the service account in services.msc and was able to run it successfully except that it broke replication. I added the MSA to a group and added the group to all of the permissions necessary for transactional replication but it still failed to run the replication job successfully so I'm assuming there are still issues in 2008 R2.

re: A small problem with Managed Service Accounts

Andrew.Fryer — Sun, 16 May 2010 09:55:05 GMT

Looks like managed service accoutns still aren't supported for SQL Server as per http://technet.microsoft.com/en-us/library/ff641729(WS.10).aspx

However there is no clear reason why not, given tagt exchange and IIS both make use of this new feature

Andrew

re: A small problem with Managed Service Accounts

gregoricst — Thu, 13 May 2010 06:44:29 GMT

Any update on the bug report? I'm having the same problem, can't use managed service account in SQL 2008 R2 setup....

re: A small problem with Managed Service Accounts

Tim — Tue, 04 May 2010 17:23:18 GMT

Now that SQL Server 2008 R2 is RTM, is there anything new on this? Would like to be able to directly specify a managed service account in SQL Server setup.

re: A small problem with Managed Service Accounts

Kocko — Sun, 21 Feb 2010 10:07:53 GMT

Am I going to experience any problems, not regarding backup, if I use the Services Applet to change to a service account?! I'm trying to install Sharepoint 2010 from this walkthrough:

http://andreasglaser.net/post/2009/11/18/Installing-SharePoint-Server-2010-on-Windows-Server-2008-R2-and-SQL-Server-2008-R2-Part-7-SQL-Server-2008-R2-installation-and-configuration.aspx

, but everything(incl Active Directory) is on one machine?!

re: A small problem with Managed Service Accounts

Kocko — Sun, 21 Feb 2010 10:00:45 GMT

Hi, there!

I'm also trying new things out. Now i follow this walkthrough on installing Sharepoint 2010 on my machine:

http://andreasglaser.net/post/2009/11/18/Installing-SharePoint-Server-2010-on-Windows-Server-2008-R2-and-SQL-Server-2008-R2-Part-7-SQL-Server-2008-R2-installation-and-configuration.aspx

After googling a lot, I left NT Authority\System account for SQL Server Agent account. When using <mydomain>\SqlServiceAccount$(created with the "New-ADServiceAccount" command), SqlServer 2008 R2 Installation stops me with the error: "The specified credentials for the sql server agent service are not valid. to continue provide a valid account and password for the Sql Server Agent Service" Am I going to experience any problems when I change the account from the Services Console to a managed service account, not regarding backup?!

re: A small problem with Managed Service Accounts

Andrew.Fryer — Mon, 23 Nov 2009 12:35:30 GMT

Simon

Yep that'll work it's just like a few things around the edges of SQL Server it's not supported

Andrew

re: A small problem with Managed Service Accounts

Simon Sabin — Tue, 17 Nov 2009 12:32:12 GMT

Doing it in the services applet is fine if you then go and add the account to the local group that is setup for SQL. Its the really long group name like *SQLServer2005MSSQLUser$ONARC-VHST02$SQL2005