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.
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
Language
English
asked 8 months ago345 viewslg...
2 Answers
- Newest
- Most votes
- Most comments
Are these answers helpful? Upvote the correct answer to help the community benefit from your knowledge.
0
Accepted Answer
I installed SQL Express 2019 instead ofSQL Express 2022 and I was able to connect to SQL Express 2019 from SCT.
answered 8 months agolg...
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
Relevant content
- asked 2 years agolg...
- asked a year agolg...
- asked 2 years agolg...
- asked 3 years agolg...
- AWS OFFICIALUpdated 8 months ago
- AWS OFFICIALUpdated 10 months ago
- AWS OFFICIALUpdated a year ago
As you can see I have already specified sqlexpress as the instance name..