How to connect to Named instance localhost\SqlExpress in AWS SCT?

0

Hello team,

I have SQL Server named instance - SQLExpress running on localhost, I can connect to that instance using DBeaver but cannot connect using AWS SCT. I have specified JDBC Driver as well.

Connectivity error

Driver settings

Logs

2023-08-19 19:15:22.616 [  30]     GENERAL INFO    AWS Schema Converison Tool version 1.0 build 672
2023-08-19 19:15:22.618 [  30]     GENERAL INFO    global_settings:
    DEFAULT_PROFILE_GENERAL=ankita
    app_conversion.excluded_files=(?i).*\.(dll|rpm|a|bin|PIC|ico|z|bac|gif|tif|tiff|dpx|exr|bpg|jpg|jpeg|exe|zip|jar|apk|rar|png|class|pdf|wav|avi|mp3|bmp|iso|mid|midi|dat|tar|7z|gz|cab|djvu|djv|swf|deb|mpeg|mpg|zlib|dat|ddl|mov|mps|sfx|so|snd|sys|taz|tgz|zoo|ttf|fnt|fon|otf|afm|ttc|pfb|pfm|lib|war)$
    app_folder=AWS Schema Conversion Tool
    console_log_folder=C:\Users\modi_\AWS Schema Conversion Tool\Log
    convert_without_statistic_reminder=false
    data_migration_settings=
    db2luw_driver_file=
    debug_mode=false
    emr_hive_driver_file=
    ext_pack_version_alert=true
    facade_log_folder=C:\Users\modi_\AWS Schema Conversion Tool\Log
    file-system-thread-count=1
    forget-state=false
    greenplum_driver_file=
    hive_driver_file=
    install_dir=C:\Users\modi_
    license_accepted_for_build=1.0.672
    loader.failed.queries.attempts.count=3
    loader.failed.queries.attempts.timeout.timemillis=10000
    log.max_file_size_mb=100
    log.max_files_count=20
    log_folder=C:\Users\modi_\AWS Schema Conversion Tool\Log
    log_folder_extractors=C:\Users\modi_\AWS Schema Conversion Tool\Extractor Log
    log_folder_extractors_ask_before_load=false
    log_folder_extractors_cassandra=C:\Users\modi_\AWS Schema Conversion Tool\Extractor Log\Cassandra
    maria_driver_file=
    message_level.CLONE_DATACENTER=INFO
    message_level.COMPARE_SCHEMA=INFO
    message_level.CONTROLLER=INFO
    message_level.DMS_AGENT=DEFAULT
    message_level.GENERAL=INFO
    message_level.INTERPRETATOR=INFO
    message_level.LOADER=INFO
    message_level.MIGRATOR=INFO
    message_level.PARSER=INFO
    message_level.PRINTER=INFO
    message_level.RESOLVER=INFO
    message_level.TELEMETRY=INFO
    message_level.TESTER=INFO
    message_level.TRANSFORMER=INFO
    message_level.TYPEMAPPING=INFO
    message_level.UI=INFO
    minimal-invalidation-percent=30
    minimal-text-size=30
    mssql_auth_file=
    mssql_driver_file=C:\Softwares\Microsoft JDBC Driver 7.2 for SQL Server\sqljdbc_7.2\enu\mssql-jdbc-7.2.2.jre8.jar
    mysql_driver_file=
    netezza_driver_file=
    olap-version-2=false
    open_file_after_action=true
    oracle_driver_file=
    parser-cache-size=0
    parser.cleanup_mode=AFTER_PARSING
    postgresql_driver_file=C:\Softwares\postgresql-42.6.0.jar
    project_folder=Projects
    redshift_driver_file=
    reporting.mode=FIVE
    s3-duration=900
    s3-max-try-count=5
    s3-thread-count=2
    s3-timeout=1000
    security.certificate=
    show-all-files=false
    show_hide_schema_alert=true
    showed-files-count=5
    snowflake_driver_file=
    source.jdbc.connections.max=20
    source.jdbc.min.evictable.timemillis=30000
    sql_cache.large_value_threshold=1024
    sql_cache.mru_size=10
    storage-type=s3
    storage.default_project_path=C:\Users\modi_\AWS Schema Conversion Tool\Projects
    store_password=false
    store_username=true
    sybase_ase_driver_file=
    target.jdbc.connections.max=20
    target.jdbc.min.evictable.timemillis=30000
    teradata_driver_files=
    teradata_first_driver_file=
    teradata_second_driver_file=
    throttling_time_for_progress_bar=1000
    tree_settings_for_show={"sourceTreeSettingsModels":{"MYSQL":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":["information_schema","performance_schema","mysql","sys"],"userDefinedSchemas":[],"systemSchemasOptions":["mysql","information_schema","performance_schema","sys"],"origin":null},"AZURE_SYNAPSE":{"hideEmpty":true,"hideEmptyDb":false,"systemSchemas":["%.INFORMATION_SCHEMA","%.sys","%.sysdiag"],"userDefinedSchemas":[],"systemSchemasOptions":["%.INFORMATION_SCHEMA","%.sys","%.sysdiag"],"origin":null},"DB2ZOS":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":["SYS%"],"userDefinedSchemas":[],"systemSchemasOptions":["SYS%"],"origin":null},"MSSQL":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":["%.INFORMATION_SCHEMA","%.sys"],"userDefinedSchemas":[],"systemSchemasOptions":["distribution","master","model","msdb","tempdb","ResourceDB","ReportServer","ReportServerTempDB","%.INFORMATION_SCHEMA","%.sys"],"origin":null},"ORACLE":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":[],"userDefinedSchemas":[],"systemSchemasOptions":["ADAMS","ANONYMOUS","APEX_030000","APEX_030100","APEX_030200","APEX_040000","APEX_040100","APEX_040200","APEX_050000","APEX_050100","APEX_LISTENER","APEX_PUBLIC_USER","APEX_REST_PUBLIC_USER","APPQOSSYS","AUDSYS","AURORA$ORB$UNAUTHENTICATED","AWR_STAGE","BI","BLAKE","CLARK","CSMIG","CTXSYS","DBSFWUSER","DBSNMP","DEMO","DIP","DMSYS","DSSYS","DVF","DVSYS","EXFSYS","FLOWS_030000","FLOWS_FILES","GSMADMIN_INTERNAL","GSMCATUSER","GSMUSER","HR","IX","JONES","LBACSYS","MDDATA","MDSYS","MGMT_VIEW","OE","OJVMSYS","OLAPSYS","OPS$","ORACLE_OCM","ORDDATA","ORDPLUGINS","ORDSYS","ORDS_METADATA","ORDS_PUBLIC_USER","OUTLN","OWBSYS","OWBSYS_AUDIT","PERFSTAT","PM","QUEST","RDSADMIN","REMOTE_SCHEDULER_AGENT","SCOTT","SH","SI_INFORMTN_SCHEMA","SPATIAL_CSW_ADMIN_USR","SPATIAL_WFS_ADMIN_USR","SPOTLIGHT","SYS","SYSADM","SYSBACKUP","SYSDG","SYSKM","SYSMAN","SYSTEM","TRACESVR","TSMSYS","WKPROXY","WKSYS","WK_TEST","WMSYS","XDB","XS$NULL"],"origin":null},"GREENPLUM":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":[],"userDefinedSchemas":[],"systemSchemasOptions":["gp_toolkit","information_schema","pg_aoseg","pg_bitmapindex","pg_catalog","pg_toast","pg_temp_%"],"origin":null},"AZURE_MSSQL":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":["%.INFORMATION_SCHEMA","%.sys"],"userDefinedSchemas":[],"systemSchemasOptions":["INFORMATION_SCHEMA","sys"],"origin":null},"VERTICA":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":[],"userDefinedSchemas":[],"systemSchemasOptions":["v_internal","v_catalog","v_monitor"],"origin":null},"SNOWFLAKE":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":[],"userDefinedSchemas":[],"systemSchemasOptions":["SNOWFLAKE","%.ACCOUNT_USAGE","%.READER_ACCOUNT_USAGE","%.ORGANIZATION_USAGE","%.INFORMATION_SCHEMA"],"origin":null},"DB2LUW":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":[],"userDefinedSchemas":[],"systemSchemasOptions":["ERRORSCHEMA","NULLID","SQLJ","SYSCAT","SYSFUN","SYSIBM","SYSIBMADM","SYSIBMINTERNAL","SYSIBMTS","SYSPROC","SYSPUBLIC","SYSSTAT","SYSTOOLS"],"origin":null},"TERADATA":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":[],"userDefinedSchemas":[],"systemSchemasOptions":["DBC"],"origin":null},"SYBASE_ASE":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":["%.INFORMATION_SCHEMA","%.webservices_role","%.sa_role","%.oper_role","%.keycustodian_role","%.sys","%.ha_role","%.js_admin_role","%.mon_role","%.navigator_role","%.public","%.sso_role","%.js_client_role","%.replication_role","%.js_user_role","%.messaging_role","%.sybase_ts_role","%.dtm_tm_role"],"userDefinedSchemas":[],"systemSchemasOptions":["master","model","sybsystemprocs","sybsystemdb","tempdb","sybsecurity","pubs2","pubs3","dbccdb","sybmgmtdb","%.sys","%.INFORMATION_SCHEMA","%.public","%.sa_role","%.sso_role","%.oper_role","%.sybase_ts_role","%.navigator_role","%.replication_role","%.dtm_tm_role","%.ha_role","%.mon_role","%.js_admin_role","%.messaging_role","%.js_client_role","%.js_user_role","%.webservices_role","%.keycustodian_role"],"origin":null},"NETEZZA":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":[],"userDefinedSchemas":[],"systemSchemasOptions":["SYSTEM","%.DEFINITION_SCHEMA","%.INFORMATION_SCHEMA"],"origin":null},"POSTGRESQL":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":["pg_toast%","information_schema","pg_catalog","pg_temp%"],"userDefinedSchemas":[],"systemSchemasOptions":["pg_catalog","information_schema","pg_temp%","pg_toast%"],"origin":null}},"targetTreeSettingsModels":{"MYSQL":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":["information_schema","performance_schema","mysql","sys"],"userDefinedSchemas":[],"systemSchemasOptions":["mysql","information_schema","performance_schema","sys"],"origin":null},"AZURE_SYNAPSE":{"hideEmpty":true,"hideEmptyDb":false,"systemSchemas":["%.INFORMATION_SCHEMA","%.sys","%.sysdiag"],"userDefinedSchemas":[],"systemSchemasOptions":["%.INFORMATION_SCHEMA","%.sys","%.sysdiag"],"origin":null},"DB2ZOS":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":["SYS%"],"userDefinedSchemas":[],"systemSchemasOptions":["SYS%"],"origin":null},"MSSQL":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":["%.INFORMATION_SCHEMA","%.sys"],"userDefinedSchemas":[],"systemSchemasOptions":["distribution","master","model","msdb","tempdb","ResourceDB","ReportServer","ReportServerTempDB","%.INFORMATION_SCHEMA","%.sys"],"origin":null},"ORACLE":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":[],"userDefinedSchemas":[],"systemSchemasOptions":["ADAMS","ANONYMOUS","APEX_030000","APEX_030100","APEX_030200","APEX_040000","APEX_040100","APEX_040200","APEX_050000","APEX_050100","APEX_LISTENER","APEX_PUBLIC_USER","APEX_REST_PUBLIC_USER","APPQOSSYS","AUDSYS","AURORA$ORB$UNAUTHENTICATED","AWR_STAGE","BI","BLAKE","CLARK","CSMIG","CTXSYS","DBSFWUSER","DBSNMP","DEMO","DIP","DMSYS","DSSYS","DVF","DVSYS","EXFSYS","FLOWS_030000","FLOWS_FILES","GSMADMIN_INTERNAL","GSMCATUSER","GSMUSER","HR","IX","JONES","LBACSYS","MDDATA","MDSYS","MGMT_VIEW","OE","OJVMSYS","OLAPSYS","OPS$","ORACLE_OCM","ORDDATA","ORDPLUGINS","ORDSYS","ORDS_METADATA","ORDS_PUBLIC_USER","OUTLN","OWBSYS","OWBSYS_AUDIT","PERFSTAT","PM","QUEST","RDSADMIN","REMOTE_SCHEDULER_AGENT","SCOTT","SH","SI_INFORMTN_SCHEMA","SPATIAL_CSW_ADMIN_USR","SPATIAL_WFS_ADMIN_USR","SPOTLIGHT","SYS","SYSADM","SYSBACKUP","SYSDG","SYSKM","SYSMAN","SYSTEM","TRACESVR","TSMSYS","WKPROXY","WKSYS","WK_TEST","WMSYS","XDB","XS$NULL"],"origin":null},"GREENPLUM":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":[],"userDefinedSchemas":[],"systemSchemasOptions":["gp_toolkit","information_schema","pg_aoseg","pg_bitmapindex","pg_catalog","pg_toast","pg_temp_%"],"origin":null},"AZURE_MSSQL":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":["%.INFORMATION_SCHEMA","%.sys"],"userDefinedSchemas":[],"systemSchemasOptions":["INFORMATION_SCHEMA","sys"],"origin":null},"VERTICA":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":[],"userDefinedSchemas":[],"systemSchemasOptions":["v_internal","v_catalog","v_monitor"],"origin":null},"SNOWFLAKE":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":[],"userDefinedSchemas":[],"systemSchemasOptions":["SNOWFLAKE","%.ACCOUNT_USAGE","%.READER_ACCOUNT_USAGE","%.ORGANIZATION_USAGE","%.INFORMATION_SCHEMA"],"origin":null},"DB2LUW":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":[],"userDefinedSchemas":[],"systemSchemasOptions":["ERRORSCHEMA","NULLID","SQLJ","SYSCAT","SYSFUN","SYSIBM","SYSIBMADM","SYSIBMINTERNAL","SYSIBMTS","SYSPROC","SYSPUBLIC","SYSSTAT","SYSTOOLS"],"origin":null},"TERADATA":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":[],"userDefinedSchemas":[],"systemSchemasOptions":["DBC"],"origin":null},"SYBASE_ASE":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":["%.INFORMATION_SCHEMA","%.webservices_role","%.sa_role","%.oper_role","%.keycustodian_role","%.sys","%.ha_role","%.js_admin_role","%.mon_role","%.navigator_role","%.public","%.sso_role","%.js_client_role","%.replication_role","%.js_user_role","%.messaging_role","%.sybase_ts_role","%.dtm_tm_role"],"userDefinedSchemas":[],"systemSchemasOptions":["master","model","sybsystemprocs","sybsystemdb","tempdb","sybsecurity","pubs2","pubs3","dbccdb","sybmgmtdb","%.sys","%.INFORMATION_SCHEMA","%.public","%.sa_role","%.sso_role","%.oper_role","%.sybase_ts_role","%.navigator_role","%.replication_role","%.dtm_tm_role","%.ha_role","%.mon_role","%.js_admin_role","%.messaging_role","%.js_client_role","%.js_user_role","%.webservices_role","%.keycustodian_role"],"origin":null},"NETEZZA":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":[],"userDefinedSchemas":[],"systemSchemasOptions":["SYSTEM","%.DEFINITION_SCHEMA","%.INFORMATION_SCHEMA"],"origin":null},"POSTGRESQL":{"hideEmpty":true,"hideEmptyDb":true,"systemSchemas":["pg_toast%","information_schema","pg_catalog","pg_temp%"],"userDefinedSchemas":[],"systemSchemasOptions":["pg_catalog","information_schema","pg_temp%","pg_toast%"],"origin":null}}}
    vertica_driver_file=
    whatsnew_content_server_url=https://{0}.cloudfront.net/{1}/{2}/whatsNew.html
    whatsnew_list_server_url=https://{0}.cloudfront.net/?versionNumber={1}&buildNumber={2}
    wla_log=false

