BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
lfabbri
Obsidian | Level 7

Hi, I have SAS 9.4 installed with Data Integration deployment plan.

 

I have a new SAS order which includes SAS/ACCESS interface for Microsoft SQL Server, which was not included in the previous order. I need to install this new product on top of the current installation.

Which are the correct steps to do this?

1 ACCEPTED SOLUTION

Accepted Solutions
nhvdwalt
Barite | Level 11

Try this for me...

 

Run the (new) SDW again. Select to install only SAS Foundation and Related software. Select only 'SAS Foundation' to install. At the screen where all the Foundation SAS components are listed, only select Base (default) and SAS Access to SQL Server. Then proceed with the installation.... Be sure to select the new license key.

View solution in original post

10 REPLIES 10
lfabbri
Obsidian | Level 7

Hi, thanks for reply. I've already followed that guide but the new SAS/ACCESS interaface was not installed (although it is shown by SAS in the products list of the new order). What SAS wizard did was to update all the components already installed in the previous order, but it did not add the ACCESS interface to Microsoft SQL Server. 

After the update process I've tried to run again Deployment Wizard and choose "Install additional software" from the "Select deployment type" page, but there the SAS/ACCESS interface is not listed:

 

 

additional_software.png

 

Am I missing something?

alexal
SAS Employee

@lfabbri,

 

Please generate a deployment registry and show me that file.

 

http://support.sas.com/kb/35/968.html

lfabbri
Obsidian | Level 7
SAS Installed Software And Components

SASHOME: C:\Program Files\SASHome

           Host: wx6
        Product: tablesrvtk
        Version: 9.4
   Display Name: SAS Table Server Base Components
Display Version: 9.4_M5
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkintr
        Version: 9.4
   Display Name: SAS Threaded Kernel Interface to R
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: aacomp
        Version: 15.1
   Display Name: Advanced Analytics Common Components
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: inttechdoc
        Version: 9.4
   Display Name: SAS Integration Technologies Documentation
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: activexgraph
        Version: 9.46
   Display Name: SAS/GRAPH ActiveX Control
Display Version: 9.46
-------------------------------------------------------------------------------

           Host: wx6
        Product: mgmtconsole
        Version: 9.4
   Display Name: SAS Management Console
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: mvaviyadoc
        Version: 9.4M6
   Display Name: SAS Viya Content MVA Help and Documentation
Display Version: 9.4M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: tksecure
        Version: 9.4
   Display Name: SAS Threaded Kernel Secure
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: tk
        Version: 9.4
   Display Name: SAS Threaded Kernel
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkbridge
        Version: 9.4
   Display Name: SAS Threaded Kernel Component for Accessing the Threaded Kernel from JAVA
Display Version: 9.4_M5
-------------------------------------------------------------------------------

           Host: wx6
        Product: securejavam4
        Version: 9.4
   Display Name: SAS/SECURE Java Component M4
Display Version: 9.4
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkcore
        Version: 9.4
   Display Name: SAS Threaded Kernel Core Routines
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: hptmine
        Version: 15.1
   Display Name: SAS High-Performance Text Mining Server Components
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkolap
        Version: 9.4
   Display Name: Threaded Kernel OLAP Server Component
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkjava
        Version: 9.4
   Display Name: Threaded Kernel Java
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: odstemplate
        Version: 9.4
   Display Name: ODS Templates
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: accesssample
        Version: 9.4
   Display Name: SAS/ACCESS Interface Products Samples
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: hadoopwrapr
        Version: 9.46
   Display Name: DataFlux API for Hadoop
Display Version: 9.46
-------------------------------------------------------------------------------

           Host: wx6
        Product: mitibridges
        Version: 4.4
   Display Name: SAS Metadata Bridges
Display Version: 4.4
-------------------------------------------------------------------------------

           Host: wx6
        Product: analyticcmn
        Version: 15.1
   Display Name: SAS Common Analytic Procedures
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkformats
        Version: 9.4
   Display Name: SAS Threaded Kernel User Formats
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: win
        Product: tkaccess
        Version: 9.41
   Display Name: SAS Threaded Kernel Extension for RDBMS Drivers Parser
Display Version: 9.41_M4
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkormp
        Version: 15.1
   Display Name: SAS Threaded Kernel Extensions for Operations Research
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: etscomp
        Version: 15.1
   Display Name: SAS/ETS Time Series & Econometric Modeling Common Components
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkmtrb
        Version: 9.42
   Display Name: SAS Threaded Kernel Mid-tier Request Bridge
Display Version: 9.42
-------------------------------------------------------------------------------

           Host: wx6
        Product: base
        Version: 9.4
   Display Name: Base SAS
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: pcfile
        Version: 9.4
   Display Name: SAS/ACCESS Interface to PC Files
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: econometrics
        Version: 8.3
   Display Name: SAS Econometrics Procedures
Display Version: 8.3
-------------------------------------------------------------------------------

           Host: wx6
        Product: mapssas
        Version: 9.43
   Display Name: SAS/GRAPH Obsolete Maps Data
Display Version: 9.43
-------------------------------------------------------------------------------

           Host: win
        Product: eeditor
        Version: 9.46
   Display Name: SAS Enhanced Editor
Display Version: 9.46
-------------------------------------------------------------------------------

           Host: win
        Product: iculib
        Version: 9.43
   Display Name: International Component for Unicode
Display Version: 9.43
-------------------------------------------------------------------------------

           Host: win
        Product: securelite
        Version: 9.4
   Display Name: SAS Proprietary Encryption
Display Version: 9.4_M5
-------------------------------------------------------------------------------

           Host: wx6
        Product: tsmodel
        Version: 8.3
   Display Name: SAS Time Series Modeling Procedures
Display Version: 8.3
-------------------------------------------------------------------------------

           Host: wx6
        Product: tmine
        Version: 15.1
   Display Name: SAS Text Miner
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: mitidiplug
        Version: 4.22
   Display Name: SAS Metadata Bridges Plug-in for SAS Data Integration Studio
Display Version: 4.22
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkmysql
        Version: 9.4
   Display Name: SAS Threaded Kernel Extension for MySQL
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: tknls
        Version: 9.4
   Display Name: Threaded Kernel National Language Support
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: dmine
        Version: 15.1
   Display Name: SAS Enterprise Miner
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: dproclient
        Version: 2.2
   Display Name: SAS Deployment Tester - Client
Display Version: 2.2_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkspddrv
        Version: 5.3
   Display Name: SAS Threaded Kernel Drivers for Scalable Performance Data
Display Version: 5.3_M3
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkgraph
        Version: 15.1
   Display Name: SAS Threaded Kernel Extensions for Graph Analytics
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkhphpf
        Version: 15.1
   Display Name: SAS Threaded Kernel Extensions for High-Performance Forecasting
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkl4sas
        Version: 9.4
   Display Name: Threaded Kernel Log for SAS
Display Version: 9.4_M8
-------------------------------------------------------------------------------

           Host: win
        Product: sasoledb
        Version: 9.46
   Display Name: SAS Providers for OLE DB
Display Version: 9.46
-------------------------------------------------------------------------------

           Host: wx6
        Product: privatejre
        Version: 9.47
   Display Name: SAS Private Java Runtime Environment
Display Version: 9.47
-------------------------------------------------------------------------------

           Host: wx6
        Product: prochttp
        Version: 9.42
   Display Name: PROC HTTP
Display Version: 9.42
-------------------------------------------------------------------------------

           Host: wx6
        Product: lasreng
        Version: 2.82
   Display Name: SAS LASR Analytic Server Access Tools
Display Version: 2.82
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkoldoc
        Version: 9.4
   Display Name: SAS Threaded Kernel Online Documentation
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: safmts
        Version: 9.4
   Display Name: Standalone Formats
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkiml
        Version: 15.1
   Display Name: SAS Threaded Kernel Extensions for Interactive Matrix Language
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkstat
        Version: 15.1
   Display Name: SAS Threaded Kernel Extensions for Statistics
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: mvahelpdoc
        Version: 9.4
   Display Name: Common Content MVA product Help and Documentation
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: graphapplet
        Version: 9.45
   Display Name: SAS/GRAPH Java Applets for Web Servers
Display Version: 9.45
-------------------------------------------------------------------------------

           Host: wx6
        Product: connectdrvrs
        Version: 9.4
   Display Name: SAS/CONNECT Driver for Java
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: graphjars
        Version: 9.4
   Display Name: SAS/GRAPH JAR Files
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: hpdmine
        Version: 15.1
   Display Name: SAS High-Performance Data Mining Server Components
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: cmp
        Version: 9.46
   Display Name: SAS Compiler and Symbolic Differentiator
Display Version: 9.46
-------------------------------------------------------------------------------

           Host: wx6
        Product: tksecuressh
        Version: 2.82
   Display Name: SAS Threaded Kernel Extension for SSH Remote Process Launching
Display Version: 2.82
-------------------------------------------------------------------------------

           Host: wx6
        Product: stat
        Version: 15.1
   Display Name: SAS/STAT
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: optimization
        Version: 8.3
   Display Name: SAS Optimization Procedures
Display Version: 8.3
-------------------------------------------------------------------------------

           Host: wx6
        Product: javaruntime
        Version: 9.4
   Display Name: Java Platform Standard Edition Runtime Environment
Display Version: 
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkaa
        Version: 15.1
   Display Name: SAS Threaded Kernel Extensions for Advanced Analytics
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: clientconfig
        Version: 5.2
   Display Name: SAS Client Connection Profile Configuration
Display Version: 5.2
-------------------------------------------------------------------------------

           Host: wx6
        Product: basestat
        Version: 15.1
   Display Name: Base SAS Statistical Procedures
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: securestrong
        Version: 9.41
   Display Name: SAS/SECURE Toolkit Libraries from RSA (R)
Display Version: 9.41_M3
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkgridjars
        Version: 9.43
   Display Name: Threaded Kernel Grid JAR Files
Display Version: 9.43
-------------------------------------------------------------------------------

           Host: wx6
        Product: mapsgfk
        Version: 9.43
   Display Name: GfK GeoMarketing WORLD Maps for SAS/GRAPH
Display Version: 9.43
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkmpi
        Version: 2.82
   Display Name: SAS Threaded Kernel Message Passing Interface
Display Version: 2.82
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkgrid
        Version: 9.4
   Display Name: SAS Threaded Kernel Grid
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkbasestat
        Version: 15.1
   Display Name: Base SAS Statistical threaded kernel extensions
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkhptmine
        Version: 15.1
   Display Name: SAS Threaded Kernel Extensions for High-Performance Text Mining
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkqc
        Version: 15.1
   Display Name: Threaded Kernel Extensions for SAS/QC
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: textmine
        Version: 8.3
   Display Name: SAS Text Mining Process
Display Version: 8.3
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkhpdmine
        Version: 15.1
   Display Name: SAS Threaded Kernel Extensions for High-Performance Data Mining
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: dminejars
        Version: 15.1
   Display Name: SAS Enterprise Miner JAR Files
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: tstimeinfo
        Version: 8.3
   Display Name: SAS Time Series Information Procedures
Display Version: 8.3
-------------------------------------------------------------------------------

           Host: wx6
        Product: groovy
        Version: 9.410
   Display Name: SAS Deployment Support Components
Display Version: 9.410
-------------------------------------------------------------------------------

           Host: wx6
        Product: webinfdodbc
        Version: 9.45
   Display Name: SAS ODBC Drivers for the Web Infrastructure Platform Data Server
Display Version: 9.45
-------------------------------------------------------------------------------

           Host: wx6
        Product: scoreaccel
        Version: 8.3
   Display Name: SAS Interface to Viya Model Publishing and Scoring
Display Version: 8.3
-------------------------------------------------------------------------------

           Host: wx6
        Product: graph
        Version: 9.4
   Display Name: SAS/GRAPH
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: tklasreng
        Version: 2.82
   Display Name: SAS Threaded Kernel Extensions for LASR Analytics Server Access Tools
Display Version: 2.82
-------------------------------------------------------------------------------

           Host: wx6
        Product: itclient
        Version: 9.49
   Display Name: SAS Integration Technologies Client
Display Version: 9.49
-------------------------------------------------------------------------------

           Host: wx6
        Product: mapsgeo
        Version: 9.43
   Display Name: GfK GeoMarketing CITIES Maps for SAS/GRAPH
Display Version: 9.43
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkormpgraph
        Version: 15.1
   Display Name: Threaded Kernel Extensions for Operations Research and GRAPH Analytics
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: secureclient
        Version: 9.4
   Display Name: SAS/SECURE Client Components
Display Version: 9.4_M5
-------------------------------------------------------------------------------

           Host: wx6
        Product: securejava
        Version: 9.4
   Display Name: SAS/SECURE Java Component
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkhps
        Version: 2.2
   Display Name: SAS Threaded Kernel Extensions for High-Performance Analytics
Display Version: 2.2_M7
-------------------------------------------------------------------------------

           Host: wx6
        Product: connectdoc
        Version: 9.4M6
   Display Name: SAS/CONNECT Help and Documentation
Display Version: 9.4M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: dproserver
        Version: 2.2
   Display Name: SAS Deployment Tester - Server
Display Version: 2.2_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: deployagent
        Version: 9.49580
   Display Name: SAS Deployment Agent
Display Version: 9.49580
-------------------------------------------------------------------------------

           Host: wx6
        Product: tktxtan
        Version: 15.1
   Display Name: SAS Threaded Kernel Extensions for SAS Text Analytics
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: hpets
        Version: 15.1
   Display Name: SAS High-Performance Econometrics Server Components
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: basejars
        Version: 9.4
   Display Name: Base SAS JAR Files
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: eeditor
        Version: 9.46
   Display Name: SAS Enhanced Editor
Display Version: 9.46
-------------------------------------------------------------------------------

           Host: wx6
        Product: dminedoc
        Version: 15.1
   Display Name: SAS Enterprise Miner Help and Documentation
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: verthelpdoc
        Version: 9.4M6
   Display Name: Common Content product - vertical Help and Documentation
Display Version: 9.4M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: aastatistics
        Version: 15.1
   Display Name: SAS Advanced Analytics Statistics
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: grsgeditor
        Version: 9.46
   Display Name: SAS ODS Graphics Editor
Display Version: 9.46
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkmds
        Version: 2.1
   Display Name: SAS Threaded Kernel Extension for In-Memory Data Storage
Display Version: 2.1_M5
-------------------------------------------------------------------------------

           Host: wx6
        Product: instqualtool
        Version: 9.49516
   Display Name: SAS Install Qualification Tool
Display Version: 9.49516_M4
-------------------------------------------------------------------------------

           Host: wx6
        Product: databuildata
        Version: 4.7
   Display Name: SAS Data Integration Studio Server Data
Display Version: 4.7_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: iculib
        Version: 9.43
   Display Name: International Component for Unicode
Display Version: 9.43
-------------------------------------------------------------------------------

           Host: wx6
        Product: inttech
        Version: 9.4
   Display Name: SAS Integration Technologies
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: connect
        Version: 9.4
   Display Name: SAS/CONNECT
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: mtrb
        Version: 9.42
   Display Name: Mid-Tier Rest Bridge
Display Version: 9.42
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkhpstat
        Version: 15.1
   Display Name: SAS Threaded Kernel Extensions for High-Performance Statistics
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: statcomp
        Version: 15.1
   Display Name: Statistics Common Components
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: certframe
        Version: 9.49580
   Display Name: SAS Security Certificate Framework
Display Version: 9.49580
-------------------------------------------------------------------------------

           Host: wx6
        Product: securelite
        Version: 9.4
   Display Name: SAS Proprietary Encryption
Display Version: 9.4_M5
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkbridgejava
        Version: 9.4
   Display Name: SAS Java Component for Accessing Threaded Kernel from Java
