Microsoft Support & Discussions

こんにちは。日本マイクロソフト SQL Server サポートチームです。 今回は可用性グループリスナーへの接続方法についてご案内します。 可用性グループリスナーに接続する際、アプリケーションや接続文字列でのサーバー名について、サポートされる指定方法とサポートされない指定方法は次の通りです。 サポートされるサーバー名の指定 可用性グループリスナーが既定の 1433 ポートの場合: listenername listenername,port 可用性グループリスナーが既定以外のポートの場合: listenername listenername,port listenername\instancename,port ※ listenername\instancename,port と指定した場合は、instancename の部分は無視され、listenername,port と同じものとして接続されます。 サポートされないサーバー名の指定 listenername\instancename ※ 可用性グループを構成する各レプリカが名前付きインスタンスであり、SQL Server Brower サービスが動作している場合には、名前付きインスタンスのポートが解決できるため、この指定でも接続できる場合があります。しかしながら、正式にサポートされた指定方法ではないため、ネットワークなどの通信が要因で接続ができない可能性があります。 参…

Microsoft is pleased to announce the release of the security baseline for Microsoft Edge, version 112! We have reviewed the settings in Microsoft Edge version 112 and updated our guidance with the removal of three obsolete settings. A new Microsoft Edge security baseline package was just released to the Download Center. You can download the new package from the Security Compliance Toolkit. Allow using the deprecated U2F Security Key API (Removed) This setting became obsolete in version 104 and is now being removed from the security baseline. Enable 3DES cipher suites in TLS (Removed) This setting became obsolete in version 97 and is now being r…

Register for the first-ever Microsoft Viva Summit As organizations face evolving challenges around flexible work, economic uncertainty, and the future role of AI, today’s leaders must build resilience in their workforces to increase productivity and performance. Join Jared Spataro, Kathleen Hogan, Kirk Koenigsbauer, Stacia Garr (RedThread Research), Diane Schwarz (Johnson Controls), and other Microsoft and industry leaders at this digital event, where they’ll face these issues head on with research findings, expert insights, panel discussions, and a technology showcase on Microsoft Viva and Glint. Gain inspiration from your peers and get energized to empow…

To schedule a cronjob on azure app service Linux web application you can follow the steps outlined below, Navigate to “SSH” from azure app services portal and click on Go -> Create a script file in /home with name as start.sh and add the below lines to the script file and save the file. Command to create a script file - touch /home/start.sh Open the file using vim editor: vi /home/start.sh and copy the below code # Installing cron apt-get update -qq && apt-get install cron -yqq # Starting cron service cron start #cron scheduler (crontab -l 2>/dev/null; echo "* * * * * find /home/BackupLogs -type…

Service Meshes have a great value when running distributed applications at scale on K8s. Many meshes are available nowadays. The usual suspects are Istio and Linkerd but other meshes have come to the surface, such as Open Service Mesh (OSM) from Microsoft. OSM is available as an AKS addon. The promises of a service mesh are: Increased agility thanks to the built-in support of various deployment/testing models Increased resilience thanks to built-in retry, circuit breakers and fault injections (chaos engineering) Increased observability Increased security, thanks to mTLS and traffic policies Enhanced load balancing algorithms that understand the application lay…

Hi everyone! Brandon Wilson here once again with this month’s “Check This Out!” (CTO!) guide. These posts are only intended to be your guide, to lead you to some content of interest, and are just a way we are trying to help our readers a bit more, whether that is learning, troubleshooting, or just finding new content sources! We will give you a bit of a taste of the blog content itself, provide you a way to get to the source content directly, and help to introduce you to some other blogs you may not be aware of that you might find helpful. From all of us on the Core Infrastructure and Security Tech Community blog team, thanks for your continued reading and support! …

Looking Back: Week 1 Recap[/url] Week one is done, and thank you for joining us on this journey. We hope you've enjoyed the first week of #30DaysOfAzureAI and have learned a lot about Azure AI. We've covered a lot of ground, so let's recap what we've learned so far. Here are the highlights for week 1. Week 1: Fundamentals AZURE AI EVERYONE April 03 – Unleash the power of Azure OpenAI April 04 – Explore the Azure OpenAI Playground April 05 – Build an AI receipts app with GitHub Copilot April 06 – Learn key Azure ML Concepts April 07 – The Mission of Responsible AI April 08 – Improve accessibility with Azure AI Azure AI Skills C…

