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?
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.
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:
Am I missing something?
Please generate a deployment registry and show me that file.
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:
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.
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?
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.
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:
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?
Any idea how to fix this issue?
Kindly close this discussion and create a new thread for the new issue.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
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.