June 12, 2011 at 8:44 pm
Hello All,
we have a vendor installing database software and I initially install SQL server 2008. Apparently when I installed it I used different accounts, I guess for start up purposes.
They are telling me that SQL Server, Agent, and Analysis Services shoul all use a specific log in account.
The account they are asking is an AD account. How would I go about changing this?
We are using SQL Server 2008 R2
Thanks in advance
Mike
June 12, 2011 at 9:36 pm
One option is to use the Configuration Manager as described in the following URL:
http://msdn.microsoft.com/en-us/library/ms345578.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 15, 2011 at 12:55 pm
Yes use the config manager only. Do not just go into the Windows Services panel and change it.
June 15, 2011 at 11:56 pm
Another option is
Administrative Tool - > Services - > SQL Server
Administrative Tool - > Services - > SQL Server Agent
Administrative Tool - > Services - > SQL Server Analysis Service
you have to create first domain or AD account then go to these Services and then Right Click and then click Properties and then change the Account as go to LOG ON tab and then click on option
THIS ACCOUNT and then define your newly created account for Services use do this same for the rest 2 Services
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
June 16, 2011 at 5:39 am
I thought that I read that Microsoft does not want the ID's to be changed in the services panel.
June 16, 2011 at 6:04 am
The accounts used for the SQL services should only be changed via the SQL Configuration Manager. While changing them via the Windows services may work, it is not recommended as there are other permissions that need to be set as well which the SQL Configuration Manager does for you.
see
http://msdn.microsoft.com/en-us/library/ms143504(v=SQL.100).aspx
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply