Questions tagged with Microsoft SQL Server

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...

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?

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...

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?

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...

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...

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...

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...

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...

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...

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...

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...