Setup Sysadmin role in RDS SQL Server

Question

Hi there

I have added the master account while creating the RDS Microsoft SQL Server with Dev/Test option. However I need an account with Sysadmin role. Could you please guide me how can I add/create a new user with Sysadmin role? Do I need to create a different type type of RDS SQL Server? Thanks in advanve.

Best Musharrif

Answer

the 'sysadmin' role itself is reserved for the 'rdsa' internal SQL Server account, which is managed by the Amazon RDS service and not accessible to users.

you can create a new user and assign db_owner role

```
CREATE LOGIN [NewUserName] WITH PASSWORD = 'NewUserPassword';
GO

USE [YourDatabaseName];
GO

CREATE USER [NewUserName] FOR LOGIN [NewUserName];
GO

EXEC sp_addrolemember 'db_owner', 'NewUserName';
GO

```

Setup Sysadmin role in RDS SQL Server

Contenuto pertinente