I created an RDS instance with SQL Server Express Edition on it. The instance setup was all fine, and I also succeeded connecting to it.
But once connected using the master user, I cannot create any database, schema or table on the server. It keeps saying that the user does not have permission to perform the operation.
What could I be missing? Shouldn't the master user be having all the privileges by default? If not, how should I proceed?
Thanks for any help!
This is what I'm trying to run:
CREATE TABLE [dbo].[wt_category] ( [sys_id] bigint NOT NULL IDENTITY(1,1) , [sys_timestamp] timestamp NOT NULL , [country] varchar(5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [days] date NOT NULL , [pages] varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL DEFAULT NULL , [visits] int NULL DEFAULT NULL , [page_impressions] int NULL DEFAULT NULL , [visits_w_product] int NULL DEFAULT NULL , [products] varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , PRIMARY KEY ([sys_id]) )
and I get this error:
[Err] 42000 - [SQL Server]CREATE TABLE permission denied in database 'rdsadmin'.