Outlook ProPlus cannot access to Office 365 email after migrating from Exchange 2007

This post shows you one of the possibilities to resolve the Outlook ProPlus issue. Outlook ProPlus cannot access to Office 365 email after migrating from Exchange 2007, this has been happening to many people. One of the ways to resolve this is. Open Control Panel.

Click on User Accounts.

Click Mail (Microsoft Outlook 2016) or something similar but not exactly the same.

Click on Email Accounts…

Remove the email account, reenter the similar one and reenter the password. After the close all the Windows and start your Outlook.

Microsoft Graph Client Secret for Postman

This post shows you where to get Client Secret from Microsoft Graph if you want to use Postman, https://github.com/microsoftgraph/microsoftgraph-postman-collections. The link never showed you how to get that. If you follow the link you will arrive on the following screen and get stuck.

You must already have Application / Client Id from at app.dev.microsoft.com.

Click on the App then the follow screen will pop up. Choose View this app in the Azure Portal.

Your browser will bring you to here.

Click on Certificate $ secrets. This is where you can get the Client Secret.

Microsoft Graph Learning

This post provides you the resources to learn Microsoft Graph

https://developer.microsoft.com/en-us/windows/campaigns/idt-resources

https://github.com/microsoftgraph/msgraph-sdk-dotnet

https://graph.microsoft.com/

https://github.com/chanmmn/ClassLibraryGraph

https://developer.microsoft.com/en-us/graph/graph-explorer

https://github.com/chanmmn/microsoftgraph

https://github.com/microsoftgraph/microsoftgraph-postman-collections

https://chanmingman.wordpress.com/2019/05/25/microsoft-graph-using-asp-net-getting-started/

https://chanmingman.wordpress.com/2019/05/20/microsoft-graph-using-uwp-getting-started/

Could not delete the subscription at Subscriber

This short post showing how to resolve the SQL Server replication error “Could not delete the subscription at Subscriber“. The working solution is a simple command below.

EXEC sp_removedbreplication ‘YourDatabaseName’

Links that does not work:

https://dba.stackexchange.com/questions/135745/how-to-fix-a-messed-up-replication-on-ms-sql-server

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b64bcde9-4769-45df-a8c7-19606c9c33ca/unable-to-drop-subscription?forum=sqlreplication

Links that work:

https://blog.sqlauthority.com/2018/08/18/sql-server-unable-to-remove-replication-publication-could-not-delete-the-subscription-at-subscriber-subserver-in-database-subdb/

Where to get Microsoft.Online.SharePoint.TenantAdministration

This short post shows you where to get Microsoft.Online.SharePoint.TenantAdministration. Go to Package Manager Console and type.

Install-Package Microsoft.SharePointOnline.CSOM -Version 16.1.8924.1200

Reference: https://www.nuget.org/packages/Microsoft.SharePointOnline.CSOM/16.1.8924.1200

Microsoft Graph building Class Library

This post shows you how to build a Class Library with Microsoft Graph SDK. The pre-requisites of the article are you need to have Visual Studio, you have to know C#, and you need to have an Office 365 account. Start Visual Studio, create a new project, select Class Library project. Go to Tools -> NuGet Package Manager -> Package Manager Console. Type

Install-Package Microsoft.Graph

Paste the following code to your library.

using Microsoft.Graph;

using Microsoft.Graph.Auth;

using Microsoft.Identity.Client;

using System.Collections.Generic;

using System.Threading.Tasks;

namespace ClassLibraryGraph

{

public class MSGraph

    {

        public static List<string> lstString = new List<string>();

        public static async Task<List<string>> CallRunAsync()

        {

            await Run();

            return lstString;

        }

        public static async Task Run()

        {

            var clientId = “7515c9fd-d9d2-4aa5-b960-d5b3c0032502”;

            var scopes = new List<string>() { “User.ReadBasic.All” }.ToArray();

            IPublicClientApplication clientApplication = InteractiveAuthenticationProvider.CreateClientApplication(clientId);

            InteractiveAuthenticationProvider authProvider = new InteractiveAuthenticationProvider(clientApplication, scopes);

            GraphServiceClient graphClient = new GraphServiceClient(authProvider);

            var users = await graphClient.Users

.        Request()

.        Select(e => new

        {

            e.DisplayName,

            e.GivenName,

            e.PostalCode,

            e.Manager

        })

        .GetAsync();

            foreach (var user in users)

            {

             lstString.Add(user.DisplayName);

            }

        }

    }

}

References:

https://graph.microsoft.com/

https://github.com/microsoftgraph/msgraph-sdk-dotnet

Download: https://github.com/chanmmn/ClassLibraryGraph

SSIS Build Simplest test project

This post showing you how to develop a simple test SSIS package. Pre-requisite, you need to have SSDT for Visual Studio 2015 or above. This sample only require text file. No other data source is required. You need to know the basic of C#.

To start, Create a SSIS project, https://chanmingman.wordpress.com/2019/06/04/ssis-for-visual-studio-2019/. Drag Data Flow Task into Control Flow.

Double click the data Flow Task,

Drag Script Component to Data Flow pane.

Select Source.

Go to Inputs and Outputs on the left pane. In Output Columns choose Add Column. Here I added NameOut and IdOut as Unicode string. Click OK.

Click Script. Click Edit Script…

Add the below code to CreateNewOutputRows() method.

public override void  CreateNewOutputRows()

{

    string[] strId = new
    string[2] { “1”, “2” };

    string[] strName = new
    string[2] { “Laptop”, “PC” };

    Output0Buffer.AddRow();

    Output0Buffer.IdOut = strId[0];

    Output0Buffer.NameOut = strName[0];

    Output0Buffer.AddRow();

    Output0Buffer.IdOut = strId[1];

   Output0Buffer.NameOut = strName[1];

}

Save and close the code window. Click OK.

Drag Flat File Destination Double click on Flat File Destination.

Click New. Select Delimited. Click OK.

Here I type in File name c:\temp\output.txt. Provided you have a c:\temp directory. Select Column names in the first data row.

Click Columns. To check on the column names. Click OK.

Click on Mapping to confirm the mapping. Click OK. You can run the package to test now.