Hello, this is Matthew Palko, senior product management lead in Enterprise & Security, and today I have some information to share about the new changes to strong certificate mapping in Active Directory. Preview of SAN URI for Certificate Strong Mapping for KB5014754 KB5014754, released in May 2022, introduced changes to Active Directory Kerberos Key Distribution (KDC) behavior on Windows Server 2008 and later when validating certificates during certificate-based authentication. These changes were made to address elevation of privilege related vulnerabilities leveraging certificate spoofing. The KDC changes require certificates for a user or computer obj…

Introduction: =================================================================================== This blog introduces the detailed procedures to Integrate logic apps with SQL server by API connection using credentials kept in key vault. Solution =================================================================================== STEP1: As we chose to use “SQL server Authentication”, please save the SQL server’s password in KeyVault: STEP2: I fetched the ARM template for SQL-API connection from network trace during API connection creating process: (Note: Please change the highlighted part as your environment) templatea.json …

Register for the first-ever Microsoft Viva Summit As organizations face evolving challenges around flexible work, economic uncertainty, and the future role of AI, today’s leaders must build resilience in their workforces to increase productivity and performance. Join Jared Spataro, Kathleen Hogan, Kirk Koenigsbauer, Stacia Garr (RedThread Research), Diane Schwarz (Johnson Controls), and other Microsoft and industry leaders at this digital event, where they’ll face these issues head on with research findings, expert insights, panel discussions, and a technology showcase on Microsoft Viva and Glint. Gain inspiration from your peers and get energized to empow…

Windows Autopatch is a new enterprise service that simplifies and automates Windows and M365 update management, helping you spend less time managing quality updates for your organization and more time driving value. Here’s how you can catch up on what it is, how it works, and how you can start using it today – all in just two hours! Got 10, 30, or 60 minutes to start? Jump right to the resource with the desirable time stamp and come back for another snack later to keep learning. Time to learn: 119 minutes [attachment=36947:name]READ What is Windows Autopatch? Visit official documentation for Windows Autopatch. To begin, learn how this cloud …

The Software as a Service (SaaS) landscape has evolved dramatically. The proliferation of cloud-based applications has brought significant benefits in terms of scalability, accessibility, and cost-effectiveness. However, it has also led to an increased need for organizations to secure these applications and protect their data. We understand it can be challenging to know where to begin and ensure you have protection across your entire digital estate. Microsoft Defender for Cloud Apps makes it simple to secure organization’s SaaS applications. It can be deployed quickly and easily, with no other dependencies or installations required. We’ll walk through 4 steps that …

Our newest round of Access bug fixes was released on March 28, 2023. In this blog post, we highlight some of the fixed issues that our Access engineers released in the current monthly channel. If you see a bug that impacts you, and if you are on the current monthly channel build 2303, you should have these fixes. Make sure you are on Access Build # 16.0.16227.20212 or greater. Bug Name Issue Fixed When inserting records into a linked SQL Server table with an INSERT trigger, the insert fails We fixed an issue where users get an ERROR: 3155, ODBC--insert on a linked table [table name] message when inserting a new row into a linke…

Since Viva Sales launched last year, customers worldwide have been piloting and adopting its capabilities. Today, we are sharing a list of the top Viva Sales questions on the product architecture we hear from our customers, responses, and a detailed overview of the product architecture to help you get started. Viva Sales Product Architecture 1. How does Viva Sales work? consists of a set of end-user experiences available via a Microsoft Outlook Add-In and Microsoft Teams App, which connects in real-time to your organization’s CRM data and end-user’s M365 / Office data to bring insights and productivity capabilities directly into the seller’s …

Windows Autopatch is a new enterprise service that simplifies and automates Windows and M365 update management, helping you spend less time managing quality updates for your organization and more time driving value. Here’s how you can catch up on what it is, how it works, and how you can start using it today – all in just two hours! Got 10, 30, or 60 minutes to start? Jump right to the resource with the desirable time stamp and come back for another snack later to keep learning. Time to learn: 119 minutes [attachment=36929:name]READ What is Windows Autopatch? Visit official documentation for Windows Autopatch. To begin, learn how this cloud …

Connect with the Microsoft team on April 25-27 for the AIIM Conference 2023 (AIIM23) in New Orleans at the Hyatt Regency to learn more about business drivers and current trends impacting information management. As an Elite Diamond Sponsor of this year’s conference, we’re excited to connect with the AIIM community of information management professionals! AIIM23 is three days of collaborative learning designed to help you master your organization’s content to operate more effectively, reduce costs, and manage risk. You’ll learn about transforming how business content is captured/created, processed/shared, and discovered/protected – so you can empower your people, e…

Who said creating a website has to be hard? Writing the code, persisting news, hosting the website. A decade ago this might have been a lot of work. These days, thanks to Microsoft Blazor, Microsoft Azure App Service, and MongoDB Atlas you can get started in minutes. And finish it equally fast! In this tutorial I will walk you through: setting up a new Blazor project, creating a new page with a simple UI, creating data in MongoDB Atlas, showing those news on the website and making the website available by using Azure App Service to host it. All you need is this tutorial and the following pre-requisites, but if you prefer to just read along for …

