Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zofobill
Starting Member
1 Post |
 Posted - 2011-04-20 : 08:18:05
|
| I have installed SQL 2008 R2 64 bit on a new Windows 2008 R2 64 bit server without any problems. I installed the software using my domain account and sql was runninhg fine. Now I need to put this server into production. When I remove my account from the local administrators group, sql doesn't run right. No one can access any databases. The SQL services are set to run using the local system acccount. What am I doing wrong? |
|
|
Jahanzaib
Posting Yak Master
115 Posts |
Posted - 2011-04-20 : 08:43:05
|
| Verify Built-In Administrator is enable in SQL Server and change the Service account as CONTROL PANEL - > ADMINISTRATIVE TOOL -> SERVICES - >SQL Server CONTROL PANEL - > ADMINISTRATIVE TOOL -> SERVICES - >SQL Server Agent JobDouble click on it and then Click on Log On tab and then click on Local Account, note it you should have administrative rights to do this ,All service related to SQL Server must be on Local AdministratorYou are using domain network so this is not a best practice to use local account for domain services if you have domain then use domain account, create a new seperate domain account for INSTANCE and Agent Job then put these services on this newly added domain accountRegards,Syed Jahanzaib Bin HassanMCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBAMy Blogwww.aureus-salah.com |
 |
|
|
|
|
|
New SQL Server R2 Installation