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
354
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
354
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
369
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
610
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
441
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
513
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
463
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
214
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
749
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
681
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
732
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
475
views
asked a year agolg...