We continue to expand the Azure Marketplace ecosystem. For this volume, 123 new offers successfully met the onboarding criteria and went live. See details of the new offers below: Get it now in our marketplace [attachment=36823:name] Digital Sustainability Platform by Tredence: Tredence's Digital Sustainability Platform will reduce the manual effort required to prepare environmental, social, and governance (ESG) reports. Meet and exceed regulations governing food waste and carbon dioxide emissions. [attachment=36824:name] FTP Server Advanced on Ubuntu 18.04 LTS: This offer from Tidal Media provides a secured FTP server and Ubuntu 18.04 LTS on a Micr…

In this episode with Logan Carrington and Aditya Badramraju, you will learn why enabling the automatic registration feature in the Azure portal is necessary to register all current and future SQL Server on Azure Virtual Machines (VM’s) with the SQL IaaS Agent extension to unlock a new recently released full feature set of benefits. Resources: Automatic registration with SQL IaaS Agent extension - SQL Server on Azure VMs Register with SQL IaaS Extension (Windows) - SQL Server on Azure VMs Announcing new features for the SQL IaaS Agent Extension! More episodes in the Azure SQL Virtual Machine Reimagined Series: View/share our latest …

In this episode with Logan Carrington and Aditya Badramraju, you will learn why enabling the automatic registration feature in the Azure portal is necessary to register all current and future SQL Server on Azure Virtual Machines (VM’s) with the SQL IaaS Agent extension to unlock a new recently released full feature set of benefits. Resources: Automatic registration with SQL IaaS Agent extension - SQL Server on Azure VMs Register with SQL IaaS Extension (Windows) - SQL Server on Azure VMs Announcing new features for the SQL IaaS Agent Extension! More episodes in the Azure SQL Virtual Machine Reimagined Series: Continue reading...

Microsoft Learn enables you and your team to gain new skills at your own pace. You begin learning at your skill level and can progress quickly as you practice with Microsoft products. At Microsoft Learn, we regularly review and update our portfolio to help ensure that our training and certification offerings reflect the needs of today’s workplace and include any changes in our technology. In this evolving global economy, current skills are critical for your career and your organization’s success. As we review our Microsoft Dynamics 365 training and certification portfolio, we’re mindful of how IT professionals can use their skills with Dynamics 365 to support a new…

Bring OpenAI’s ChatGPT model in Azure to your own enterprise-grade app experiences with precise control over the knowledge base, for in-context and relevant responses. Interact with your organization’s private internal data, while respecting the information protection controls put in place. Azure OpenAI service is combined with Azure Cognitive Search to index and retrieve data that is private and external to the ChatGPT large language model. The retrieval step in Azure Cognitive Search finds the most relevant pieces of information and presents the top ranked results to the language model. And because the knowledge lives outside of the ChatGPT model, you’re …

An example use case: I have an Azure Blob Container named "my-org-documents"; a specific folder should be shared across all the identities. However, each identity can only write into their subfolders. I will use the below identities as example: test@my-org.com (AD user) ExampleMI12 (managed identity) I have created a path called test, managedidentity and sharedfolder under the container, so the structure is as below: my-org-documents/test my-org-documents/managedidentity my-org-documents/sharedfolder My task is completed when: - Active Directory user "test" is able to read/write into sharedfolder - Active …

In case you missed it, we’ve had some excellent new briefings from world class experts and MVPs on Empowering.Cloud this month. All free to access for the community. Cross -Tenant Teams Voice Migration Learn from MVP Thomas Poett’s real-world experience of migrating phone numbers between Office 365 tenants in a tenant to tenant migration, including: Teams Phone tenant to tenant with calling plans, direct routing and operator connect  How you can setup direct routing dual forking to dynamically deal with tenant to tenant migration  SIP ladder diagram of how forking calls between two tenants works  Tips for a trouble free Teams Phone tenant t…

Today, we are excited to announce Windows 365 Frontline is in public preview. You now have the ability to provision Cloud PCs for shift and part-time workers or others who only need a Cloud PC for a limited amount of time during their work day. I'm going to share a few use case scenarios, then offer details on how you can provision and manage Windows 365 Frontline Cloud PCs. How Windows 365 Frontline helps simplify provisioning for IT Windows 365 Frontline makes it easier and more affordable to extend the power of Cloud PCs to frontline and shift work employees so they can experience the benefits of Windows in the cloud. A single Windows 365 Frontline license supp…