Hello All,
I want some clear picture on my question if smone can provide please. We are seeting up new DBs and all libraries. This is issue is regarding new SQL SERVER DB CONNECTION from local SAS SERVER.
I have created one library through SAS MC and lib properties is as follow. Now i want to cerate a sql db server conenction for SAS EG users in SAS MC so they can pull up inforamtion from SQL DB Server. When i try to create new conenction profile through SAS MC (9.3), after all credentials error msg comming up is:
The communication channel with the peer closed unexpectedly.
An exception was thrown while receiving the requirements status from the peer.
I can see following library in SAS EG 5.1 but wants to know how can I see those tables which are under that SQL server which i a, trying to connect through SAS MC and I think I must have to create connection profile in SAS EG to see those tables which are there under that SQL DB server, if so please let me know required steps for same.
Property of library (Claim_ODS)that I have created under SAS MC (under server).
Library is pre-assigned.
Name: CLM_ODS
Selected server: SASAPP
Libref: CLM_ODS
Engine: ODBC
Server detail: STADB1350
Connection:STADB1350
Extended Attributes: AssignMode/2/metaout=data
Please Guide.
Thanks,
Sandip.
Hi sandip,
Check this link...it describes step by step....
http://support.sas.com/techsup/technote/ts714.pdf
Thanks,
Shiva
Thanks Shiva. It was great help.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.