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.
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
359
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
587
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
417
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
489
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
446
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
199
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
720
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
650
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
721
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
463
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
601
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
341
views
asked a year agolg...