Last post Oct 08, 2019 12:27 AM by bruce (sqlwork.com)
None
0 Points
1 Post
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
All-Star
53594 Points
13323 Posts
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
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
All-Star
53594 Points
13323 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