Hi all,
We have installed Docker in Linux,
When i tried to connect remotely SQL Server Named instance of SQL Server from Docker(Linux) We got server not found error but when we tried to connect SQL Server default instance it is working
Any one any suggestion to solve this?
./run-importer.ps 5001 'Server=x.x.x.x.\namedSQLrinstance,1433; Database=dbnamet; User Id=login_name; Password=Pa$$word; Persist Security Info=true;'
Error info:
System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 35 - An internal exception was caught) ---> System.AggregateException: One or more errors occurred. (Name or service not known) ---> System.Net.Internals.SocketExceptionFactory+ExtendedSocketException (00000005, 0xFFFDFFFF): Name or service not known at System.Net.Dns.GetHostEntryOrAddressesCore(String hostName, Boolean justAddresses) at System.Net.Dns.<>c.<GetHostEntryOrAddressesCoreAsync>b__27_2(Object s) at System.Threading.Tasks.Task`1.InnerInvoke() at System.Threading.Tasks.Task.<>c.<.cctor>b__277_0(Object obj) at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at System.Data.SqlClient.SNI.SNITCPHandle.ConnectAsync(String serverName, Int32 port) --- End of inner exception stack trace --- at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken) at System.Threading.Tasks.Task.Wait(TimeSpan timeout) at System.Data.SqlClient.SNI.SNITCPHandle..ctor(String serverName, Int32 port, Int64 timerExpire, Object callbackObject, Boolean parallel) --- End of inner exception stack trace --- at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen() --- End of stack trace from previous location --- at Services.SalesAreaService.StoreSalesAreaData(IEnumerable`1 salesAreas) in /src/Services/SalesAreaService.cs:line 46 at GeoDataFeed.API.Controllers.SalesAreaController.ProcessFile() in /src/GrafanaSalesData.API/Controllers/GeoDataController.cs:line 63 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|19_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger) at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIMiddleware.Invoke(HttpContext httpContext) at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext, ISwaggerProvider swaggerProvider) at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware.Invoke(HttpContext context) ClientConnectionId:00000000-0000-0000-0000-000000000000 HEADERS ======= Connection: keep-alive Accept: */* Accept-Encoding: gzip, deflate, br Accept-Language: en-GB,en-US;q=0.9,en;q=0.8 Cookie: WAC-SESSION=954414469e3f4caeaebcaed421c1f6a1; clientCertificate=3%3AMIIDNjCCAh6gAwIBAgIQdpBJN0kBybBGeTLNCh4IiDANBgkqhkiG9w0BAQsFADAfMR0wGwYDVQQDDBRXaW5kb3dzIEFkbWluIENlbnRlcjAeFw0yMjA0MTYxMDQwMzJaFw0zMjA0MTYxMDQwMjlaMCYxJDAiBgNVBAMMG1dpbmRvd3MgQWRtaW4gQ2VudGVyIENsaWVudDCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAMlnBk1AZ%2FnSatVnjXNVat%2Foq08PaN9YqcliQKcJl9vrZf%2B88fw%2BemTbDwOgzUO02oCKnQFDYowyYVCeO%2FXfvaseK78xeeWbEk8MaCwbP8dwKn7AMe874ilhoRRqQK0o5mtTBjnqLMWwIpIzDOJXmh1NWHQh8kGu%2BKiGhy96N1QxdHsylHvUMwU70yn3Gj9M8bmEN998x%2B27KBfW0RZHzZomgAP56E2il8z8c1h%2Boyct0TKq2bosxcalbBJ53nBBGfJQg8ecEnF3zpKWHihSR4dTJng1gjtBOJ8FI5HcjuHJi1%2FVZ2nlB%2BVbIi2Ei4fIo%2BRUjQL%2BVy6KetiLK6Foue0CAwEAAaNnMGUwDgYDVR0PAQH%2FBAQDAgOIMBMGA1UdJQQMMAoGCCsGAQUFBwMCMB8GA1UdIwQYMBaAFGZx52O%2B2%2FGEcAFjIgmcnVQfr6WTMB0GA1UdDgQWBBRD3zktWZXZDefVt6%2FwS%2FrvXuqMODANBgkqhkiG9w0BAQsFAAOCAQEAtob123T1fpzY%2Fg%2BGSK%2FTvs5ZAZP9ci6TJkm2O0dfFO17gcuPV0tNfzLEL0NDtQEaqyRKRzT%2Bzn1uL1GumNvYzV5bUsJny4crvfhITq2o6ZmDXm9r1Gj%2Fmt%2FPvtOkT6JNniBBdeScYdD4NuhDcwkKT7xb26ccalGeQPiujlXp5SIo8qOgqrVV%2FrzVO8Tx70QzPKcNUCDQXhgbQ2sU2LoFm%2BjKwKXlwVGSF3PCG1s7g9sImKc8KkPJdk1s%2F%2BXCtEDr4cQZ4Duay2TzXoxUFvV68zsjHznDcdOj626DorbBmIlXo9c35y4yM8z7JpdI3UB3iDQBAaamdlhP4s7AsI6KEA%3D%3D; XSRF-TOKEN=b97b1f13-ce76-4a28-886a-66093a24e14b; testcookie=; am_check=; am_username=; memarketing-_zldp=Mltw9Iqq5RR5e3%2BXxFGv%2BfOXNCMMN3wJV9LVEzS3f9NCZpzk8AJYIrLvEVaXIGC5ACit%2FDUE7Go%3D; csrfToken=e1f08a1c34c67ab17ff05c32dfd0ded227bb3a2daf9d561b40470d2919bb28fb698631d4415fe5cb48deb8b0f1c4c23384d9a8379c165582555babaab66eccf9; _zcsr_tmp=e1f08a1c34c67ab17ff05c32dfd0ded227bb3a2daf9d561b40470d2919bb28fb698631d4415fe5cb48deb8b0f1c4c23384d9a8379c165582555babaab66eccf9; monitordnd=%5B%7Bbay%3A%27DRAG_APPEND_1%27%2Cchildren%3A%5B%7Btab%3A%27DRAG_1%27%2Cstate%3A%27on%27%2Ccontent%3A%27show%27%7D%2C%7Btab%3A%27DRAG_9%27%2Cstate%3A%27on%27%2Ccontent%3A%27show%27%7D%2C%7Btab%3A%27DRAG_10%27%2Cstate%3A%27on%27%2Ccontent%3A%27show%27%7D%5D%7D%2C%7Bbay%3A%27DRAG_APPEND_2%27%2Cchildren%3A%5B%7Btab%3A%27DRAG_7%27%2Cstate%3A%27on%27%2Ccontent%3A%27show%27%7D%2C%7Btab%3A%27DRAG_11%27%2Cstate%3A%27on%27%2Ccontent%3A%27show%27%7D%2C%7Btab%3A%27DRAG_15%27%2Cstate%3A%27on%27%2Ccontent%3A%27show%27%7D%5D%7D%2C%7Bbay%3A%27DRAG_APPEND_3%27%2Cchildren%3A%5B%7Btab%3A%27DRAG_3%27%2Cstate%3A%27on%27%2Ccontent%3A%27show%27%7D%2C%7Btab%3A%27DRAG_4%27%2Cstate%3A%27on%27%2Ccontent%3A%27show%27%7D%2C%7Btab%3A%27DRAG_13%27%2Cstate%3A%27on%27%2Ccontent%3A%27show%27%7D%5D%7D%2C%7Bbay%3A%27DRAG_APPEND_4%27%2Cchildren%3A%5B%7Btab%3A%27DRAG_6%27%2Cstate%3A%27on%27%2Ccontent%3A%27show%27%7D%2C%7Btab%3A%27DRAG_12%27%2Cstate%3A%27on%27%2Ccontent%3A%27show%27%7D%5D%7D%2C%7Bbay%3A%27DRAG_APPEND_5%27%2Cchildren%3A%5B%7Btab%3A%27DRAG_8%27%2Cstate%3A%27on%27%2Ccontent%3A%27show%27%7D%2C%7Btab%3A%27DRAG_14%27%2Cstate%3A%27on%27%2Ccontent%3A%27show%27%7D%2C%7Btab%3A%27DRAG_16%27%2Cstate%3A%27on%27%2Ccontent%3A%27show%27%7D%5D%7D%5D; selectedDropDown=hometabtd; allResourceTable_sortdir=down; allResourceTable_sortcol=1; MonitorAvailablityTable_sortdir=down; MonitorHealthTable_sortdir=down; ScreenWidth=1903; hostServicesList10000118_sortdir=down; hostServicesList10000118_sortcol=1; 10000118_host_seltab=0; diagnosticsAlarmTable_sortdir=down; selectedtabId=monitortab; am_browserCountry=INDIA; JSESSIONID_APM_9090=7EF1E071DB7027DF7B5046E3D275F90F Host: localhost:5001 Referer: http://localhost:5001/swagger/index.html User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.64 Safari/537.36 Origin: http://localhost:5001 Content-Length: 0 sec-ch-ua: " Not A;Brand";v="99", "Chromium";v="101", "Google Chrome";v="101" sec-ch-ua-mobile: ?0 sec-ch-ua-platform: "Windows" Sec-Fetch-Site: same-origin Sec-Fetch-Mode: cors Sec-Fetch-Dest: empty
Note:
We have installed named instance of SQL Server locally in docker but when we tried to connect locally by named instance it is working but we have issue in remote SQL Server only
