BookmarkSubscribeRSS Feed
Fox_3
Calcite | Level 5

Friends, I want to establish a connection to the server which is on the different machine to my sas eg Please any one can help?

1 REPLY 1
Patrick
Opal | Level 21

From the SAS EG Help:

Managing Profiles

Add a profile

The Create Profile window enables you to create a profile for a connection to a server.

To create a new profile

  1. Double-click the connection icon in the lower right corner of the SAS Enterprise Guide window. You can also select Toolsarrow Optionsarrow Administration and then select Modify in the Connections area.
  2. In the Connections window, click Add to open the Create Profile window.
  3. Specify a name and description for the profile.
  4. Specify the server machine to which the profile connects. You can use either a remote machine or your local machine. If you use your local machine, the machine name is automatically set to localhost and you only need to specify a port. If you use a remote machine, you must specify both a machine and a port. 
  5. Specify user authentication to the server. Select Use Integrated Windows Authentication to specify that the credentials that are used to authenticate the user to the Windows desktop also be used to connect to the server. If you do not select this option, you must specify the user ID and password for connections to the server.
  6. If you select Use Integrated Windows Authentication, you can select the Advanced button, which displays the Advanced Settings dialog box. Use this dialog box to specify these settings:
    Security package
    specifies the security protocol that is used to authenticate logged-on users to the server. Here are the possible values:
    Kerberos
    specifies that the server uses the Kerberos protocol to exchange authentication tokens with the client.
    NTLM
    specifies that the server uses the NTLM protocol to exchange authentication tokens with the client.
    Negotiate
    specifies that the server negotiates with the client to use one of the protocols that are listed in the Security package field.
    Service principal name (SPN) specifies an SPN to be used in place of the generated SPN for the server. The SPN is a string that specifies the server that you are trying to connect to. This field should normally be left blank, which specifies that the generated SPN is used. You can specify an SPN in the following cases:
    • The server is not running as a local service.
    • You are using a cluster of servers that need to be accessed using the same SPN.
    Enter the SPN by using the format SAS/host:port (for example, SAS/d1234.mycorp.com:8561). Security package list specifies the security packages to use with the Negotiate protocol. The server tries to use the first package listed, and then uses the second package if the first package is not supported.
  7. Select Save login in profile to store the connection credentials with the profile.
    Note: If your administrator has set the SAS metadata password policy to disable saved credentials, then selecting this box has no effect, and the selection is not saved in the profile.
  8. Specify the authentication domain for the profile to allow resource use without prompting. When a user tries to use a resource (such as a server or library), the authentication domain of the resource is compared to the value that is specified in the profile. If the domains match, the user can access the resource without entering any credentials. This field is used only if the profile connects to a SAS Metadata Repository Server.
  9. Click Save to save all specified values and close the window, or click Cancel to discard all values and close the window.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 460 views
  • 0 likes
  • 2 in conversation