Conquering Connections: SSMS to Docker SQL Server for XM Cloud

Let’s first discuss how these benefits in developing a website in XM Cloud,

Connecting SQL Server Management Studio (SSMS) to a SQL Server instance running in a Docker

container can be useful for several reasons

• Development and Testing
• Debugging and Troubleshooting
• Portability
• Resource Efficiency

Connecting SSMS to a SQL Server instance running in a Docker container provides developers, administrators, and organizations with greater flexibility, scalability, and efficiency in managing SQL Server databases within a containerized environment.

Now let’s see how we can connect our SQL docker container with SSMS and access database, or we can modify the same.

(Docker containers for XmCloud Local Instance)

Here is the view of containers that are available when we start the local XM-Cloud instance,

Let’s jump into the mssql -1 container,

We need IP address to identify the server.

(IP Address of SQL Container)

If we see the inspect section, we can see the IP Address field there, XM-Cloud’s .env file consist the user’s name and password of the SQL server which we can use to login through SQL server.

We can configure the above cred in the SSMS application

(Server Connection through IP Address and Cred.)

Now when we connect to the application, we can able to see the core, master and web DB in the SQL as shown below, here web DB will be not used as we are dealing with the cloud interface in XM-Cloud product.

(SQL DB view of XmCloud)

This is the view of SQL DB of docker’s MSSQL container. You can now execute the query’s here or you can create new custom DB and that can be utilized in the XM Cloud functionality.

Conclusion

In this guide, we’ve simplified the process of connecting SQL Server Management Studio to a Dockerized SQL Server instance tailored for XM Cloud. By leveraging Docker containers, you gain flexibility, scalability, and ease of management for your database infrastructure. Explore further to harness the full potential of Docker and SQL Server in your cloud environment.

Mitesh Patel - Technical Head - ADDACT

Sitecore || XMCloud || OrderCloud Certified

Mitesh, a distinguished Technical Head at Addact/Addxp, is a prominent figure in Sitecore/XMCloud/OrderCloud certified writing. From Sitecore XM Cloud Developer Certification to Sitecore 10 .NET Developer Certification and Sitecore OrderCloud Certification, Mitesh's expertise is unparalleled. Mitesh is not only a skilled Sitecore CMS developer but also a 12+ years experienced software engineer proficient in various technologies such as MVC, ASP.Net, C#, jQuery, and Azure cloud/AWS.