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 assessment for SQL server and the SCT report has 9996 error code and mentions as "Please submit the report to the developer"
How we can identify the what are issues with...
3
answers
0
votes
346
views
asked a year agolg...
Hi Team,
We are assessing the SQL server and found from the SCT report that the features below are used on-premises. Please suggest how we can decide target(RDS/Custom RDS/EC2).
1. Full-Text...
1
answers
0
votes
348
views
asked a year agolg...
Please, I have just created an instance of SQL Server at Lightsail, I have a Static IP though I am not able to connect using SSMS (SQL Server Management Studio) that it´s installed in my notebook.
Can...
2
answers
0
votes
364
views
asked a year agolg...
Can RDS (sql server) access file shares/fsx shares? i need to host files to be ingested to rds databases in/out via file shares. i wanted to know if this is possible? if so, what needs to be done?
1
answers
0
votes
598
views
asked a year agolg...
Hi ,
We are doing the AWS SQL Server assessments- in the SCT report, I have received the DB Mail configuration not fully supported in AWS and suggesting the use of the SNS services. Can we can use...
1
answers
0
votes
432
views
asked a year agolg...
I was looking through available instance sized for Windows Server and SQL Server on Amazon EC2
and couldn't find one with 8 vCPUs and 128 GiB RAM.
Why is that?
2
answers
0
votes
502
views
asked a year agolg...
Hi,
I have 32TB of data stored on S3 Standard bucket and would like to make a copy to my on-premise SQL Server (local machine) via SQL Server Integration Services (SSIS).
(1) I am wondering does it...
2
answers
0
votes
455
views
asked a year agolg...
Hi all,
As part of our DR plan, we'd like to setup AWS DMS service with MSSQL 2019 SE RDS Cloud DB as source and MSSQL 2012 SE On-premise DB instance as our target to replicate changes from RDS MSSQL...
0
answers
0
votes
207
views
asked a year agolg...
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
736
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
660
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
725
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
471
views
asked a year agolg...