Mirroring on SQL Server 2012 step by step – Failover Database Microsoft

Mirroring on database allows to get a copy of principal database to prevent any troubleshooting which can occurs on server. To do Mirroring, we need 2 instances of sql server on 2 differents server at minimum (one called Principal server, the other Mirror server). We will also add a third part, the witness sql server, used to monitor the 2 instances of sql server. With Witness, we work on a high safety mode and it supports automatic failover through Mirror server.

1_CreateSqlInstance

2_CreateANewSqlInstance

3_FirstInstance

4_NewDatabase

5_CreateDatabase

6_NewTable

7_ScriptToCreateData

8_InsertDataInTable

9_PerformBackupForMirroring

10_RestoredbMirror

10_RestoredbMirror

11_RestoringDBOnMirrorServer

12_BackupDataLog

13_RestoringDataLog

14_MirroringWizard

15_ConfigureMirroringSecurity

16_WitnessServer

17_ServerToConfigure

18_EndpointOfPrincipalServer

Master Data Service under Sql Server 2012 – Installation – Microsoft Master Data Managment for EIM

Master Data Service – MDS – is a very powerfull feature on SQL Server 2012 to manage data from different application in order to work data quality and business rules. It is part of EIM (Entreprise Information Management) or MDM (Master Data Management). MDS get all data coming from different sources (application, services…) and persist them on a central repository as model (container) and entities (record). MDS provide an Excel addon to the business analyst who can manage through permissions, data, correct them, clean them, and apply business rules. MDS work with a DQS (Data Quality Service). DQS is the service responsible of cleaning data, matching them to correct data pattern.

Installation of MDS needs windows features

1/On server manager select add feature and roles:

1_IISrole

2/select the roles needed:

2_IISOptions

3/Install IIS and features on progress:

3_IISInstallation

4/to install Master Data Service under sql server 2012, use Sql Server Installation Center

4_SqlServerInstallationCenter

5/ Browse your SQL Server 2012 setup:

5_BrowserSQLServer2012iso

6/follow the wizard and select the feature Master Data Service :

6_MasterDataServicefeature

7/Open the Master Data Service Configuration Manager Console, select Database configuration and click on Create Database button :

7_MDSConfigManagerConsole

8/ Set the Database Server Name (here sql2012 for me) which host the MDS Database

8_SelectDBServer

9/put a MDS database name (here I call it MDS_db) :

9_MDSDB

10/ Specify the windows account used to be the administrator account:

10_AdminAccount

11/here the summary of all the wizard steps to create the MDS database:

11_MDS_Summary

12/click next to finish the installation:

12_SuccessonDBInstall

13/Now, we have to create the Website of MDS, so select Web site configuration and select Create new website:

13_CreateNewWebSite

14/Specify the configuration you want (name of the website, port, account…):

14_ConfigWebSite

15/Installation is finished

15_SuccessWebSite

16/On IIS manager, you will see the MDS Website created:

16_IISServerMDSappears

17/Type the url (for me http://sql2012:8080), and you will open the MDS manager, congratulations 😉

20_MasterDataServicesworksfine

18/Troobleshooting when trying to access to MDS Website:

If you get a 404.17 http error when you try to access to MDS Website:

17_Error404.17

It is because you haven’t select 4.5 extensions and ASP.NET 4.5 under Add roles and features-> server role Web Server->Application Development:

21_ApplicationDevelopment4.5

19/ you get an error on connection string : Connection string name ‘defaultMdsConnection’ was not found…

18_errordefaultmdsconnectionactivate

Go on the web.config of the MDS website, and modify the connection string to bind the MDS database name on the wizard.

19_ConfiguretheConnectionString

20/if you get access denied on your MDS Website, be sure to deactivate the anonymous authentication  AND activate Windows authentication 😉