SQL Server 2016 Certification Path

Level 1. “MCSA: SQL Server 2016”: Now to earn this level you need to give either of the following certifications:

  1. MCSA: SQL 2016 Database Development certification
    – Exam [70-761], Querying Data with Transact-SQL [check details here]
    – Exam [70-762], Developing SQL Databases

  2. MCSA: SQL 2016 Database Administration certification
    – Exam [70-764], Administering a SQL Database Infrastructure
    – Exam [70-765], Provisioning SQL Databases

  3. MCSA: SQL 2016 Business Intelligence Development certification
    – Exam [70-767], Implementing an SQL Data Warehouse
    – Exam [70-768], Developing SQL Data Models

Level 2. “MCSE: Data Management and Analytics”: Now to earn this level you need to first get an MCSA on either of the above 3 certifications, or “MCSA: Data Science”. Then need to pass anyone of the below exam:

– Exam [70-473], Designing and Implementing Cloud Data Platform Solutions
– Exam [70-475], Designing and Implementing Big Data Analytics Solutions
– Exam [70-464], Developing Microsoft SQL Server Databases
– Exam [70-465], Designing Database Solutions for Microsoft SQL Server
– Exam [70-466], Implementing Data Models and Reports with Microsoft SQL Server
– Exam [70-467], Designing Business Intelligence Solutions with Microsoft SQL Serversql-server-2016-certification-path

SSAS Cube Deploy issue

SQL Server 2012: Login failed for user ‘NT Service\MSSQLServerOLAPService’.; 28000

  • 1-Run “SQL Server Configuration Manager”
  • 2-Select “SQL Server Services”
  • 3-Right Click “SQL Server Analysis Services” and choose properties
  • 4-On the “log on ” tab ,choose “this account”.
  • 5-Click “Browse” button , then Click “Advanced” button.
  • 6-Click “find now” button . Now find your account in the below table and select it.
  • 7-When you selected proper account (With sufficient permission) , return to “log on” tab
  • and enter your password
  • 8-Restart service and try again your task…

Not yet verified


换了一种方法后 本地是可以Deploy了


I found the answer here on the MS SQL Server Forum for Analysis Services:

Solution for: OLE DB or ODBC error:Login failed for user NT Service\MSSQLServerOLAPService error – create new login in the SQL Server database engine so analysis services can read the data in the database being analyzed.

Create login and grant access:

Open up SQL Server Management Studio [login to the database engine]>
Security >
Login (Right click) >
New Login >add user: “NT Service\MSSQLServerOLAPService”>
select the database being analyzed in the drop-down list at the bottom >
User Mapping [click on the database in the list] >
In the window database role membership click on db_datareader [this grants access to read the data]

More details here http://msdn.microsoft.com/en-us/library/ms189751.aspx

Hope this helps!

Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com


Thank you everyone who helped me – thank you very much!

来源 Cube