Display Version: 9.4_M5
-------------------------------------------------------------------------------

           Host: wx6
        Product: txtancomp
        Version: 15.1
   Display Name: SAS Text Analytics Common Components
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: txtandocconv
        Version: 15.1
   Display Name: SAS Document Conversion
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: secupdate
        Version: 4.0
   Display Name: SAS Security Update
Display Version: 4.0
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkspde
        Version: 9.41
   Display Name: SAS Threaded Kernel Components for Scalable Performance Data
Display Version: 9.41_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkdmine
        Version: 15.1
   Display Name: SAS Threaded Kernel Extensions for Data Mining
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: databuilder
        Version: 4.7
   Display Name: SAS Data Integration Studio
Display Version: 4.7_M6
-------------------------------------------------------------------------------

           Host: win
        Product: activexgraph
        Version: 9.46
   Display Name: SAS/GRAPH ActiveX Control
Display Version: 9.46
-------------------------------------------------------------------------------

           Host: wx6
        Product: hadoopcjars
        Version: 2.6
   Display Name: SAS Hadoop Configuration Libraries
Display Version: 2.6
-------------------------------------------------------------------------------

           Host: wx6
        Product: ets
        Version: 15.1
   Display Name: SAS/ETS
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkodbc
        Version: 9.4
   Display Name: SAS Threaded Kernel Extension for ODBC
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: hpstat
        Version: 15.1
   Display Name: SAS High-Performance Statistics Server Components
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: graphdoc
        Version: 9.4M6
   Display Name: SAS/GRAPH Help and Documentation
Display Version: 9.4M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: mrloginmgr
        Version: 9.4
   Display Name: SAS Personal Login Manager
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: sasdocviewer
        Version: 9.46
   Display Name: SAS Help Viewer for Windows
Display Version: 9.46
-------------------------------------------------------------------------------

           Host: wx6
        Product: pcfiledoc
        Version: 9.4M6
   Display Name: SAS/ACCESS Interface to PC Files Help and Documentation
Display Version: 9.4M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: mlearning
        Version: 8.3
   Display Name: SAS Visual Data Mining and Machine Learning Procedures
Display Version: 8.3
-------------------------------------------------------------------------------

           Host: wx6
        Product: accelmva
        Version: 3.1
   Display Name: DATA Step to DS2 Translator
Display Version: 3.1_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: securejavam5
        Version: 9.4
   Display Name: SAS/SECURE Java Component M5
Display Version: 9.4
-------------------------------------------------------------------------------

           Host: wx6
        Product: casconnctsub
        Version: 8.3
   Display Name: Cloud Analytics Services Connection and Submission Client
Display Version: 8.3
-------------------------------------------------------------------------------

           Host: wx6
        Product: tktslang
        Version: 9.41
   Display Name: SAS Threaded Kernel DS2 and FedSQL Language Processors
Display Version: 9.41_M4
-------------------------------------------------------------------------------

           Host: wx6
        Product: dprosmc
        Version: 9.4
   Display Name: SAS Deployment Tester Plug-in for SAS Management Console
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkiog
        Version: 9.41
   Display Name: SAS Threaded Kernel In-Database Supervisor
Display Version: 9.41_M4
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkspdsdrv
        Version: 5.4
   Display Name: SAS Threaded Kernel Driver for SAS Scalable Performance Data Server
Display Version: 5.4
-------------------------------------------------------------------------------

           Host: wx6
        Product: hadoopbasics
        Version: 9.46
   Display Name: BASE Infrastructure to support Hadoop
Display Version: 9.46
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkaccess
        Version: 9.41
   Display Name: SAS Threaded Kernel Extension for RDBMS Drivers Parser
Display Version: 9.41_M4
-------------------------------------------------------------------------------

           Host: wx6
        Product: basedoc
        Version: 9.4M6
   Display Name: Base SAS Help and Documentation
Display Version: 9.4M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: tsreconcile
        Version: 8.3
   Display Name: SAS Forecast Reconciliation Procedures
