October 17, 2012 at 7:48 am
JimS-Indy (10/17/2012)
Note Capture 5 -- SQL Server Configuration Manager.Capture 6 -- Server Manager.
Binary install path???
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2012 at 7:58 am
Binary install path???
Asked myself the same question. Is it on the properties sheet and I missed it? I looked.
Jim
October 17, 2012 at 8:11 am
JimS-Indy (10/17/2012)
Note Capture 5 -- SQL Server Configuration Manager.Capture 6 -- Server Manager.
The configuration manager screenshot clearly shows that you do not have 2 instances installed on your system, there is only one instance. Therefore chances are that (as Gail said earlier) that either the upgrade has not completed successfully OR the database engine component was not selected during the upgrade (chances of this is high).
October 17, 2012 at 8:19 am
Divine Flame (10/17/2012)
JimS-Indy (10/17/2012)
Note Capture 5 -- SQL Server Configuration Manager.Capture 6 -- Server Manager.
The configuration manager screenshot clearly shows that you do not have 2 instances installed on your system, there is only one instance. Therefore chances are that (as Gail said earlier) that either the upgrade has not completed successfully OR the database engine component was not selected during the upgrade (chances of this is high).
OK, consensus seems to be that I rerun the installation. I'd rather not deinstall and reinstall, so I'll try the upgrade again. I'll carefully tick the database engine, and I'll watch it run. I assume there's no log I can pull up from the previous run....
Thanks all, I appreciate it!
Jim
October 17, 2012 at 8:52 am
Actually, there should be a log from the previous run, but I'm unsure where that would be on your system.
Anyone else have some input here?
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 17, 2012 at 9:14 am
OK, deep in a folder path, I found two files...SqlSetup_1 (I ran this once before just for the tools...) and SqlSetupLocal_1 (the SqlSetup log seems to have passed control to SqlSetupLocal)
Here's the SqlSetup_1:
10/06/2012 09:40:45.907 ======================================================================
10/06/2012 09:40:45.936 Setup launched
10/06/2012 09:40:45.977 Attempting to determine media source
10/06/2012 09:40:46.012 Media source: C:\Users\jamesshaffer\Desktop\SS2008R2\RTM\Enterprise_Edition10/06/2012 09:40:46.046 Attempt to determine media layout based on file 'C:\Users\jamesshaffer\Desktop\SS2008R2\RTM\Enterprise_Edition\mediainfo.xml'.
10/06/2012 09:40:46.159 Media layout is detected as: Full
10/06/2012 09:40:46.185 Not a slip stream media, so continuing to run setup.exe from media.
10/06/2012 09:40:46.219 /? or /HELP or /ACTION=HELP specified: false
10/06/2012 09:40:46.254 Help display: false
10/06/2012 09:40:46.271 Checking to see if we need to install .Net version 3.5
10/06/2012 09:40:46.287 Determining the cluster status of the local machine.
10/06/2012 09:40:46.315 The local machine is not configured as a cluster node.
10/06/2012 09:40:46.338 Attempting to find media for .Net version 3.5
10/06/2012 09:40:46.355 .Net version 3.5 is installed
10/06/2012 09:40:46.371 RedistMSI::GetExpectedBuildRevision - Setup expects MSI 4.5.6001.22159 at the minimum
10/06/2012 09:40:46.385 Attempting to get Windows Installer version
10/06/2012 09:40:46.405 Windows Installer version detected: 4.5.6001.22162
10/06/2012 09:40:46.421 RedistMSI::IsVistaRTM - Not Vista RTM build
10/06/2012 09:40:46.437 Required version of Windows Installer is already installed
10/06/2012 09:40:46.454 Attempting to get Windows Installer version
10/06/2012 09:40:46.469 Windows Installer version detected: 4.5.6001.22162
10/06/2012 09:40:46.487 RedistMSI::IsVistaRTM - Not Vista RTM build
10/06/2012 09:40:46.504 Required version of Windows Installer is already installed
10/06/2012 09:40:46.521 Current running setup.exe full path: C:\Users\jamesshaffer\Desktop\SS2008R2\RTM\Enterprise_Edition\setup.exe
10/06/2012 09:40:46.536 Media setup.exe file version detected: 2009.100.1600.1
10/06/2012 09:40:46.554 Locally installed setup.exe full path: c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\setup.exe
10/06/2012 09:40:46.571 Local setup.exe file version detected: 2009.100.4000.0
10/06/2012 09:40:46.583 Local setup.exe version 2009.100.4000.0 is equal or greater than media version 2009.100.1600.1, so re-launching setup.exe from local
10/06/2012 09:40:46.601 Media source: C:\Users\jamesshaffer\Desktop\SS2008R2\RTM\Enterprise_Edition10/06/2012 09:40:46.608 Install media path: C:\Users\jamesshaffer\Desktop\SS2008R2\RTM\Enterprise_Edition\x64\setup10/06/2012 09:40:46.625 Media layout: Full
10/06/2012 09:40:46.641 Attempting to get execution timestamp
10/06/2012 09:40:46.659 Timestamp: 20121006_094045
10/06/2012 09:40:46.667 Attempting to launch local setup.exe
10/06/2012 09:40:46.675 Attempting to launch process c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\setup.exe
10/06/2012 09:59:40.135 Process returned exit code: 0x00000BC2
10/06/2012 09:59:40.295 Local setup.exe returned exit code: 0x00000BC2
10/06/2012 09:59:40.314 Setup closed with exit code: 0x84C40013
10/06/2012 09:59:40.327 ======================================================================
And, SqlSetupLocal_1:
10/06/2012 09:40:46.795 ======================================================================
10/06/2012 09:40:46.811 Setup launched
10/06/2012 09:40:46.829 Attempting to determine media source
10/06/2012 09:40:46.846 Media source: C:\Users\jamesshaffer\Desktop\SS2008R2\RTM\Enterprise_Edition10/06/2012 09:40:46.862 Attempt to determine media layout based on file 'C:\Users\jamesshaffer\Desktop\SS2008R2\RTM\Enterprise_Edition\mediainfo.xml'.
10/06/2012 09:40:46.967 Media layout is detected as: Full
10/06/2012 09:40:46.986 Setup.exe is running locally no check for a slip stream media
10/06/2012 09:40:47.004 /? or /HELP or /ACTION=HELP specified: false
10/06/2012 09:40:47.021 Help display: false
10/06/2012 09:40:47.037 Checking to see if we need to install .Net version 3.5
10/06/2012 09:40:47.054 Determining the cluster status of the local machine.
10/06/2012 09:40:47.115 The local machine is not configured as a cluster node.
10/06/2012 09:40:47.144 Attempting to find media for .Net version 3.5
10/06/2012 09:40:47.163 .Net version 3.5 is installed
10/06/2012 09:40:47.179 RedistMSI::GetExpectedBuildRevision - Setup expects MSI 4.5.6001.22159 at the minimum
10/06/2012 09:40:47.195 Attempting to get Windows Installer version
10/06/2012 09:40:47.213 Windows Installer version detected: 4.5.6001.22162
10/06/2012 09:40:47.229 RedistMSI::IsVistaRTM - Not Vista RTM build
10/06/2012 09:40:47.269 Required version of Windows Installer is already installed
10/06/2012 09:40:47.295 Attempting to get Windows Installer version
10/06/2012 09:40:47.313 Windows Installer version detected: 4.5.6001.22162
10/06/2012 09:40:47.329 RedistMSI::IsVistaRTM - Not Vista RTM build
10/06/2012 09:40:47.346 Required version of Windows Installer is already installed
10/06/2012 09:40:47.494 Strong name verification disabling is not required
10/06/2012 09:40:47.528 /? or /HELP or /ACTION=HELP specified: false
10/06/2012 09:40:47.585 Help display: false
10/06/2012 09:40:47.623 Attempting to launch landing page workflow
10/06/2012 09:40:47.646 Attempting to set setup mutex
10/06/2012 09:40:47.671 Setup mutex has been set
10/06/2012 09:40:47.683 Attempting to launch global rules workflow
10/06/2012 09:40:47.701 Media source: C:\Users\jamesshaffer\Desktop\SS2008R2\RTM\Enterprise_Edition10/06/2012 09:40:47.712 Install media path: C:\Users\jamesshaffer\Desktop\SS2008R2\RTM\Enterprise_Edition\x64\setup10/06/2012 09:40:47.725 Media layout: Full
10/06/2012 09:40:47.737 Attempting to get execution timestamp
10/06/2012 09:40:47.750 Timestamp: 20121006_094045
10/06/2012 09:40:47.762 Attempting to run workflow RUNRULES /RULES=GlobalRules
10/06/2012 09:40:47.775 Attempting to launch process c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x64\setup100.exe
10/06/2012 09:41:10.622 Process returned exit code: 0x00000000
10/06/2012 09:41:10.644 Workflow RUNRULES /RULES=GlobalRules returned exit code: 0x00000000
10/06/2012 09:41:10.656 Attempting to launch component update workflow
10/06/2012 09:41:10.669 Media source: C:\Users\jamesshaffer\Desktop\SS2008R2\RTM\Enterprise_Edition10/06/2012 09:41:10.685 Install media path: C:\Users\jamesshaffer\Desktop\SS2008R2\RTM\Enterprise_Edition\x64\setup10/06/2012 09:41:10.698 Media layout: Full
10/06/2012 09:41:10.710 Attempting to get execution timestamp
10/06/2012 09:41:10.723 Timestamp: 20121006_094045
10/06/2012 09:41:10.735 Attempting to run workflow COMPONENTUPDATE
10/06/2012 09:41:10.752 Attempting to launch process c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x64\setup100.exe
10/06/2012 09:41:32.604 Process returned exit code: 0x00000000
10/06/2012 09:41:32.633 Workflow COMPONENTUPDATE returned exit code: 0x00000000
10/06/2012 09:41:32.662 Attempting to launch user requested workflow locally
10/06/2012 09:41:32.688 Attempting to find local setup.exe
10/06/2012 09:41:32.700 Local bootstrap folder path: c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap10/06/2012 09:41:32.717 Local setup100.exe full path: c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x64\setup100.exe
10/06/2012 09:41:32.729 Media source: C:\Users\jamesshaffer\Desktop\SS2008R2\RTM\Enterprise_Edition10/06/2012 09:41:32.742 Install media path: C:\Users\jamesshaffer\Desktop\SS2008R2\RTM\Enterprise_Edition\x64\setup10/06/2012 09:41:32.754 Media layout: Full
10/06/2012 09:41:32.767 Attempting to get execution timestamp
10/06/2012 09:41:32.783 Timestamp: 20121006_094045
10/06/2012 09:41:32.796 Attempting to run user requested action from local setup100.exe
10/06/2012 09:41:32.808 Attempting to launch process c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x64\setup100.exe
10/06/2012 09:59:39.593 Process returned exit code: 0x00000BC2
10/06/2012 09:59:39.743 Local setup100.exe returned exit code: 0x00000BC2
10/06/2012 09:59:39.773 Attempting to release setup mutex
10/06/2012 09:59:39.800 Setup mutex has been released
10/06/2012 09:59:39.860 Setup closed with exit code: 0x84C40013
10/06/2012 09:59:39.896 ======================================================================
Jim
October 17, 2012 at 11:46 am
JimS-Indy (10/17/2012)
Binary install path???
Asked myself the same question. Is it on the properties sheet and I missed it? I looked.
find the service name in services.msc and right click then select properties. Get the binary path here and post details back
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2012 at 1:26 pm
Perry Whittle (10/17/2012)
JimS-Indy (10/17/2012)
Binary install path???
Asked myself the same question. Is it on the properties sheet and I missed it? I looked.
find the service name in services.msc and right click then select properties. Get the binary path here and post details back
Nothing changed. Here is the services.msc, properties sheet...
Jim
October 17, 2012 at 2:16 pm
ok, the path shown is atypical of a SQL server 2005 installation. Confirm this by browsing to the sqlservr.exe and open the file properties, on the version info check the EXE version
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2012 at 2:24 pm
Looks like SQL Server 2005....
Jim
October 17, 2012 at 2:34 pm
Yes, it's SQL Server 2005 SP3
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2012 at 7:13 pm
Here's a great overview of versions and builds: http://www.sqlsecurity.com/faqs-1/sql-server-versions
The version number in the file properties (and in server properties inside Management Studio) lets you know exactly what build you're running - just look it up and you'll know for sure. 🙂
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 17, 2012 at 11:50 pm
Vegard Hagen (10/17/2012)
Here's a great overview of versions and builds: http://www.sqlsecurity.com/faqs-1/sql-server-versionsThe version number in the file properties (and in server properties inside Management Studio) lets you know exactly what build you're running - just look it up and you'll know for sure. 🙂
Did you not see my response above????
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2012 at 7:31 am
Yes, I did - and you knew exactly what you were looking at, but the other guy said it "looked like" something, so I gave him a resource that would let him know for sure. 😉
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 18, 2012 at 8:25 am
Vegard Hagen (10/18/2012)
Yes, I did - and you knew exactly what you were looking at, but the other guy said it "looked like" something, so I gave him a resource that would let him know for sure. 😉
Thanks for that website. Bookmarked!
Viewing 15 posts - 16 through 30 (of 31 total)
You must be logged in to reply to this topic. Login to reply