cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
tiagomsoares
‎10-25-2016
  • 6 Posts
  • 1 Likes Given
  • 1 Solutions
  • 0 Likes Received

Re: Problems when connecting to MS SQL Server databases

by Fluorite | Level 6 in SAS Data Management
‎10-21-2016 06:21 AM
‎10-21-2016 06:21 AM
I guess I 've found the problem.   First, I need to create a Data Source Server and after that I can create a library associated to the server.  Now I can specify server and connection details!   Kind regards. ... View more

Problems when connecting to MS SQL Server databases

by Fluorite | Level 6 in SAS Data Management
‎10-21-2016 05:19 AM
‎10-21-2016 05:19 AM
Hello,   I need to establish connection to my SQL Server database using SAS DI Studio.   After reading the documentation, I verify that a need to create a new library. So, I open the "New Library Wizard" to do that. However I need to specify a libref, I suppose that "sqlsvr" is the valid one and after selecting the "Next" option, a new pop-up appears in order to introduce server and connection details.   But in this pop-up, I can't change those details, neither create a new one.. And if I choose "Next" again, an error message appears: "Database server filed is required", something that I expected.    Can you help me? There's something missing?   Kind regards,  Tiago ... View more

Re: Running jobs in SAS Data Integration Studio

by Fluorite | Level 6 in SAS Data Management
‎10-20-2016 07:00 AM
‎10-20-2016 07:00 AM
Where I can create an os account? Or where I can find the metadata user profile? When I access to SAS Management Console, I need to create a connectio profile which is automatically associated to the user: "sas@SASBAP unrestricted" 😕     ... View more

Re: Running jobs in SAS Data Integration Studio

by Fluorite | Level 6 in SAS Data Management
‎10-20-2016 05:17 AM
‎10-20-2016 05:17 AM
Also, when I'm trying to validate the process inside SASApp - Workspace Server named "sasadm.demo.sas.com", the following error message appears:   "SEVERE: Connection refused: connect" "SEVERE: java.net.ConnectException: Connection refused: connect"   Best regards, Tiago ... View more

Re: Running jobs in SAS Data Integration Studio

by Fluorite | Level 6 in SAS Data Management
‎10-20-2016 05:09 AM
‎10-20-2016 05:09 AM
I'm using SASApp as my default application server and the SASApp - Worksapce Server was created by default too and has the following properties:   Authentication domain: DefaultAuth Bridge Port: 8591 Process: sasdm.demo.sas.com Users and groups: PUBLIC (deny all permissions) SAS Administrators (grant all permissions) SAS System Services (grant all permissions) SASUSERS (grant all permissions)   In User Manager -> SAS Trusted Users, I have the following users and groups: Metadata server: Operation Metadata server: User Administration SAS Administrators Metadata server: Unrestricted   Also the current connection in SAS Management Console is the following: sas@SASBAP as Unrestricted  sasdm : 8561   ... View more

Running jobs in SAS Data Integration Studio

by Fluorite | Level 6 in SAS Data Management
‎10-19-2016 01:21 PM
‎10-19-2016 01:21 PM
Hello everyone,   When I try to run a simple job in SAS DI Studio, a message error appears: "The application could not log on to the server "(...).com:8591". No server is available at the port on that machine."    I already check the connection in SAS Management Console, and for my "SASApp" server, I can have access to the metadata server however when I test connection to the Workspace server, that error message appears again.   Please, if you have any idea what's going wrong, let me know.   Best regards, Tiago. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-25-2016 10:50 AM
Likes given to
View All
Quick links