Creates or updates a mapping between a connection on the local instance of Querona and a security account on a remote data source.
[ @rmtsrvname = ] ‘rmtsrvname’
Is the name of a connection that the login mapping applies to.
rmtsrvname is sysname, with no default.
[ @useself = ] ‘TRUE’ | ‘FALSE’ | ‘NULL’
Determines whether to connect to rmtsrvname by explicitly submitting a login and password. The data type is varchar(8), with a default of TRUE.
A value of TRUE specifies that Querona will authenticate to rmtsrvname using its service account security context (WIA), with the rmtuser and rmtpassword arguments being ignored.
FALSE specifies that the rmtuser and rmtpassword arguments are used to connect to rmtsrvname for the specified locallogin.
If rmtuser and rmtpassword are also set to NULL, no login or password is used to connect to the data source.
[ @locallogin = ] ‘locallogin’
Is a login on the local server. locallogin is sysname, with a default of NULL. NULL specifies that this entry applies to all local logins that connect to rmtsrvname.
If not NULL, locallogin can be a standard login or a Windows login. The Windows login must have been granted access to Querona either directly,
or through its membership in a Windows group granted access.
[ @rmtuser = ] ‘rmtuser’
Is the remote login used to connect to rmtsrvname when @useself is FALSE.
When the remote server is an instance of SQL Server that does not use Windows Authentication, rmtuser is a SQL Server login.
rmtuser is sysname, with a default of NULL.
[ @rmtpassword = ] ‘rmtpassword’
Is the password associated with rmtuser. rmtpassword is sysname, with a default of NULL.