While installing an instance of SQL2008R2 to a Windows 7 Workstation VM (used by my programmers) on my VMWare vSphere cluster I ran into a problem.<\/p>\n
While the SQL installation seemed to go OK, it hung up toward the end during ‘Windows Installation Final Tasks – Clean up processes…” or something at “Install_sqlncli_Cpu64_Action”
\nThe install just hung forever – let it actually try to run over night and it never completed.<\/p>\n
The solution is simple, and kind of a ‘duh’.
\nSQL2008R2 needs 4GB RAM and minimum of 4 cores\/processors.
\nMy Production SQL VM’s easily met this criteria but not so with the workstations.
\nSo simply cancelled the installation. Shut down the VM. Edited the VM – upped RAM to 6GB and processors to 4.
\nRestart VM then let it boot and let Win7 reconfigure itself. It will require another reboot.
\nI then completely uninstalled the failed installation. Then rebooted.
\nAlso remember that this is REALLY IMPORTANT!! – Open the ports on the Windows Firewall for SQL2008<\/p>\n
This can be done by copying the following (everything in between the break lines including the last ‘return’ at the end) into a text file and renaming it with a .bat extension. something like ‘opensqlfirewallports.bat’ or what ever and running it with administrative permissions.
\n————————–
\n@echo =========\u00a0 SQL Server Ports\u00a0 ===================
\n@echo Enabling SQLServer default instance port 1433
\nnetsh firewall set portopening TCP 1433 “SQLServer”
\n@echo Enabling Dedicated Admin Connection port 1434
\nnetsh firewall set portopening TCP 1434 “SQL Admin Connection”
\n@echo Enabling conventional SQL Server Service Broker port 4022
\nnetsh firewall set portopening TCP 4022 “SQL Service Broker”
\n@echo Enabling Transact-SQL Debugger\/RPC port 135
\nnetsh firewall set portopening TCP 135 “SQL Debugger\/RPC”
\n@echo =========\u00a0 Analysis Services Ports\u00a0 ==============
\n@echo Enabling SSAS Default Instance port 2383
\nnetsh firewall set portopening TCP 2383 “Analysis Services”
\n@echo Enabling SQL Server Browser Service port 2382
\nnetsh firewall set portopening TCP 2382 “SQL Browser”
\n@echo =========\u00a0 Misc Applications\u00a0 ==============
\n@echo Enabling HTTP port 80
\nnetsh firewall set portopening TCP 80 “HTTP”
\n@echo Enabling SSL port 443
\nnetsh firewall set portopening TCP 443 “SSL”
\n@echo Enabling port for SQL Server Browser Service’s ‘Browse’ Button
\nnetsh firewall set portopening UDP 1434 “SQL Browser”
\n@echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK)
\nnetsh firewall set multicastbroadcastresponse ENABLE<\/p>\n
———————————————–<\/p>\n
I also added this registry key below. You can copy everything between the breaks and save as a .reg file if you’d like and run that \u2018as administrator\u2019 as well.<\/p>\n
—————-
\nWindows Registry Editor Version 5.00<\/p>\n
[HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\MSSQLServer\\Client\\SuperSocketNetLib\\tcp]
\n“DefaultPort”=dword:00000599
\n—————-<\/p>\n
After that I was able to very quickly install SQL2008R2.
\nDuring server configuration, under Account Name I selected “NT AUTHORITY\\SYSTEM”, leaving password blank. In addition I also changed its startup type from Automatic to Manual.<\/p>\n
Once installation was complete, I opened SQL Server Configuration Manager. The current setting was that I was logging on as built-in account “Local System”. I started the service without making any changes and this time it started without any error messages.<\/p>\n
Just thought I’d put this up for any of those who’ve had the same issue and as a reference for myself.<\/p>\n
To connect to the Server make sure you specify the machine name AND the server instance name: Windows7PC1\\SQL2008dev or whatever<\/p>\n
Well, until I hear differently from my Devs \ud83d\ude1b<\/p>\n","protected":false},"excerpt":{"rendered":"
While installing an instance of SQL2008R2 to a Windows 7 Workstation VM (used by my programmers) on my VMWare vSphere cluster I ran into a problem. While the SQL installation seemed to go OK, it hung up toward the end during ‘Windows Installation Final Tasks – Clean up processes…” or something at “Install_sqlncli_Cpu64_Action” The install … Continue reading “Installing SQL Server 2008R2 to Windows 7 VM”<\/span><\/a><\/p>\n","protected":false},"author":587,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[206,205,13,30,181,182],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/mikemartinezonline.com\/blog\/wp-json\/wp\/v2\/posts\/671"}],"collection":[{"href":"https:\/\/mikemartinezonline.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mikemartinezonline.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mikemartinezonline.com\/blog\/wp-json\/wp\/v2\/users\/587"}],"replies":[{"embeddable":true,"href":"https:\/\/mikemartinezonline.com\/blog\/wp-json\/wp\/v2\/comments?post=671"}],"version-history":[{"count":3,"href":"https:\/\/mikemartinezonline.com\/blog\/wp-json\/wp\/v2\/posts\/671\/revisions"}],"predecessor-version":[{"id":902,"href":"https:\/\/mikemartinezonline.com\/blog\/wp-json\/wp\/v2\/posts\/671\/revisions\/902"}],"wp:attachment":[{"href":"https:\/\/mikemartinezonline.com\/blog\/wp-json\/wp\/v2\/media?parent=671"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mikemartinezonline.com\/blog\/wp-json\/wp\/v2\/categories?post=671"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mikemartinezonline.com\/blog\/wp-json\/wp\/v2\/tags?post=671"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}