2023-08-19 19:15:22.619 [  30]     GENERAL MANDATORY Windows 10 10.0 amd64 Java version: Corretto-11.0.7.10.1
2023-08-19 19:15:22.629 [  30]     GENERAL MANDATORY Used memory: 475.31 MB, Free memory: 1 GB, Total memory: 1.47 GB, Maximum memory: 3.49 GB
2023-08-19 19:15:22.630 [  30]     GENERAL MANDATORY Package name: <n/a>
Library list: 
    AWSSchemaConversionTool.jar
    AWSSchemaConversionToolBatch.jar

2023-08-19 19:15:22.649 [  31]     GENERAL INFO    Attached GC listener to PS MarkSweep
2023-08-19 19:15:22.649 [  31]     GENERAL INFO    Attached GC listener to PS Scavenge
2023-08-19 19:15:23.899 [  31]     GENERAL INFO    user.timezone=Asia/Calcutta timezone.offset=+05:30
2023-08-19 19:15:23.901 [  31]     GENERAL INFO    JVM Arguments:
	-Djava.library.path=C:\Program Files\AWS Schema Conversion Tool\app;C:\Program Files\AWS Schema Conversion Tool
	-Djava.launcher.path=C:\Program Files\AWS Schema Conversion Tool
	-Xss128M
	-Dfile.encoding=UTF-8
	-XX:+UseParallelGC
	--add-opens=java.base/jdk.internal.loader=ALL-UNNAMED
	--add-exports=java.base/jdk.internal.loader=ALL-UNNAMED
	--add-exports=java.base/jdk.internal.misc=ALL-UNNAMED