Display Version: 8.3
-------------------------------------------------------------------------------

           Host: wx6
        Product: deployagtclt
        Version: 9.49580
   Display Name: SAS Remote Deployment Agent Client
Display Version: 9.49580
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkets
        Version: 15.1
   Display Name: SAS Threaded Kernel Extensions for Econometric Time Series
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: inttechjars
        Version: 9.4
   Display Name: SAS Integration Technologies JAR Files
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkpostgres
        Version: 9.4
   Display Name: SAS Threaded Kernel Extension for PostgreSQL
Display Version: 9.4_M5
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkfnc
        Version: 9.4
   Display Name: SAS Threaded Kernel User Functions
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: postgres
        Version: 9.4
   Display Name: SAS/ACCESS Interface to PostgreSQL
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkcmp
        Version: 9.47
   Display Name: SAS Thread-safe Compiler and Symbolic Differentiator
Display Version: 9.47
-------------------------------------------------------------------------------

           Host: wx6
        Product: hpsdoc
        Version: 2.1
   Display Name: SAS High Performance Server Help and Documentation
Display Version: 2.1_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: grodscrender
        Version: 9.45
   Display Name: SAS ODS Graphics C Renderer
Display Version: 9.45
-------------------------------------------------------------------------------

           Host: wx6
        Product: vertviyadoc
        Version: 9.4M6
   Display Name: SAS Viya Content Vertical Help and Documentation
Display Version: 9.4M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: mysql
        Version: 9.4
   Display Name: SAS/ACCESS Interface to MySQL
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: graphcomp
        Version: 15.1
   Display Name: SAS Network Algorithms
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: dmscore
        Version: 9.4
   Display Name: SAS Data Mining Scoring
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: odbc
        Version: 9.4
   Display Name: SAS/ACCESS Interface to ODBC
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkhpets
        Version: 15.1
   Display Name: SAS Threaded Kernel Extensions for High-Performance Econometrics
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: win
        Product: tkpostgres
        Version: 9.4
   Display Name: SAS Threaded Kernel Extension for PostgreSQL
Display Version: 9.4_M5
-------------------------------------------------------------------------------

           Host: win
        Product: secureclient
        Version: 9.4
   Display Name: SAS/SECURE Client Components
Display Version: 9.4_M5
-------------------------------------------------------------------------------

           Host: wx6
        Product: baseui
        Version: 9.4
   Display Name: Base SAS User Interface
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkjavajars
        Version: 9.4
   Display Name: Threaded Kernel Java Jars
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: ttfontsvert
        Version: 9.45
   Display Name: Report Fonts for Clients
Display Version: 9.45
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkcas3rdclnt
        Version: 9.61
   Display Name: SAS Cloud Analytic Services support for Third Party Clients
Display Version: 9.61
-------------------------------------------------------------------------------

           Host: wx6
        Product: or
        Version: 15.1
   Display Name: SAS/OR
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: mitismc
        Version: 4.22
   Display Name: SAS Metadata Bridges Plug-in for SAS Management Console
Display Version: 4.22
-------------------------------------------------------------------------------

           Host: wx6
        Product: tktscore
        Version: 9.4
   Display Name: SAS Threaded Kernel Extensions for FedSQL and DS2 Standalone
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: platfmltypes
        Version: 9.4
   Display Name: SAS Intelligence Platform Object Framework
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkmeta
        Version: 9.4
   Display Name: Threaded Kernel Metadata Component
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: win
        Product: safmts
        Version: 9.4
   Display Name: Standalone Formats
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: tksaslaunch
        Version: 9.46
   Display Name: SAS TK Launcher
Display Version: 9.46
-------------------------------------------------------------------------------

           Host: wx6
        Product: secupdate2
        Version: 2.0
   Display Name: SAS Security Update 2
Display Version: 2.0
-------------------------------------------------------------------------------

           Host: wx6
        Product: sasoledb
        Version: 9.46
   Display Name: SAS Providers for OLE DB
