Noel Pulis

Tag: microsoft

  • Disable MFA requirement in Microsoft 365 for specific users

    Disable MFA requirement in Microsoft 365 for specific users

    We would require a specific user or a migration process to have MFA disabled. Although it’s not suggested due to security reasons, we might be forced to have it disabled.

    If you disable the Multifactor authentication from the Multi-factor authentication in the Active Users, it will not matter as the system will still be enabled.

    Before proceeding, a group should be created for example MFA Excluded and put the users needed in the group.

    For this and the new portal changes Microsoft have done, you need to get into the Entra ID admin portal.

    https://entra.microsoft.com

    Click on Protection from the side pane and click on Authentication Methods.

    Click on Policies and click on Microsoft Authenticator.

    Click on the Exclude tab and add the group that was created earlier.

    This should allow you to use an account without MFA.

  • Pre-Provision a user’s OneDrive in Microsoft 365 using PowerShell

    Pre-Provision a user’s OneDrive in Microsoft 365 using PowerShell

    When a new account is created in Microsoft 365, its OneDrive is not provisioned, which the user must do. If you needed to pre-provision it for the user, you would need to log in with every user or use the below method to pre-provision it using PowerShell. Usually, this is done to pre-fill the OneDrive of a user with startup data and folder structure as well as it is needed to be provisioned for a migration process.

    A requirement for this is to have the SharePoint Online Management Shell installed, which can be downloaded from the Microsoft site https://www.microsoft.com/en-US/download/details.aspx?id=35588&msockid=3765afd8b0d06ff03ce2baf8b1a76eb2.

    Once downloaded and installed, open a PowerShell window.

    Type the following command

    Connect-SPOService -Url <your admin sharepoint URL>

    The admin SharePoint URL is usually the domain -admin.sharepoint.com for example https://mydomain-admin.sharepoint.com

    Then you will need the following command to pre-provision the Onedrive.

    Request-SPOPersonalSite -UserEmails <email address of user>

    This will provision the OneDrive or the user.

  • How to connect to a MariaDB via the SQL Management Studio SSMS

    How to connect to a MariaDB via the SQL Management Studio SSMS

    From the SQL Management Studio (SSMS) there is a way to connect/create a linked server to a MariaDB. For this you would need the following.

    – Install the ODBC Connector for MariaDB
    – Create an ODBC Connection (System DSN)
    – Add Linked Server.

    Installing the ODBC libraries for MariaDB

    Browse to https://mariadb.com/downloads/connectors/connectors-data-access/odbc-connector/
    Download the required ODBC installer for Windows.

    Install the downloaded “mariadb-connector-odbc-3.2.3-win64.msi” file

    Creation of the ODBC connection

    Open the ODBC Data Source Administrator (64-bit)
    Click on System DSN
    Click on Add
    Select MariaDB ODBC 3.2 Driver
    Give the connection a name
    Enter the server details and click on Test DSN to confirm the connectivity.

    Setting up the connection via the SSMS

    Open the SQL Management Studio
    Connect to the SQL instance
    Click on Server Objects and right-click on Linked Servers
    Click on New Linked Server

    Enter a name in the linked server section
    Change the Provider to Microsoft OLE DB Provider for ODBC Drivers
    Enter the ODBC Connection name you created in the Data Source section
    Click on Security
    Click on Be made using this security context and enter the credentials of the MariaDB server

    Click OK

    This will create the connection and you can browse the data.

  • SQL: Attach a database using a different database name

    SQL: Attach a database using a different database name

    When attaching a database in SQL Server using the interface, it doesn’t let you change the name of the destination database. This can be done using the SQL Commands below.

    USE [master]
    GO
    CREATE DATABASE [myNewSite_db] ON
    ( FILENAME = N'D:\Data\myNewSite_db.mdf' ),
    ( FILENAME = N'E:\Logs\myNewSite_db_log.ldf' )
    FOR ATTACH
    GO