Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
I am getting a SQL version problem and I need help!!!!

已答覆 I am getting a SQL version problem and I need help!!!!

All Replies

  • Wednesday, October 26, 2011 2:11 AM
     
     
    Sign In to Vote
    0

    Hi,

    Could you please elaborate a bit on your issue? How did you get the error? 

    You can refer to the following links to uninstall an existing SQL Server instance:

    How to: Uninstall an Existing Instance of SQL Server (Setup)
    http://technet.microsoft.com/en-us/library/ms143412.aspx

    How to uninstall an instance of SQL Server 2008
    http://support.microsoft.com/kb/955499

    Reference:

    Considerations for Side-by-Side Instances of SQL Server 2008 R2 and SQL Server 2008
    http://technet.microsoft.com/en-us/library/ee210714.aspx

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Get or Request Code Sample from Microsoft
    If you have any feedback, please tell us.
     
  • Wednesday, October 26, 2011 2:28 AM
     
     
    Sign In to Vote
    0

    I started with Sql Server 2008 R2 but after trying to publish to my hosting site, server version problem, I tried unsuccessfully to uninstall (I still see programs in the add/remove programs list that will not go away). I then installed Sql Server 2005 Express and got the error above. there were forums that said I needed to install Sql Server 2008 express and I did (still got it) following is the log from it.

    Overall summary:
    Final result: Passed
    Exit code (Decimal): 0
    Exit message: Passed
    Start time: 2011-10-25 20:44:26
    End time: 2011-10-25 21:13:52
    Requested action: Install

    Machine Properties:
    Machine name: PDSPIPING02
    Machine processor count: 2
    OS version: Windows Vista
    OS service pack: Service Pack 2
    OS region: United States
    OS language: English (United States)
    OS architecture: x64
    Process architecture: 64 Bit
    OS clustered: No

    Product features discovered:
    Product Instance Instance ID Feature Language Edition Version Clustered

    Package properties:
    Description: SQL Server Database Services 2008
    SQLProductFamilyCode: {628F8F38-600E-493D-9946-F4178F20A8A9}
    ProductName: SQL2008
    Type: RTM
    Version: 10
    SPLevel: 0
    Installation location: c:\eb70481bacc36e8a06531cbe\x64\setup\
    Installation edition: EXPRESS_ADVANCED

    User Input Settings:
    ACTION: Install
    ADDCURRENTUSERASSQLADMIN: False
    AGTSVCACCOUNT: NT AUTHORITY\NETWORK SERVICE
    AGTSVCPASSWORD: *****
    AGTSVCSTARTUPTYPE: Disabled
    ASBACKUPDIR: Backup
    ASCOLLATION: Latin1_General_CI_AS
    ASCONFIGDIR: Config
    ASDATADIR: Data
    ASDOMAINGROUP: <empty>
    ASLOGDIR: Log
    ASPROVIDERMSOLAP: 1
    ASSVCACCOUNT: <empty>
    ASSVCPASSWORD: *****
    ASSVCSTARTUPTYPE: Automatic
    ASSYSADMINACCOUNTS: <empty>
    ASTEMPDIR: Temp
    BROWSERSVCSTARTUPTYPE: Disabled
    CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111025_204225\ConfigurationFile.ini
    CUSOURCE:
    ENABLERANU: True
    ERRORREPORTING: False
    FEATURES: SQLENGINE,REPLICATION,FULLTEXT,RS,BIDS,SSMS,OCS
    FILESTREAMLEVEL: 0
    FILESTREAMSHARENAME: <empty>
    FTSVCACCOUNT: NT AUTHORITY\LOCAL SERVICE
    FTSVCPASSWORD: *****
    HELP: False
    INDICATEPROGRESS: False
    INSTALLSHAREDDIR: c:\Program Files\Microsoft SQL Server\
    INSTALLSHAREDWOWDIR: c:\Program Files (x86)\Microsoft SQL Server\
    INSTALLSQLDATADIR: <empty>
    INSTANCEDIR: C:\Program Files\Microsoft SQL Server\
    INSTANCEID: SQLExpress
    INSTANCENAME: SQLEXPRESS
    ISSVCACCOUNT: NT AUTHORITY\NetworkService
    ISSVCPASSWORD: *****
    ISSVCSTARTUPTYPE: Automatic
    NPENABLED: 0
    PCUSOURCE:
    PID: *****
    QUIET: False
    QUIETSIMPLE: False
    RSINSTALLMODE: FilesOnlyMode
    RSSVCACCOUNT: PDSPIPING02\Rick
    RSSVCPASSWORD: *****
    RSSVCSTARTUPTYPE: Automatic
    SAPWD: *****
    SECURITYMODE: <empty>
    SQLBACKUPDIR: <empty>
    SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS
    SQLSVCACCOUNT: Rick
    SQLSVCPASSWORD: *****
    SQLSVCSTARTUPTYPE: Automatic
    SQLSYSADMINACCOUNTS: PDSPIPING02\Rick
    SQLTEMPDBDIR: <empty>
    SQLTEMPDBLOGDIR: <empty>
    SQLUSERDBDIR: <empty>
    SQLUSERDBLOGDIR: <empty>
    SQMREPORTING: False
    TCPENABLED: 0
    X86: False

    Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111025_204225\ConfigurationFile.ini

    Detailed results:
    Feature: Database Engine Services
    Status: Passed
    MSI status: Passed
    Configuration status: Passed

    Feature: SQL Server Replication
    Status: Passed
    MSI status: Passed
    Configuration status: Passed

    Feature: Full-Text Search
    Status: Passed
    MSI status: Passed
    Configuration status: Passed

    Feature: Reporting Services
    Status: Passed
    MSI status: Passed
    Configuration status: Passed

    Feature: Management Tools - Basic
    Status: Passed
    MSI status: Passed
    Configuration status: Passed

    Feature: Business Intelligence Development Studio
    Status: Passed
    MSI status: Passed
    Configuration status: Passed

    Feature: Microsoft Sync Framework
    Status: Passed
    MSI status: Passed
    Configuration status: Passed

    Rules with failures:

    Global rules:

    Scenario specific rules:

    Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111025_204225\SystemConfigurationCheck_Report.htm
    Overall summary:
    Final result: Passed
    Exit code (Decimal): 0
    Exit message: Passed
    Start time: 2011-10-25 20:42:58
    End time: 2011-10-25 20:44:23
    Requested action: ComponentUpdate

    Machine Properties:
    Machine name: PDSPIPING02
    Machine processor count: 2
    OS version: Windows Vista
    OS service pack: Service Pack 2
    OS region: United States
    OS language: English (United States)
    OS architecture: x64
    Process architecture: 64 Bit
    OS clustered: No

    Package properties:
    Description: SQL Server Database Services 2008
    SQLProductFamilyCode: {628F8F38-600E-493D-9946-F4178F20A8A9}
    ProductName: SQL2008
    Type: RTM
    Version: 10
    SPLevel: 0
    Installation location: c:\eb70481bacc36e8a06531cbe\x64\setup\
    Installation edition: EXPRESS_ADVANCED

    User Input Settings:
    ACTION: ComponentUpdate
    CONFIGURATIONFILE:
    HELP: False
    INDICATEPROGRESS: False
    PID: *****
    QUIET: False
    QUIETSIMPLE: False
    X86: False

    Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111025_204225\ConfigurationFile.ini

    Detailed results:

    Rules with failures:

    Global rules:

    There are no scenario-specific rules.

    Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111025_204225\SystemConfigurationCheck_Report.htm

    Overall summary:
    Final result: Passed
    Exit code (Decimal): 0
    Exit message: Passed
    Start time: 2011-10-25 20:42:28
    End time: 2011-10-25 20:42:55
    Requested action: RunRules

    Machine Properties:
    Machine name: PDSPIPING02
    Machine processor count: 2
    OS version: Windows Vista
    OS service pack: Service Pack 2
    OS region: United States
    OS language: English (United States)
    OS architecture: x64
    Process architecture: 64 Bit
    OS clustered: No

    Product features discovered:
    Product Instance Instance ID Feature Language Edition Version Clustered

    Package properties:
    Description: SQL Server Database Services 2008
    SQLProductFamilyCode: {628F8F38-600E-493D-9946-F4178F20A8A9}
    ProductName: SQL2008
    Type: RTM
    Version: 10
    SPLevel: 0
    Installation location: c:\eb70481bacc36e8a06531cbe\x64\setup\
    Installation edition: EXPRESS_ADVANCED

    User Input Settings:
    ACTION: RunRules
    CONFIGURATIONFILE:
    FEATURES:
    HELP: False
    INDICATEPROGRESS: False
    INSTANCENAME: <empty>
    QUIET: False
    QUIETSIMPLE: False
    RULES: GlobalRules
    X86: False

    Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111025_204225\ConfigurationFile.ini

    Detailed results:

    Rules with failures:

    Global rules:

    There are no scenario-specific rules.

    Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111025_204225\SystemConfigurationCheck_Report.htm

     

     

    Then forum entries said to install Sp1 (log follows), then sp2, the sp3. None have helped to fix the problem. I have been working on this for 5 days now. Can someone please tell me what to do?

    Overall summary:
    Final result: Passed
    Exit code (Decimal): 0
    Exit message: Passed
    Start time: 2011-10-25 21:17:51
    End time: 2011-10-25 21:42:51
    Requested action: Patch

    Instance SQLEXPRESS overall summary:
    Final result: Passed
    Exit code (Decimal): 0
    Exit message: Passed
    Start time: 2011-10-25 21:29:07
    End time: 2011-10-25 21:41:34
    Requested action: Patch

    Machine Properties:
    Machine name: PDSPIPING02
    Machine processor count: 2
    OS version: Windows Vista
    OS service pack: Service Pack 2
    OS region: United States
    OS language: English (United States)
    OS architecture: x64
    Process architecture: 64 Bit
    OS clustered: No

    Product features discovered:
    Product Instance Instance ID Feature Language Edition Version Clustered
    Sql Server 2008 SQLEXPRESS MSSQL10.SQLEXPRESS Database Engine Services 1033 Express Edition 10.0.1600.22 No
    Sql Server 2008 SQLEXPRESS MSSQL10.SQLEXPRESS SQL Server Replication 1033 Express Edition 10.0.1600.22 No
    Sql Server 2008 SQLEXPRESS MSSQL10.SQLEXPRESS Full-Text Search 1033 Express Edition 10.0.1600.22 No
    Sql Server 2008 SQLEXPRESS MSRS10.SQLEXPRESS Reporting Services 1033 Express Edition 10.0.1600.22 No
    Sql Server 2008 Management Tools - Basic 1033 Express Edition 10.0.1600.22 No

    Package properties:
    Description: SQL Server Database Services 2008
    SQLProductFamilyCode: {628F8F38-600E-493D-9946-F4178F20A8A9}
    ProductName: SQL2008
    Type: RTM
    Version: 10
    SPLevel: 1
    KBArticle: KB968369
    KBArticleHyperlink: http://support.microsoft.com/?kbid=968369
    PatchType: SP
    AssociateHotfixBuild: 0
    Platform: x64
    PatchLevel: 10.1.2531.0
    ProductVersion: 10.0.1600.22
    GDRReservedRange: 10.0.1000.0:10.0.1099.0;10.0.3000.0:10.0.3099.0
    PackageName: SQLServer2008-KB968369-x64.exe
    Installation location: c:\a1e72fbdad482fec6b47\x64\setup\

    Updated product edition:
    Instance Edition
    SQLEXPRESS EXPRESS_ADVANCED

    User Input Settings:
    ACTION: Patch
    ALLINSTANCES: False
    CLUSTERPASSIVE: False
    CONFIGURATIONFILE:
    HELP: False
    INDICATEPROGRESS: False
    INSTANCENAME: <empty>
    QUIET: False
    QUIETSIMPLE: False
    X86: False

    Rules with failures:

    Global rules:

    There are no scenario-specific rules.

    Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111025_211738\SystemConfigurationCheck_Report.htm

     

    I really can't go beyond SP1, if i do I will go back to the origional problem with the server problem with the hosting site.

     

     

    Kevin Craig
     
  • Wednesday, October 26, 2011 1:54 PM
     
     Answered
    Sign In to Vote
    1

    My limited experience is that when you have this kind of problem, there was a failure to completely uninstall some SQL Server version that leaves the machine (in the minds of the SQL Server installer and uninstaller) in a confused state.

    Check out the last post here for the asker's final solution: http://forums.iis.net/t/1162871.aspx

    Also, you may need the same cleanup that was mentioned in the answer to this thread.

    http://social.msdn.microsoft.com/Forums/en/sqlexpress/thread/f9439a40-3160-4c6e-b2be-bc72c1961016

    This is somewhat shooting in the dark, but I hope this helps.  (If it works it is better that reformatting the hard drive, reinstalling Windows and all other software, then SQL Server, etc.)

    RLF

    • Marked As Answer by Kevlar1964 Wednesday, October 26, 2011 7:42 PM
    •  
     
  • Wednesday, October 26, 2011 7:48 PM
     
     
    Sign In to Vote
    0

    I did the part about msiinv.exe, then the part about msiexec.exe, then ran CCleaner to clean the registry. Then i reinstalled MS Sql Server 2008 express, followed by Sql Server 2008 SP1.  Everything works now.  Error message has gone away.

    Thanks to Russell Fields for the info.

     

     

    Kevin Craig