2023-08-19 19:15:26.249 [  28]          UI INFO    Main window is initialized
2023-08-19 19:15:37.658 [  28]          UI INFO    Showing Global settings dialog: loggingTab
2023-08-19 19:15:55.777 [  28]     GENERAL INFO    global_settings saved.
2023-08-19 19:15:55.777 [  28]          UI INFO    Ok settings button pressed
2023-08-19 19:15:55.778 [  28]     GENERAL INFO    Fire event update dms current settings
2023-08-19 19:15:57.391 [  28]          UI INFO    Opening File menu item
2023-08-19 19:15:59.254 [  28]          UI INFO    Opening File menu item
2023-08-19 19:16:01.096 [  28]      PARSER WARNING Parser is blocked: Cache size is 0.
2023-08-19 19:16:02.436 [  28]          UI INFO    Creating new project: AWS Schema Conversion Tool Project2
2023-08-19 19:16:02.639 [  28]          UI INFO    Action: [RefreshAllWithNotification], handler: [DmsExtractorWorkHandler]
2023-08-19 19:16:02.665 [  28]          UI INFO    Starting task Database Migra
2 Answers
0
Accepted Answer

I installed SQL Express 2019 instead ofSQL Express 2022 and I was able to connect to SQL Express 2019 from SCT.

wilson
answered 8 months ago
0

According to step 4 you enter your instance name when adding a connection.

https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Source.SQLServer.html

profile picture
EXPERT
answered 8 months ago
  • As you can see I have already specified sqlexpress as the instance name..

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions