Created a AWS RDS Instance with SQL Server – Enterprise version and did the default VPC / Security Group ( at this time – Active Directory wasn’t set up neither the Option group or the Parameter group was set up and assigned ) .
Did work on creating a DB in the AWS RDS instance and connected with SQL Server Authentication . Then started setting up Option Group with (SSIS ) and Parameter group . Created an Active directory for the SSIS version with the security group that was used in AWS RDS . Modified the AWS RDS instance and added the Active directory / assigned the option and Parameter group . And applied the changes immediately – after doing this created a user login and executed the permissions .
Need to understand how can I set up Windows Authentication with all the above . We have the AWS RDS Instance – has the security group with AD set up all in the same VPC – also shares the same security group / availability zone and everything . I would like to understand if I can do a connect with SSMS that I have which gets connects to AWS RDS db instance through Windows Authentication . Do I need to have this SSMS is another EC2 box or something like that or is it possible to connect directly with Windows Authentication on my laptop which is no where connected or set up with any Active Directory . Let me know if there is a need of more details .
Did go through the following sites and completed all the instructions :
https://aws.amazon.com/blogs/database/using-microsoft-sql-server-integration-services-on-amazon-rds-for-sql-server/
AWS UFFICIALEAggiornata 2 anni fa