topic Re: SAS connections profile via SMC in SAS Data Management

SAS connections profile via SMC

RamKumar — Mon, 04 Aug 2014 10:33:47 GMT

I've SAS profile for production server which was set-up earlier (before I came to the project) in SAS EG 5.1. Now we've a requirement to work on SAS management console with the same production server account where i connect EG. When i produced the server details and it's relevant stuff to connect the server, I could not connect. Error message i got is 'username or password is invalid'. Can someone suggest me to succeed in this step?

Because I could connect EG with the same credentials. On a related point, I see most of my production server operates with the port 8561, test server with 8562 and development server with 8563. Just I would like to know the process to set-up the port number for specific servers. Also i could see that some SAS accounts (mostly pre-prod) are ending with @saspw (eg. sasvt3@saspw). What does it mean? Can we have (set-up) the similar SAS account for production server?

Re: SAS connections profile via SMC

jakarman — Mon, 04 Aug 2014 12:40:49 GMT

Eguide (.Net) and SMC (Java) do not share profiles.
You can set up as many connections as you like but they are only saved (windows profile) when the connection configuration has been ended successfully.

You must have some errors in name/port user/pswd or been locked out from a firewall.

The @saspw accounts are internal SAS accounts not being present on AD LDAP or OS level. When access and configuration is under highly regulated auditing controls you will have an issue with that.

A correct usage of internal accounts is the dual account for administrator activity. The security admin guide is the place where this has been documented.

Re: SAS connections profile via SMC

RamKumar — Tue, 05 Aug 2014 14:13:33 GMT

Thanks for your response.

Do you meant to say that SMC profile never be shared with SAS EG? Also may I ask you the steps to setup a internal SAS account? Please let me know how does it differs from general account.

We don't have a SAS admin and hence i'm posting in this forum to understand more.

Re: SAS connections profile via SMC

jakarman — Tue, 05 Aug 2014 16:21:47 GMT

Ah, a shame that implementation of that role is missing. Understand the why of your question better.

The SMC is a interface to update metadata. You could build other ones. All , the most (some exceptions), is stored in the SAS metdatabase consisting a lot of tables.

Adding users: SAS(R) 9.3 Management Console: Guide to Users and Permissions (other actions see contents)

and the chapter in the bisecag SAS(R) 9.3 Intelligence Platform: Security Administration Guide (a lot more to find there)

The way of supporting connection profiles are documented at:SAS(R) 9.3 Intelligence Platform: Desktop Application Administration Guide

Re: SAS connections profile via SMC

LinusH — Mon, 11 Aug 2014 10:17:53 GMT

SMC and DI Studio shares profile (java clients).

EG and other .net clients (such as Add in for SM Office) share profile.

An internal account exists only in SAS metadata. Usually for meta data acces only.

Re: SAS connections profile via SMC

Kurt_Bremser — Mon, 11 Aug 2014 12:17:18 GMT

The Metadata Server log may give you clues.

You typically find that in ..../Lev1/SASMeta/MetadataServer/Logs