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,
We are doing the assessments and found the database compression in the report- does the RDS SQL server supports database compression?
If yes, which version will support in RDS( on-premises...
1
answers
0
votes
831
views
asked a year agolg...
Fellow RDS/SQL dbas,
I need a login id to have db_datareader access to msdb in RDS.
When I try it, I get:
Cannot alter the role 'db_datareader', because it does not exist or you do not have...
1
answers
0
votes
772
views
asked a year agolg...
Hi everyone,
I am facing the IAM role Arn invalid error while trying to run below template. The IAM role getting error is used in the option group for audit logs. In the parameter section it is...
1
answers
0
votes
784
views
asked a year agolg...
We have 2 MS SQL server instances:
Instance 1: MS SQL Server Standard Edition - db.r5.large
Instance 2: MS SQL Server Web Edition- db.r5.large
**Both these instances are in the same VPC and they both...
1
answers
0
votes
517
views
asked a year agolg...
Hello, Im new on EC2 and RDS, and having difficulties on finding SQL Server Agent on the SSMS i have installed on RDS. i have included the screenshot here. please kindly help to navigate where to look...
1
answers
0
votes
661
views
asked a year agolg...
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
374
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
92
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
138
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
2223
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
285
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
269
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
367
views
asked a year agolg...