Remove-NAVTableConnection

Removes a connection to an external database table from the Microsoft Dynamics NAV application.

Syntax

Remove-NAVTableConnection
      [-ServerInstance] <String>
      -ConnectionType <TableConnectionType>
      -ConnectionId <String>
      [-Force]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]
Remove-NAVTableConnection
      [-ApplicationDatabaseServer <String>]
      -ApplicationDatabaseName <String>
      [-ApplicationDatabaseCredentials <PSCredential>]
      -ConnectionType <TableConnectionType>
      -ConnectionId <String>
      [-Force]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]

Description

Use the Remove-NAVTableConnection cmdlet to remove an external table connection from the application/service. You can connect to a Microsoft Dynamics NAV database by specifying the Microsoft Dynamics NAV Server instance or the application database.

Examples

EXAMPLE 1

Remove-NAVTableConnection -ServerInstance DynamicsNAV -ConnectionType CRM
 -ConnectionId myCRM

This example removes a connection to a Dynamics CRM table from a Dynamics NAV Server instance.

Parameters

-ApplicationDatabaseCredentials

Specifies the user name and password of an SQL Server Authentication login account that provides access to the Microsoft Dynamics NAV application database in SQL Server.

You use this parameter to access the database by using SQL Server Authentication. If you want to use Windows Authentication, then you can omit this parameter The login account must be a member of the db_owner role on the database.

Type:PSCredential
Position:Named
Default value:None
Required:False
Accept pipeline input:True
Accept wildcard characters:False

-ApplicationDatabaseName

Specifies the name of the Microsoft Dynamics NAV database that contains the application tables in a multitenant deployment.

Type:String
Position:Named
Default value:None
Required:True
Accept pipeline input:True
Accept wildcard characters:False

-ApplicationDatabaseServer

Specifies the name of the computer on which the SQL Server instance for the Microsoft Dynamics NAV database that contains the application tables is installed in the multitenant deployment.

Type:String
Position:Named
Default value:None
Required:False
Accept pipeline input:True
Accept wildcard characters:False

-Confirm

Prompts you for confirmation before executing the command.

Type:SwitchParameter
Aliases:cf
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-ConnectionId

Specifies the name of the table connection.

Type:String
Position:Named
Default value:None
Required:True
Accept pipeline input:True
Accept wildcard characters:False

-ConnectionType

Specifies the type of table connection. In Microsoft Dynamics NAV 2016, you can specify two types of connection: CRM or ExternalSQL.

Type:TableConnectionType
Position:Named
Default value:None
Required:True
Accept pipeline input:True
Accept wildcard characters:False

-Force

Forces the command to run without asking for user confirmation.

Type:SwitchParameter
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-ServerInstance

Specifies the name of a Dynamics NAV Server instance, for example, DynamicsNAV or myinstance. You can specify either the full name of an instance, such as MicrosoftDynamicsNavServer$myinstance or the short name such as myinstance.

Type:String
Position:1
Default value:None
Required:True
Accept pipeline input:True
Accept wildcard characters:False

-WhatIf

Describes what would happen if you executed the command without actually executing the command.

Type:SwitchParameter
Aliases:wi
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False