Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

To set a User Id/Password prompt for database logon from SAS Enterprise Guide when you use a metadata-defined library, follow these steps:

1. Right-click the library manager and select the new library.
2. In the library wizard, select Default Login to (None).
3. After you create the library, right-click the library name and select Display LIBNAME.

The LIBNAME statement should appear, as follows:

Also, follow these steps:

1. Right-click the library and select Properties to display the SqlServer_ODBC_Prompt Properties dialog box.
2. Click the Extended Attributes tab.
3. Click the New button. Enter prompt for LogiMode and 0 for AssignMode, as shown in the following display. Then click OK to exit.

   

Operating System and Release Information