New-SPAccessServicesDatabaseServer

Agrega un servidor para hospedar bases de datos de Access Services.

Syntax

New-SPAccessServicesDatabaseServer
   [-ServiceContext] <SPServiceContextPipeBind>
   [-AssignmentCollection <SPAssignmentCollection>]
   [-AvailableForCreate <Boolean>]
   [-Confirm]
   [-DatabaseServerCredentials <PSCredential>]
   [-DatabaseServerGroupName <String>]
   -DatabaseServerName <String>
   [-Encrypt <Boolean>]
   [-Exclusive <Boolean>]
   [-SecondaryDatabaseServerName <String>]
   [-ServerReferenceId <Guid>]
   [-TrustServerCertificate <Boolean>]
   [-UserDomain <String>]
   [-ValidateServer <Boolean>]
   [-WhatIf]
   [-LoginType <LoginType>]
   [-State <DatabaseServerStates>]
   [-StateOwner <ServerStateOwner>]
   [<CommonParameters>]

Description

Este cmdlet agrega servidores de base de datos de Access Services adicionales para hospedar bases de datos de Access Services.

Ejemplos

Ejemplo 1

New-SPAccessServicesDatabaseServer -ServiceContext https://siteUrl -DatabaseServerName SQLSVR01 -ValidateServer:$true

En este ejemplo se agrega el SQL Server denominado SQLSVR01 como servidor de base de datos de Access Services mediante el contexto del sitio, https://siteUrl. Esto también valida que SQLSVR01 es capaz de hospedar bases de datos de Access Services.

Parámetros

- AssignmentCollection

Manages objects for the purpose of proper disposal. Use of objects, such as SPWeb or SPSite, can use large amounts of memory and use of these objects in Windows PowerShell scripts requires proper memory management. Using the SPAssignment object, you can assign objects to a variable and dispose of the objects after they are needed to free up memory. When SPWeb, SPSite, or SPSiteAdministration objects are used, the objects are automatically disposed of if an assignment collection or the Global parameter is not used.

When the Global parameter is used, all objects are contained in the global store. If objects are not immediately used, or disposed of by using the Stop-SPAssignment command, an out-of-memory scenario can occur.

Type:SPAssignmentCollection
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
Applies to:SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

- Confirm

Solicitará confirmación antes de ejecutar el cmdlet.

Type:SwitchParameter
Aliases:cf
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

- ServiceContext

Especifica el contexto del servicio del que se va a recuperar la información de Access Services.

Type:SPServiceContextPipeBind
Position:0
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
Applies to:SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

- WhatIf

Muestra lo que ocurriría si se ejecuta el cmdlet. El cmdlet no se ejecuta.

Type:SwitchParameter
Aliases:wi
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-AvailableForCreate

Indica si el SQL Server está disponible o no para crear bases de datos de Access Services. El valor predeterminado es true.

Type:Boolean
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-DatabaseServerCredentials

Especifica las credenciales usadas para conectarse a la SQL Server.

Type:PSCredential
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-DatabaseServerGroupName

Especifica el nombre del grupo de bases de datos de Access Services. El valor predeterminado es DEFAULT.

Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-DatabaseServerName

Especifica el nombre de la SQL Server que se va a agregar.

Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-Encrypt

Especifica que se usará el cifrado SSL entre los servicios de Access y los SQL Server que hospedan bases de datos de Access Services.

Type:Boolean
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-Exclusivo

Si el SQL Server tiene AvaliableForCreate establecido en False, se actualizará a True. Si el identificador de SQL Server no coincide con el identificador del servidor de base de datos y el servidor tiene AvailableForCreate establecido en True, se establecerá AvailableForCreate en False.

Type:Boolean
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-LoginType

Indica el tipo de inicio de sesión. Los valores admitidos son:

  • ApplicationLogin

  • LocalDBApplicationLogin

  • ServerLogin

  • StorageAccountLogon

  • WindowsAzureServerLogin

El valor predeterminado es ServerLogin.

Type:LoginType
Accepted values:ApplicationLogin, LocalDBApplicationLogin, ServerLogin, StorageAccountLogon, WindowsAzureServerLogin
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2016, SharePoint Server 2019

-SecondaryDatabaseServerName

Especifica un SQL Server secundario que se va a asociar al nuevo SQL Server. Esto se usa con fines de recuperación ante desastres.

Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-ServerReferenceId

Proporcione un identificador de referencia de servidor específico. De forma predeterminada, un identificador de referencia del servidor se genera automáticamente cuando se agrega el SQL Server.

Type:Guid
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-State

Indica la disponibilidad del SQL Server que se va a agregar. Los valores admitidos son:

  • Activo

  • Bloqueado

  • Reserved

El valor predeterminado es Active.

Type:DatabaseServerStates
Accepted values:Active, Locked, Reserved
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2016, SharePoint Server 2019

-StateOwner

Especifica el propietario del estado. Los valores admitidos son:

  • NoOwner

  • TenantMove

El valor predeterminado es NoOwner.

Type:ServerStateOwner
Accepted values:NoOwner, TenantMove
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2016, SharePoint Server 2019

-TrustServerCertificate

Establece un valor que indica si el canal se cifrará al omitir el recorrido de la cadena de certificados para validar la confianza.

Type:Boolean
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-UserDomain

Especifica el dominio que se va a usar para las credenciales.

Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-ValidateServer

Valida que el SQL Server está en un estado admitido para hospedar bases de datos de Access Services.

Type:Boolean
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

Entradas

Microsoft.SharePoint.PowerShell.SPServiceContextPipeBind

Microsoft.SharePoint.PowerShell.SPAssignmentCollection

Salidas

System.Object