Questions tagged with Microsoft SQL Server

Content language: English

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...
1
answers
0
votes
16
views
asked 5 days ago
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
24
views
rmmyers
asked 5 days ago
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
22
views
asked 7 days ago
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
43
views
asked 9 days ago
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
118
views
asked 12 days ago
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
44
views
asked 13 days ago
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
67
views
asked 18 days ago
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
52
views
asked 18 days ago
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
67
views
Tausif
asked 20 days ago
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
41
views
asked 20 days ago
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
40
views
asked 20 days ago
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...
0
answers
0
votes
53
views
asked 21 days ago