{"id":1234,"date":"2016-06-08T01:38:28","date_gmt":"2016-06-08T01:38:28","guid":{"rendered":"http:\/\/www.theSQLReport.com\/?p=1234"},"modified":"2016-06-08T01:57:33","modified_gmt":"2016-06-08T01:57:33","slug":"install-sql-server-management-studio-ssms-2016-without-internet-access","status":"publish","type":"post","link":"http:\/\/www.theSQLReport.com\/?p=1234","title":{"rendered":"Install SQL Server Management Studio (SSMS) 2016 Without Internet Access"},"content":{"rendered":"

One of my frustrations with SQL Server 2016, is that the SQL Server Management Studio (SSMS) is no longer included with the database instance installation.\u00a0 It is now has its own separate installation.<\/p>\n

Problem:<\/strong><\/h2>\n

The problem is when I click on the “Install SQL Server Management Tools” in the SQL Server Installation Center, an web browser pops up wanting to perform a web based installation.\u00a0 Our SQL Server database servers can not connect to the internet, so the error “This page can’t be displayed” is displayed in the web browser.<\/p>\n

\"Problem<\/a><\/p>\n

Resolution:<\/strong><\/h2>\n

To resolve this, I had to download the SQL Server Management Studio (SSMS) installation executable from the MSDN on my workstation.<\/p>\n

Click on the link below to take you to the MSDN download page, and click the link “Download SQL Server Management Studio June 2016 generally available release<\/strong><\/a>” to download the installation executable file:<\/p>\n

Download SQL Server Management Studio (SSMS)<\/a><\/p>\n

\"SSMS<\/a><\/p>\n

A pop-up may appear depending on the type of web browser that being using.\u00a0 Click the Save File button to save the file: SSMS-Setup-ENU.exe<\/strong>.<\/p>\n

\"Download<\/a><\/p>\n

I moved the executable file (SSMS-Setup-ENU.exe<\/strong>) to the server that I wanted to install SSMS on.\u00a0 Then I right click on the executable file to run the installation as “Run as administrator”.<\/p>\n

\"RunAsAdministrator\"<\/a><\/p>\n

A pop-up may appear about User Account Control, I clicked the Yes button.<\/p>\n

\"PopUpAllow\"<\/a><\/p>\n

Then the Microsoft\u00a0SQL Server Management Studio installation splash screen appeared.\u00a0 I just clicked on the Install button.<\/p>\n

\"SMSS<\/a><\/p>\n

The installation will started, which took a couple of minutes because I was on a small server.<\/p>\n

\"SSMSinfo01\"<\/a><\/p>\n

During the install the progress bars screen changed.<\/p>\n

\"SSMSinfo02\"<\/a><\/p>\n

Finally, when it completed, I clicked on the close button.<\/p>\n

\"SSMS<\/a><\/p>\n

Note: I was never given the option to choose the location to install the files on the server.<\/strong><\/p>\n

With out rebooting, I was able to open SQL Server Management Studio (SSMS), and connect to the local database instance.<\/p>\n

\"SQL<\/a><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

One of my frustrations with SQL Server 2016, is that the SQL Server Management Studio (SSMS) is no longer included with the database instance installation.\u00a0 It is now has its … Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":1238,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[82,81],"class_list":["post-1234","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server","tag-sql-server-2016","tag-ssms"],"_links":{"self":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1234"}],"collection":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1234"}],"version-history":[{"count":17,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1234\/revisions"}],"predecessor-version":[{"id":1261,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1234\/revisions\/1261"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/media\/1238"}],"wp:attachment":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1234"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}