Questions tagged with Microsoft SQL Server
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
I have created an instance of g5.xlarge with the Microsoft WIndows 2019 Server and MSSQL Server Standard 2019 AMI. When I tried to launch the instance, it failed at launch initiation with the...
2
answers
0
votes
1880
views
asked a year agolg...
How could the following error be resolved when upgrading SQL Server on EC2 from 2017 to 2019 using AWSEC2-CloneInstanceAndUpgradeSQLServer "Status": "Failed", "ResponseCode":1, "Output": "MSSQLSERVER...
1
answers
0
votes
251
views
asked a year agolg...
It would be useful while full load is running to see in "Table Statistics" tab each table estimated progress in percentage ([target loaded rows]/[source_table_row_count]*100) based on the source table...
1
answers
0
votes
240
views
asked a year agolg...
Hi Team ,
We are doing an assessment for SQL Server to RDS SQL server using SCT.
can I hide(exclude) the system databases( master, MSDB, Model, Report server databases) from assessments report.
As...
1
answers
0
votes
321
views
asked a year agolg...
AWS SCT for SQL RDSlg...
Hi Team,
I have done some Assessment reports for SQL server to RDS SQL Server and in reports everything is green but when iam connected to Target and applied the database to RDS SQL server, i am...
1
answers
0
votes
353
views
asked a year agolg...
Hello,
We are looking at using one of the AWS supplied AMI's with SQL Server 2022 Standard included. We also have a need to install older versions of SQL Server to extract data and possibly install...
1
answers
0
votes
484
views
asked a year agolg...
We recently upgraded SQL Server from 2016 to 2022 and we had DMS tasks with CDC that was using SQL Server as a source. These tasks are now failing and if I point the endpoint to the SQL Server 2016,...
3
answers
3
votes
676
views
asked a year agolg...
I have two DMS tasks which load to the same table (both source and target are SQL Server 2017) with different filters - the task that succeeds has this filter:
```
"filters": [
...
1
answers
0
votes
834
views
asked a year agolg...
I have created a new SQL user on an RDS (Not custom) database with :
`USE master;
GO
CREATE LOGIN my_user WITH PASSWORD = 'my_password';
GO`
And now I want to assign roles to them (dbcreator,...
2
answers
0
votes
1370
views
asked a year agolg...
Hi,
We have one Windows instance with AWS cloud and our SQL Server is installed on this windows instance.
We want to connect to the SQL Server on AWS Windows instance from our work computers but...
2
answers
0
votes
458
views
asked a year agolg...
We have been able to connect to a Microsoft SQL Server DB using both Glue's DynamicFrame and Spark's own JDBC write option due to the Glue connection option.
However, we want to move this workload to...
1
answers
0
votes
629
views
asked a year agolg...
I need to create an RDS SQL Instance with a time zone that is tolerant of UK daylight savings changes. From the RDS documentation, I can see there is a time zone called "GMT Standard Time" that is...
1
answers
0
votes
381
views
asked a year agolg...