|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
| ms.sqlserver.setup Questions about SQL Server. |
 |
|
|
LinkBack | Outils de la discussion |
29/04/2008, 20h00
|
#1 |
Messages: n/a
Hébergeur: |
Service Pack requirements
I should know this - but do you need to have Sysadmin rights in order to
apply a SQL Server 2005 Service Pack? Thanks. |
|
|
29/04/2008, 20h27
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: Service Pack requirements
Yes, the account you use for the instance which is going to be upgraded,
should have System Administrator right. -- Ekrem Önsoy "Neil W." <neilw@REMOVEnetlib.com> wrote in message news:%23w590LiqIHA.4808@TK2MSFTNGP04.phx.gbl... >I should know this - but do you need to have Sysadmin rights in order to >apply a SQL Server 2005 Service Pack? Thanks. > |
|
|
|
29/04/2008, 20h38
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: Service Pack requirements
"Ekrem Önsoy" wrote in message
news:3C2F017D-857D-479F-AB2F-B84277A018E4@microsoft.com... > Yes, the account you use for the instance which is going to be upgraded, > should have System Administrator right. What will happen if they are in, say, the securityadmin or setupadmin roles, but not the sysadmin role? Is there any way to allow one of those lesser roles to apply a service pack? Thanks. |
|
|
|
30/04/2008, 09h13
|
#4 |
|
Messages: n/a
Hébergeur: |
Re: Service Pack requirements
Any other role would not work. Only "sysadmin".
-- Ekrem Önsoy "Neil W." <neilw@REMOVEnetlib.com> wrote in message news:uerVLhiqIHA.4292@TK2MSFTNGP04.phx.gbl... > "Ekrem Önsoy" wrote in message > news:3C2F017D-857D-479F-AB2F-B84277A018E4@microsoft.com... >> Yes, the account you use for the instance which is going to be upgraded, >> should have System Administrator right. > > What will happen if they are in, say, the securityadmin or setupadmin > roles, but not the sysadmin role? Is there any way to allow one of those > lesser roles to apply a service pack? Thanks. > |
|
|
|
| Outils de la discussion | |
|
|
