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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2011-10-18 : 18:28:14
|
| Hi,I will install sql server 2008 standard edition 64 bits on windows 2008 64 bits.This is new client. I don't have access. Usually we have domain service account to install and other dba activities. Here network team will create my account and will give me server admin access on that computer. My question is:Should I use my domain account for installation and to start each service. sql server, agent. etc. In previous envirionment we use domain user account for all dbas not personnel account. Secondly if I select mixed authentication and give sa password, how client now what is sa password. Where I should document these info?Thanks |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-10-19 : 03:51:32
|
| Yes you should ALWAYS use domain account.But the domain account should have admin rights on the machine where you are doing the installation.For your second questionThe account against which you are doing the installation will automatically get the sysadmin rights on the database server.Once installation is done you can change the password.PBUH |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-10-19 : 13:30:04
|
| Thanks for reply.My question is: Whether they should create my domain account and grant privileges on serverorI should use same domain account if it is already created in that environment and used by other dbas to install sql server which are already in environment. So Should I ask them to give me domain service account/password which is already there for installation purpose?Thanks |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-10-19 : 14:25:25
|
| As I said any installation you do with a particular account will automatically get sysadmin on the sql instance.It would be fine if you are OK if the domain account which already exists is granted sysadmin rights for the new instance.PBUH |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-10-19 : 15:48:00
|
| Sachin thanks for help. |
|
|
|
|
|
|
sql server 2008 installation