Display Version: 9.46
-------------------------------------------------------------------------------

           Host: wx6
        Product: securedom
        Version: 9.41
   Display Name: SAS/SECURE
Display Version: 9.41_M3
-------------------------------------------------------------------------------

           Host: win
        Product: itclient
        Version: 9.49
   Display Name: SAS Integration Technologies Client
Display Version: 9.49
-------------------------------------------------------------------------------

           Host: wx6
        Product: securejavam3
        Version: 9.4
   Display Name: SAS/SECURE Java Component M3
Display Version: 9.4
-------------------------------------------------------------------------------

           Host: wx6
        Product: iml
        Version: 15.1
   Display Name: SAS/IML
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: hps
        Version: 2.2
   Display Name: SAS High-Performance Server
Display Version: 2.2_M7
-------------------------------------------------------------------------------

           Host: wx6
        Product: spdsclient
        Version: 5.4
   Display Name: SAS Scalable Performance Data Client
Display Version: 5.4
-------------------------------------------------------------------------------

           Host: wx6
        Product: dminelogtype
        Version: 15.1
   Display Name: SAS Enterprise Miner Logical Types
Display Version: 15.1
-------------------------------------------------------------------------------

           Host: wx6
        Product: tkiom
        Version: 9.4
   Display Name: Threaded Kernel IOM
Display Version: 9.4_M6
-------------------------------------------------------------------------------

           Host: wx6
        Product: databldjars
        Version: 4.8
   Display Name: SAS Data Integration Studio Server JARs
Display Version: 4.8_M5
-------------------------------------------------------------------------------

           Host: wx6
        Product: forecast
        Version: 8.3
   Display Name: SAS Forecasting Procedures
Display Version: 8.3
-------------------------------------------------------------------------------

           Host: wx6
        Product: cas
        Version: V.03.04
   Display Name: SAS Cloud Analytic Services SAS Client
Display Version: V.03.04
-------------------------------------------------------------------------------

SAS/ACCESS interface to Microsoft SQL Server is not present. But in the Deployment Wizard, when I select my order, the product is present:

 

deploy_order_products.png

nhvdwalt
Barite | Level 11

Hi @lfabbri

 

Are you using the new depot that came with the new order ?

Check that SAS Access to SQL Server appears in the license file that came with the new depot.

lfabbri
Obsidian | Level 7

Hi @nhvdwalt, what I did was to download the new order Software Depot on top of the existing software depot using the SAS Download Manager from here https://support.sas.com/downloads/browse.htm?fil=&cat=49.

Is that correct?

nhvdwalt
Barite | Level 11

Try this for me...

 

Run the (new) SDW again. Select to install only SAS Foundation and Related software. Select only 'SAS Foundation' to install. At the screen where all the Foundation SAS components are listed, only select Base (default) and SAS Access to SQL Server. Then proceed with the installation.... Be sure to select the new license key.

lfabbri
Obsidian | Level 7

Thank you very much, I've succesfully installed following your steps.

 

Now I have a new problem...basically and the end of the update process the wizard said that it failed to start the SAS Object Spawner because the port was already used...I've tried to restart windows, stopped all the SAS services and tried again but got the same error. I've finished the installation anyway, skipping this error.

 

Now my problem is that when I try to register tables in a new Sql Server library I can't performs the logon to the SasApp, even with the admin user:

 

error_2.pngerror_3.png

I think is probably related to the error on the SAS Object Spawner during the update process but I don't know how to solve it.

In windows services the Object Spawner seems to be running, but maybe it is related to the previous installation?

 

spawner.png

 

 

 

Any idea how to fix this issue?

nhvdwalt
Barite | Level 11

@lfabbri

Kindly close this discussion and create a new thread for the new issue.

Roy21
Calcite | Level 5
Hi @lfabbri, I'm facing something similar in my SAS Platform, I'm trying 'add additional software' from Deployment Manager but there no such option is visible. Do you have another thread where I can discuss this?

Much Regards,
Roy

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 10 replies
  • 6227 views
  • 3 likes
  • 4 in conversation