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.
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
1893
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
252
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
324
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
357
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
486
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
682
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
841
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
1382
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
462
views
asked a year agolg...