c# - Connect to SQL Server database from a docker container -


i have docker windows installed on machine. there console application targeting .net core 1.0.0 tries access sql server database running on different vm. can ping vm running sql server machine.

when try run console application using dotnet run command prompt on machine works fine. when same application run inside docker container message

a network-related or instance-specific error occurred while establishing connection sql server. server not found or not accessible. verify instance name correct , sql server configured allow remote connections. (provider: tcp provider, error: 40 - not open connection sql server)

i tried using 

docker run --add-host sqldemo:<vm running sql server ip here>

but made no difference.

assumptions

  • microsoft sql server 2016
  • windows 10 anniversary update
  • windows containers
  • asp.net core application

add sql user sql database.

  • in ms sql expand database
  • right click on 'security / logins'
  • select 'new login'
  • create user name , password.
  • assign 'server role(s)'...i used sysadmin since i'm testing
  • under 'user mapping' added new user database , used 'dbo' schema.

change sql authentication allow sql server authentication mode

right click on database, select 'properties / security / server authentication / sql server , windows authentication mode' radio button. restart ms sql service.

update appsettings.json new user name , password

example "connectionstrings": { "defaultconnection": "server=yourservername;database=yourdatabasename;multipleactiveresultsets=true;user id=usernameyoujustadded;password=passordyoujustcreated" },

make sure remove trusted_connection=true.

create docker file

my example docker file

microsoft/dotnet:nanoserver arg source=. workdir /app expose 5000 expose 1433 env aspnetcore_urls http://+:5000 copy $source .

publish application

running same location docker file in elevated powershell

dotnet publish

docker build bin\debug\netcoreapp1.0\publish -t aspidserver

docker run -it aspidserver cmd

i wanted run container , see output running in powershell.

once container , running in container @ command prompt kicked off application.

dotnet nameofapplication.dll

if went plan 1 should , running.


Comments

Post a Comment

Popular posts from this blog

jOOQ update returning clause with Oracle -

according http://www.jooq.org/doc/3.8/manual/sql-building/sql-statements/update-statement/ jooq doesn't support returning clause in update statements databases except firebird , postgres. does know, still correct oracle jooq? according oracle's documentation, oracle db supports returning clase delete, insert, or update statements. incorrect manual you're right - manual wrong , should fixed: https://github.com/jooq/jooq/issues/5470 single row update returning jooq 3.8 added support single row update .. returning statements. internally, uses callablestatement , pl/sql block of form: begin update "my_table" set "my_table"."column" = 'xyz' "my_table"."id" = 1 returning "my_table"."id", "my_table"."column" ?, ?; ? := sql%rowcount; end; the relevant issue is: https://github.com/jooq/jooq/issues/5190 multi row update returning a...
Read more

java - Warning equals/hashCode on @Data annotation lombok with inheritance -

i have entity inherits other. on other hand, i'm using lombok project reduce boilerplate code, put @data annotation. annotation @data inheritance produces next warning: generating equals/hashcode implementation without call superclass, though class not extend java.lang.object. if intentional, add '@equalsandhashcode(callsuper=false)' type. is advisable add annotation @equalsandhashcode (callsuper = true) or @equalsandhashcode (callsuper = false) ? if not added, 1 callsuper=false or callsuper=true ? the default value false . 1 if don't specify , ignore warning. yes, recommended add @equalsandhashcode annotation on @data annotated classes extend else object. cannot tell if need true or false , depends on class hierarchy, , need examined on case-by-case basis. however, project or package, can configure in lombok.config call super methods if not direct subclass of object. lombok.equalsandhashcode.callsuper = call for configuration system ...
Read more

java - BasicPathUsageException: Cannot join to attribute of basic type -

i using java 8 jpa (hibernate 5.2.1). have clause works perfectly, until introduce clause make use foreign key table values too. i getting following error: basicpathusageexception: cannot join attribute of basic type i think problem related fact have join table, , not sure how create join using join table. employee - employee_category - category model (employee.java): @manytomany(cascade = cascadetype.all, fetch=fetchtype.eager) @jointable ( name="employee_category", joincolumns={ @joincolumn(name="emp_id", referencedcolumnname="id") }, inversejoincolumns={ @joincolumn(name="cat_id", referencedcolumnname="id") } ) private set<category> categories; model (category.java): @id private string id; jpa when introduce following code, fails error above (i think problem new piece of code): join<t, category> category = from.join("id"); predicates.add(criteriabuilder.like(category....
Read more