AWS sql server Connection ERROR RSS

• • Reply
  djreggaestyl...

  None

  0 Points

  1 Post

  AWS sql server Connection ERROR

  Oct 07, 2019 05:15 PM|djreggaestyles|LINK

  using dotNet Core

  I am using the below connection string within the appsettings.json  file  (AWS sql server)

  "ConnectionStrings": {"EmployeeDBConnection": "server=XXXX.XXXXXXXX.us-east-1.rds.amazonaws.com;database=MYDB;Trusted_Connection=true"

  }

  or

  "ConnectionStrings": {EmployeeDBConnection": "server=XXXX.XXXXXXXX.us-east-1.rds.amazonaws.com;database=MYDB;id=myid;password=password123"

  within my startup.cs  file i have 

  services.AddDbContext<AppDbContext>(
  options => options.UseSqlServer(_config.GetConnectionString("EmployeeDBConnection")));

  but i still get  a NULL parameter error. Please advise

• • Reply
  bruce (sqlwo...

  All-Star

  58164 Points

  15646 Posts

  Re: AWS sql server Connection ERROR

  Oct 08, 2019 12:27 AM|bruce (sqlwork.com)|LINK

  Trusted connection is not going to work unless you are running Sqlserver in your VM and set up domain support. You need to use standard security. See the docs

  https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToMicrosoftSQLServerInstance.html

  bruce (sqlwork.com)