Skip to content
This repository has been archived by the owner on Jan 23, 2020. It is now read-only.

Can't connect to my Azure Docker Image BDD from SQL Management Studio #81

Open
Kichnifou opened this issue Sep 30, 2019 · 0 comments
Open

Comments

@Kichnifou
Copy link

Expected behavior

(Sorry by advance for my bad english)

I want to open my Azure Docker Image BDD from SQL Management Studio to manage it (for exemple, restore the BDD to have my own data)

Actual behavior

When I try to connect from SQL Management Studio it doesn't work
I tried to ping the server or IP address, it didn't work too

Information

  • I use a Dynamics NAV 2018 Azure Docker Image
  • I deployed image thanks to this script :
    az container create -g myNAVRG -n solliodev --image microsoft/dynamics-nav:2018 --os-type Windows --cpu 2 --memory 4 --ip-address public -e ACCEPT_EULA=Y ACCEPT_OUTDATED=Y USESSL=N ClickOnce=Y publicDnsName=solliodev.eastus.azurecontainer.io --dns-name-label solliodev --ports 80 1433 7046 7049 8080
  • This is the result of the "logs" command (there is two error that I'm not understand, maybe it's the reason why ?)
az container logs --resource-group myNAVRG --name solliodev
Initializing...
Starting Container
Hostname is aac790de0edd
PublicDnsName is solliodev.eastus.azurecontainer.io
Using NavUserPassword Authentication
Starting Local SQL Server
Starting Internet Information Server
Creating Self Signed Certificate
Self Signed Certificate Thumbprint A80CBF472AF132C3F20FBC9782E97D70C7B260C8
Modifying Service Tier Config File with Instance Specific Settings
Starting Service Tier
Creating DotNetCore Web Server Instance
Creating http download site
Creating Windows user admin
Setting SA Password and enabling SA
Creating admin as SQL User and add to sysadmin
Creating SUPER user
Creating ClickOnce Manifest
Container IP Address: 172.17.5.135
Container IP Address: 10.244.44.7
Container Hostname  : aac790de0edd
Container Dns Name  : solliodev.eastus.azurecontainer.io
Web Client          : http://solliodev.eastus.azurecontainer.io/NAV/
Admin Username      : admin
Admin Password      : Gohi7855
Dev. Server         : http://solliodev.eastus.azurecontainer.io
Dev. ServerInstance : NAV
ClickOnce Manifest  : http://solliodev.eastus.azurecontainer.io:8080/NAV

Files:
http://solliodev.eastus.azurecontainer.io:8080/al-0.13.111304.vsix

WARNING: You are running a container which is 183 days old.
Microsoft recommends that you always run the latest version of our containers.

Initialization took 132 seconds
Ready for connections!


TimeGenerated : 9/30/2019 2:57:19 AM
EntryType     : Error
Message       : Length specified in network packet payload did not match
                number of bytes read; the connection has been closed. Please
                contact the vendor of the client library. [CLIENT:
                10.240.255.56]





TimeGenerated : 9/30/2019 11:55:33 AM
EntryType     : Error
Message       : Server instance: NAV
                Category: Development
                ClientSessionId: 00000000-0000-0000-0000-000000000000
                ClientActivityId: 00000000-0000-0000-0000-000000000000
                ServerSessionUniqueId: 00000000-0000-0000-0000-000000000000
                ServerActivityId: 00000000-0000-0000-0000-000000000000
                EventTime: 09/30/2019 11:55:33
                Message Failed request -- Method:GET; Url:<ii>http://solliodev.
                eastus.azurecontainer.io:7049/NAV/dev/packages?publisher=Micros
                oft&appName=System&versionText=11.0.0.0</ii>;
                StatusCode:Unauthorized; ReasonPhrase:Unauthorized;
                ResponseBody: <pi>{"Message":"Authorization has been denied
                for this request."}</pi>
                ProcessId: 5944
                Tag: 00000LY
                ThreadId: 79
                CounterInformation:

TimeGenerated : 9/30/2019 11:55:33 AM
EntryType     : Error
Message       : Server instance: NAV
                Category: Development
                ClientSessionId: 00000000-0000-0000-0000-000000000000
                ClientActivityId: 00000000-0000-0000-0000-000000000000
                ServerSessionUniqueId: 00000000-0000-0000-0000-000000000000
                ServerActivityId: 00000000-0000-0000-0000-000000000000
                EventTime: 09/30/2019 11:55:33
                Message Failed request -- Method:GET; Url:<ii>http://solliodev.
                eastus.azurecontainer.io:7049/NAV/dev/packages?publisher=Micros
                oft&appName=Application&versionText=11.0.0.0</ii>;
                StatusCode:Unauthorized; ReasonPhrase:Unauthorized;
                ResponseBody: <pi>{"Message":"Authorization has been denied
                for this request."}</pi>
                ProcessId: 5944
                Tag: 00000LY
                ThreadId: 68
                CounterInformation:

Steps to reproduce the behavior

  1. Generate the docker image with my script
  2. Try to ping the IP address or the server
  3. Try to connect from SQL Management Studio

OR MORE SYMPLY : Maybe you can try to connect to this image from your own device

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant