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
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:http://solliodev.
eastus.azurecontainer.io:7049/NAV/dev/packages?publisher=Micros
oft&appName=System&versionText=11.0.0.0;
StatusCode:Unauthorized; ReasonPhrase:Unauthorized;
ResponseBody: {"Message":"Authorization has been denied
for this request."}
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:http://solliodev.
eastus.azurecontainer.io:7049/NAV/dev/packages?publisher=Micros
oft&appName=Application&versionText=11.0.0.0;
StatusCode:Unauthorized; ReasonPhrase:Unauthorized;
ResponseBody: {"Message":"Authorization has been denied
for this request."}
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
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
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
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:http://solliodev.
eastus.azurecontainer.io:7049/NAV/dev/packages?publisher=Micros
oft&appName=System&versionText=11.0.0.0 ;
StatusCode:Unauthorized; ReasonPhrase:Unauthorized;
ResponseBody: {"Message":"Authorization has been denied
for this request."}
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:http://solliodev.
eastus.azurecontainer.io:7049/NAV/dev/packages?publisher=Micros
oft&appName=Application&versionText=11.0.0.0 ;
StatusCode:Unauthorized; ReasonPhrase:Unauthorized;
ResponseBody: {"Message":"Authorization has been denied
for this request."}
ProcessId: 5944
Tag: 00000LY
ThreadId: 68
CounterInformation: