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-12 : 12:36:43
|
| Hi,I am assigned to multi client envirionment. I don't have access to any client right now. What privileges I need to perform DBA activities i.e. installation new instance, upgrade, migration. How can I get Sysadmin privileges on new server. I am think just to add my account to local admin group. Any thing else? Thanks |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-10-12 : 14:07:43
|
| From within Management Studio, open your Server -> Security -> Server Roles. Add your Login to the sysadmin builtin Role. If you don't have an explicit Login, it's because you are a member of a Windows level Group (e.g., Local Administrator). Be aware that while the Local Administrator is by default a member of sysadmin Role, this can be changed.=======================================Faced with the choice between changing one's mind and proving that there is no need to do so, almost everyone gets busy on the proof. -John Kenneth Galbraith |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-10-12 : 15:11:41
|
| Thanks for reply. My question is different.Right now I don't have access to windows server. Once I have access, then I can install sql server. So my question was what type of access I need on windows server to have full control, I think sys admin. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-10-13 : 07:32:00
|
| You need to be a admin on the server.Also what access role is your account going to have on the network ?PBUH |
|
|
|
|
|
|
New Account Access