Sec_Server_Principal database parameter
Description
When you access an SAP Adaptive Server Enterprise database
in PowerBuilder through Open Client, Sec_Server_Principal
is one of several parameters that support login authentication for
network-based security services. (For other login authentication
parameters, see the See Also section.)
Sec_Server_Principal specifies the principal
name of the server that you want to access. The server
principal name is the name by which your security mechanism
identifies each server.
If the server name (specified in the database profile or Application)
is different from the server principal name
for the server you want to access, you must set Sec_Server_Principal
to the correct server principal name in order to connect.
You must specify a value for Sec_Server_Principal before connecting
to the database in PowerBuilder.

For information about the third-party security
mechanisms and operating system platforms that Sybase has tested
with Open Client security services, see the Open Client documentation.
Controls
-
ASE, SYC SAP Adaptive
Server Enterprise
Syntax
1 |
Sec_Server_Principal='<span>server_principal_name</span>' |
Parameter |
Description |
---|---|
server_principal_name |
Specifies the principal name of the server |
Default
None
If you do not specify a value, the security mechanism uses
the server’s directory entry name, which is the same as
the server name specified in the database profile or Application.
Usage
When to use
When you use Open Client security services with PowerBuilder,
the server’s directory entry name (which you specify as
the server name in the database profile or Application) might differ
from the server principal name. In this case, you must set
Sec_Server_Principal to the correct server principal
name so that the security mechanism can identify the server you
want to access.
Set Release parameter
For this parameter to take effect, you must also
set the Release parameter to 11or higher to specify that your application
should use the appropriate version of Sybase Open Client Client–Library
(CT-Lib) behavior. See the description of the Release parameter
for more information.
Requirements for use
To use Sec_Server_Principal or any other
parameter supporting Open Client security services, you must meet
certain requirements for using security services in your PowerBuilder application.
For details, see “Requirements for using Open Client security
services” in Connecting to Your Database.
Corresponding CT-Lib connection property
Specifying a value for Sec_Server_Principal
sets the corresponding Sybase CT-Lib connection property named CS_SEC_SERVERPRINCIPAL.
Examples
To specify SYS12NT as the principal name of the server
you want to access:
-
Database profile
Type
SYS12NT
in the Server
Principal Name box on the Security page in the Database Profile
Setup dialog box. -
Application
Type the following in code:
1SQLCA.DbParameter="Sec_Server_Principal='SYS12NT';Release=12"