SQL Server: Setup, Installation steps and Software list

SQL Server – Software list: Installation steps

  1. Download SQL server 2014 standard trial version
  2. Download and install the Visual Studio 2013 Professional
  3. Download Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2013
  4. Microsoft Access Database Engine 2010 Redistributable
  5. Keep the copy of the Training Sample Database TSQL2012
  6. Download AdventureWorks2014 sample database Full: Adventure Works for SQL Server 2012,

    1. Attach or restore the AdventureWorks2014 database
  7. Install the SQL Server Online Book using the Help Library Manager – Product Documentation for Microsoft SQL Server 2014 for firewall and proxy restricted environments
  8. Download and install the 32 bit Microsoft OLEDB driver as 32 bit SSIS does not work with 64-bit operating system
  9. Download Microsoft Access Database Engine – Need this if you have Visual Studio Express Edition. This download will install a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access 2010 (*.mdb and *.accdb) files and Microsoft Office Excel 2010 (*.xls, *.xlsx, and *.xlsb) files to other data sources such as Microsoft SQL Server. Connectivity to existing text files is also supported. ODBC and OLEDB drivers are installed for application developers to use in developing their applications with connectivity to Office file formats.
  10. SQL Server 2014 Data quality server installer
  11. SQL Server 2014 Data quality client installer
  12. SQL Server Master Data Services
  13. Install BIDS Helper from http://bidshelper.codeplex.com/
  14. Open XML Package Editor for Visual Studio
  15. 7Zip
  16. DiffMerge
  17. KDiff3
  18. Notepad++
  19. Netbeans
  20. TortoiseSVN
  21. Treesize
  22. Speccy
  23. Netbeans
  24. PrimoPDF
  25. DualMonitor
  26. Royal TS 1.5 or Windows Remote Desktop Connection Manager
  27. SublimeText like Notepad++ and also compare code
  28. KeePass Password Safe
  29. File unlocker – kill the process that locks the file and stop from deleting or copying
  30. Nero 7
  31. Typing Tutor TT6
  32. Microsoft Visual Studio Team Foundation Server 2015 Power Tools
  33. Optillect SQL Decryptor
  34. download Microsoft SQL server 2014 feature pack – Analysis Services components. ADOMD.NET, the OLE DB provider
  35. Microsoft® Analysis Server® Feature Pack



How to uninstall SSDT – SQL Server Data Tools -Business Intelligence Tools for Visual Studio 2013

  1. Microsoft Visual Studio 2013 Shell(Isolated)
  2. Microsoft Visual Studio 2013 Shell(Integrated)
  3. Microsoft SQL Server 2012 Data-Tier Application Framework
  4. Microsoft SQL Server Data Tools – enu (11.1.30618.1)
  5. Prerequisites for SSDT
  6. Microsoft SQL Server Data Tools Build Utilities – enu (11.1.30618.1)










Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s