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 Antworten
0
Akzeptierte Antwort

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

wilson
beantwortet vor 8 Monaten
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
EXPERTE
beantwortet vor 9 Monaten
  • As you can see I have already specified sqlexpress as the instance name..

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen