Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    kirkfitzsimons
    @kirkfitzsimons
    Hi, anyone know how long it might take for an issue to be picked up? I came across an issue this morning, noticed that an issue has already been raised, microsoft/mssql-docker#544
    John Zabroski
    @jzabroski
    @kirkfitzsimons I guess if your company pays a lot of Windows licenses, faster than you might expect.
    The issue you linked to says it is now resolved.
    peace-blaster
    @peace-blaster
    Hey all- the 2019 SQL Server docker container seems to not have the sudo command by default. Does anyone know what the default SU password is for it? It's not the same as the SA password for SQL Server itself, and apparently I need at least sudo permissions to agree to the machine learning services EULA
    peace-blaster
    @peace-blaster

    Hey all- the 2019 SQL Server docker container seems to not have the sudo command by default. Does anyone know what the default SU password is for it? It's not the same as the SA password for SQL Server itself, and apparently I need at least sudo permissions to agree to the machine learning services EULA

    Nevermind, stupid question, but it does still seem that it's impossible to install machine learning services due to missing packages in Microsoft's repo.

    Michael Edwards
    @michael-d-edwards
    Hi, I was able to enable database encryption in the developer edition, very cool. Can anybody help me learn if/how the Service Master Key is protected?
    Alberto Martín
    @albertinisg
    Hi there! I'm working in a solution with windows containers, and I'm using mssql as a database. I orchestrate it with docker-compose, but I found that by default, the mssql docker container has only 2GB of RAM, which leads me into errors. I can start the container with the --memory flag using docker run, but can't address this issue with docker compose, as it says that Windows Containers are not compatible with `mem_limit flag. Anyone has faced the same issue?
    Michael Edwards
    @michael-d-edwards
    @albertinisg are you sure your memory issue is coming from the container and not the environment? The memory limit capability is about setting maximum allowed values and not minimum values. I was unable to start my mssql docker containers in 2GB VMs due to insufficient memory for mssql startup in the container.
    Alberto Martín
    @albertinisg
    You mean my host or any docker host configuration? If I create the container either with standard docker run or docker-compose, it starts with Total Physical Memory: 1,023 MB. My host has 16 GB and 9 GB available, so it should have enough to start with more. So if I run the container with the flag -m 4096, I can see inside with systeminfo that it has Total Physical Memory: 4,607 MB and it runs properly
    What I want to is to add this flag into docker-compose, but couldn't find how. By running it in compatibility mode it says this option is not available in Windows containers, and couldn't find a way to set the memory from compose
    Michael Edwards
    @michael-d-edwards
    @albertinisg I'm sorry to not be more help other than to point out that the docker run -m sets a maximum and not a minimum. I am not aware of a minimum and had assumed the container will consume available memory as needed unless constrained (e.g. by run -m parameter).
    thor
    @boistordu_gitlab
    hi guys, I'm new to this. I wanted to try t osetup a dev environment on my rasp pi4 on the go for mssql with docker but I got an error message. Is the docker images compatibles with arm or not ?
    Manigandan79
    @Manigandan79
    Hi guys, I am new to this, how can setup SQL version control in Devops apart from the CI/CD?
    Siraj K
    @sirajka
    I can't seem to start any SQL Server in our AWS Kubernetes cluster. Running developer edition, no persistent volume -- just /opt/mssql/bin/sqlservr. Tried RHEL, Ubuntu, 2019, 2017.
    This program has encountered a fatal error and cannot continue running at Fri May 22 13:44:19 2020
    The following diagnostic information is available:
    
             Reason: 0x00000002
         Parameters: 0x2002af9b0
                      [0] 0xffffffffc0000017
        Stack Trace:
                     file://package4/windows/system32/sqlpal.dll+0x000000000033D3A7
                     file://package4/windows/system32/sqlpal.dll+0x000000000033C8D0
                     file://package4/windows/system32/sqlpal.dll+0x000000000026694D
                     file://package4/windows/system32/sqlpal.dll+0x0000000000203243
                     file://package4/windows/system32/sqlpal.dll+0x000000000037CC08
                     file:///windows/system32/ntdll.dll+0x00000000000CBD48
                     file:///windows/system32/ntdll.dll+0x00000000000C36C5
                     file:///windows/system32/ntdll.dll+0x00000000000750DB
                     file:///windows/system32/ntdll.dll+0x000000000007508E
                     file://package4/windows/system32/sqlpal.dll+0x000000000024D837
                     file://package4/windows/system32/sqlpal.dll+0x000000000037E531
                     <unknown>+0x0000000022C2EA00
            Process: 8 - sqlservr
             Thread: 22 (application thread 0x2c)
        Instance Id: 6daa878c-f3a8-483d-b6ba-a94d2f0f64e2
           Crash Id: c72dc01f-2d61-4696-9437-7aad104ea807
        Build stamp: 5fe1db1037bde241cd5c20910433a2278daf1e28f58fcfd0640f3a3d2fd5e6cd
       Distribution: Ubuntu 16.04.6 LTS
         Processors: 4
       Total Memory: 16423165952 bytes
          Timestamp: Fri May 22 13:44:19 2020
    
    Ubuntu 16.04.6 LTS
    Capturing core dump and information to /var/opt/mssql/log...
    No journal files were found.
    No journal files were found.
    Fri May 22 13:44:19 UTC 2020 Capturing program information
    Fri May 22 13:44:19 UTC 2020 Attempting to capture a dump with paldumper for pid 8
    Captured a dump with paldumper
    Fri May 22 13:44:20 UTC 2020 Capturing program binaries
    Fri May 22 13:44:20 UTC 2020 Compressing the dump files
    Core dump and information are being compressed in the background. When
    complete, they can be found in the following location:
      /var/opt/mssql/log/core.sqlservr.05_22_2020_13_44_19.8.tbz2
    Jonathan Eckman
    @jonathaneckman

    I deployed the mcr.microsoft.com/mssql/server image and am seeing the following error when attempting to connect from SSMS or Azure Data Studio on the host. I've run out of ideas to troubleshoot. Any tips?

    A connection was successfully established with the server, but then an error occurred during the pre-login handshake.

    John Zabroski
    @jzabroski
    Eckman, you need to get your windows event log
    kirkfitzy
    @kirkfitzy
    Require some support on this issue asap microsoft/mssql-docker#628, dependency issue in the mssql-docker image
    Robert Da
    @Rahul7777_gitlab
    Hi everyone . Need help to deploy sql scripts to cicd pipeline... can anyone help?!
    Jonathan Kimrey
    @jkimrey
    Any suggestions on how to install SSIS in container?
    Carlos Robles
    @dbamaster

    Hi everyone . Need help to deploy sql scripts to cicd pipeline... can anyone help?!

    Hey Robert, you might want to take a look at Flyway. I have been using this tool in all my CI/CD pipelines for a long time, so far, so good.

    I deployed the mcr.microsoft.com/mssql/server image and am seeing the following error when attempting to connect from SSMS or Azure Data Studio on the host. I've run out of ideas to troubleshoot. Any tips?

    A connection was successfully established with the server, but then an error occurred during the pre-login handshake.

    Have you checked the container logs? You can always use docker log -f <container name> to figure out what's going on.

    shubhamgoel-tomhorn
    @shubhamgoel-tomhorn
    Joined for the first time. Just wanted to know Microsoft plans about SQL Server in Windows Containers. It seems the work on SQL Server Windows Containers has stopped on Developer Edition 2017. Are there any plans to revive it like the Linux ones?
    dariocasalis
    @dariocasalis
    Hi all! I have a question for you. I'm looking for a good system for Continous Integration and Continous Deployment on Sql Server. Do you have any adivces?
    Carlos Robles
    @dbamaster
    @dariocasalis it depends on your organization. I have worked with GitLab, Jenkins, Azure DevOps, and all work just fine with SQL Server containers. If you are looking for a more specialized tool in the Windows world I recommend you take a look at Redgate. They have really good tools that work just fine in a Windows ecosystem.
    Khaja Moinuddin Mohammed
    @moinuddin14

    Need Help Please - Able to spin up sqlserver inside Kubernetes cluster and expose as Loadbalancer. But when trying to connect to this sql server from a Springboot Java Microservice running in a different pod, getting the following error

    com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "testdb" requested by the login. The login failed. ClientConnectionId:cc72d7e2-0652-4f03-8383-4cbc9403f450
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262) ~[mssql-jdbc-7.2.2.jre8.jar!/:na]
    at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:258) ~[mssql-jdbc-7.2.2.jre8.jar!/:na]
    at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:104) ~[mssql-jdbc-7.2.2.jre8.jar!/:na]
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:5036) ~[mssql-jdbc-7.2.2.jre8.ja

    1 reply
    Appreciate any help regarding this.
    erwabo
    @erwabo
    Hello...we are going to be putting SQL Server in AKS, however we have gold data bases that need to be imported (preferably at container build time) and once they are up and running, they have to be in persistent storage. Would this be best as a pure K8s deployment, or build an image with a docker file first and pull that in from a registry? It looks like there are a couple ways to do it.
    1 reply
    erwabo
    @erwabo
    and with a persistent volume...Azure storage probably doesn't have the performance, is a volume mount internal to the K8s environment a better way to go?
    1 reply
    Carlos Robles
    @dbamaster
    Hey, @erwabo I've replied to both of your questions ;) Let me know if you need anything else.
    Amiya Kumar Das
    @amiyadas77
    Hi,
    Hi,
    I have created SQL container using below command
    docker run --name SQLServer -d -p 1436:1433 --volume c:\Docker\Volumes\SQLServer:c:\SQLData -e sa_password=xxxx -e ACCEPT_EULA=Y microsoft/mssql-server-windows-developer
    I have created a database with mdf and ldf file in c:\sqldata but I don't see those files in the folder
    Amiya Kumar Das
    @amiyadas77
    found it its in c:\Docker\Volumes
    JLofgren
    @JLofgren
    Hi, all,
    I am running SQL server in a docker container for development testing. Is there a way to have the container log all the queries it receives?
    Carlos Robles
    @dbamaster
    Hey @JLofgren you may want to take a look at query store here: https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver15
    You can also use community-driven solutions like sp_Who and sp_BlitzCache, to capture all query activity into tables. More information also here:
    https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit
    http://whoisactive.com/docs/25_capturing/
    Let me know if you need anything else.
    JLofgren
    @JLofgren
    Thank you, that's good stuff, but doesn't really hit the spot. I'm just trying to audit all the SQL commands that are sent from an application to SQL server under a particular use case. The only way I've found to do this is with a packet capture in wireshark, and that's really awkward. If there's a way to see the specific order of commands from a particular client using query store, then I don't understand how.
    Jason-De
    @Jason-De
    How do you deal with large datasets as part of CI/CD. My data is over 200GB and is updated monthly. Seems like a chore to build a database, deploy the data, make a BACPAC, deploy it to a reference db in the environment and then compare other DBs in the environments to it so I can deploy data changes. There has got to be an easier way
    John Edward
    @JohnEdw53902967_twitter
    could not open this page
    We are sorry, the page is forbidden.
    You do not have permission with this credential, please sign out to try with others and go back again.
    Any idea?
    Carlos Robles
    @dbamaster

    Thank you, that's good stuff, but doesn't really hit the spot. I'm just trying to audit all the SQL commands that are sent from an application to SQL server under a particular use case. The only way I've found to do this is with a packet capture in wireshark, and that's really awkward. If there's a way to see the specific order of commands from a particular client using query store, then I don't understand how.

    I see, what you want to use then is XE (Extended events). You can save a XE session and choose the path where you want to save the "trace" file. This XE can be filtered by user, database, program, etc. basically is a lightweight trace that will remain active as you want. Of course, another option is to use SQL Audit :)

    Ajeet1206
    @Ajeet1206
    I am looking for implementing CI/CD pipeline for my Data Platform (SQL server, SSIS, SSAS and Power BI), Any idea how should I start?
    XimingFeng
    @XimingFeng

    What's up guys! Hope all is well!

    We are trying to set up a TFS environment for our IT department.

    I deployed an on-prem Azure DevOps Server (tfsserver.mycompany.com).

    Created a test project and add our IT group to the project. It is a security group in our AD. Assign full permission to the IT group

    Created a test repository under the test project

    Installed VS2019 to my local computer

    In Team Explorer -> manage connections -> add Azure DevOps Server-> Add tfsserver.mycompany.com

    Once I added the server, it says no repository available. I assume that is because I did not sign in from VS. But it only allows me to sign in to an MS account, which we don't have. If the assumption is correct, Is there any way that I can use my windows login profile (user@mycompany.com) for authentication instead of the MS account?

    euphilein
    @euphilein
    when will be sql server 2019 image available for docker on windows?
    2 replies
    Buğra
    @BgR8
    Hi,
    I'm getting mssql registry error.
    computer then restarts
    how can I fix it
    smarteez17
    @smarteez17
    Hi There in Azure devops I running my test , my test connects to a SQL server data base but now I am getting this error in Devops 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)
    陈振阳
    @chenzhenyang
    How to get mssql-docker all env items?