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.
Hi team,
I ran the SQL server assessment report and in the report, TDE and Full-text are mentioned as not supported in RDS SQL Server but I think TDE is supported by SQL server 2019. May I know why...
1
answers
0
votes
344
views
asked a year agolg...
We have a SQL Server RDS instance that runs in us-east-1. We just upgrade the instance and the "clr enabled" setting went from 1 to 0.
In the default parameter groups, the "clr enabled" setting is...
0
answers
0
votes
83
views
asked a year agolg...
Hello all, hope you can help.
We're hosting a new SQL 2016 RDS instance we'll call this the target DB. There is a 3rd party that is syncing data into the target DB on this instance using AWS's CDC...
0
answers
0
votes
126
views
asked a year agolg...
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
1931
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
254
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
243
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
332
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
362
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
493
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
685
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
856
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
1400
views
asked a year agolg...