Problem to install SQL Server 2008

  • Hi

    I am in need of help. I had Sql server 2008 R2 installed before. I project I got demanded that I removed R2 and installed 2008 instead. Easy? Hell no.

    I made uninstall on R2, but I see that there are some stuff left.

    I tried to remove All leftover that involves 2008 r2.

    I now installed 2008. But SSRS could not be installed.

    I got this message:

    Details

    Product: SQL Server

    ID: 50000

    Source: setup.rll

    Version: 10.0

    Component: SQL Server Native Client

    Message: A network error occurred while attempting to read from the file '%.*ls'.

    Explanation

    An attempt was made to install (or update) SQL Server Native Client on a computer where SQL Server Native Client is already installed, and where the existing installation was from an MSI file that was not named sqlncli.msi.

    User Action

    To resolve this error, uninstall the existing version of SQL Server Native Client. To prevent this error, do not install SQL Server Native Client from an MSI file that is not named sqlncli.msi.

    I have searched and searched with google, but have not found a solution that works.

    Please help me out.

    Best Regards

    Samuel

  • Please uninstall previous version completly, from control panel.

    Then reboot. Start fresh instalations.

    If still error paste the log from boot startup folder 🙂

  • I have tried to uninstall it and reboot many times. But it does not work.

    After I uninstalled it from controll panel, I still see some stuff from sql server 2008 and 2008 R2.

    I have unistalled the sql server native client. To get a fresh one, but it does not help.

    This is the log:

    Overall summary:

    Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.

    Exit code (Decimal): -2068643839

    Exit facility code: 1203

    Exit error code: 1

    Exit message: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.

    Start time: 2012-05-09 15:45:50

    End time: 2012-05-09 15:47:04

    Requested action: Install

    Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120509_154453\sql_rs_Cpu64_1.log

    Exception help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.5500.0

    Machine Properties:

    Machine name: HELWS047

    Machine processor count: 4

    OS version: Windows Vista

    OS service pack: Service Pack 1

    OS region: Sverige

    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 MSSQLSERVER MSSQL10.MSSQLSERVER Database Engine Services 1033 Standard Edition 10.3.5500.0 No

    Sql Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER SQL Server Replication 1033 Standard Edition 10.3.5500.0 No

    Sql Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER Full-Text Search 1033 Standard Edition 10.3.5500.0 No

    Sql Server 2008 MSSQLSERVER MSAS10.MSSQLSERVER Analysis Services 1033 Standard Edition 10.3.5500.0 No

    Sql Server 2008 Management Tools - Basic 1033 Standard Edition 10.3.5500.0 No

    Sql Server 2008 Management Tools - Complete 1033 Standard Edition 10.3.5500.0 No

    Sql Server 2008 Client Tools Connectivity 1033 Standard Edition 10.3.5500.0 No

    Sql Server 2008 Client Tools Backwards Compatibility 1033 Standard Edition 10.3.5500.0 No

    Sql Server 2008 Client Tools SDK 1033 Standard Edition 10.3.5500.0 No

    Sql Server 2008 Integration Services 1033 Standard Edition 10.3.5500.0 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: E:\x64\setup Installation edition: STANDARD

    User Input Settings:

    ACTION: Install

    ADDCURRENTUSERASSQLADMIN: False

    AGTSVCACCOUNT: <empty>

    AGTSVCPASSWORD: *****

    AGTSVCSTARTUPTYPE: Manual

    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\20120509_154453\ConfigurationFile.ini

    CUSOURCE:

    ENABLERANU: False

    ERRORREPORTING: False

    FEATURES: RS

    FILESTREAMLEVEL: 0

    FILESTREAMSHARENAME: <empty>

    FTSVCACCOUNT: <empty>

    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: MSSQLSERVER

    INSTANCENAME: MSSQLSERVER

    ISSVCACCOUNT: NT AUTHORITY\NetworkService

    ISSVCPASSWORD: *****

    ISSVCSTARTUPTYPE: Automatic

    NPENABLED: 0

    PCUSOURCE:

    PID: *****

    QUIET: False

    QUIETSIMPLE: False

    RSINSTALLMODE: FilesOnlyMode

    RSSVCACCOUNT: NT AUTHORITY\LOCAL SERVICE

    RSSVCPASSWORD: *****

    RSSVCSTARTUPTYPE: Automatic

    SAPWD: *****

    SECURITYMODE: <empty>

    SQLBACKUPDIR: <empty>

    SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS

    SQLSVCACCOUNT: <empty>

    SQLSVCPASSWORD: *****

    SQLSVCSTARTUPTYPE: Automatic

    SQLSYSADMINACCOUNTS: <empty>

    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\20120509_154453\ConfigurationFile.ini

    Detailed results:

    Feature: Reporting Services

    Status: Failed: see logs for details

    MSI status: Failed: see details below

    MSI error code: 0x1639

    MSI log file location: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120509_154453\sql_rs_Cpu64_1.log

    MSI error description:

    Configuration status: Passed

    Rules with failures:

    Global rules:

    Scenario specific rules:

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

  • I have faced this problem several times while installing between SQL Server 2008 R2 standard and enterprise edition. The solution to the problem is that after un-installing the current instance of SQL Server 2008 on your machine, reboot and then remover SQL Server 2008 path from environment variables. Then reboot again and install the SQL Server native client (you will be prompted for that while you run SQL Server R2 2008 installation) because without native client you wont be able to install SQL Server R2 2008 properly.

    Check for automatically configuring SSRS...If the error persists, restart SQL Server 2008 installation and this time check configuring SSRS manually checkbox.

    Hope this helps!

    Regards,

    Rafayz, Information Management Practice,

    Streebo Software Labs

  • To clarify one thing I want to uninstall 2008 R2 and install 2008. I have earlier uninstalled R2 and installed 2008, but SSRS is not installed for some reason and I get the error message.

    So I did as you said.

    uninstalled defualt instance of 2008 (only instance on my computer) Reboot

    removed from environmental variables:

    ;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn;C:\Program Files\Microsoft SQL Server\100\Tools\Binn;C:\Program Files\Microsoft SQL Server\100\DTS\Binn;c:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn and rebooted.

    installed 2008 again. with automatic config as you suggested.

    (I did not manually install Sql server native client, I expected it to be installed automatically with the Sql server installation, it was)

    Unfourtantly same problem. SSRS installation of SSRS failed.

    Any other suggestions?

    The log:

    Overall summary:

    Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.

    Exit code (Decimal): -2068643839

    Exit facility code: 1203

    Exit error code: 1

    Exit message: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.

    Start time: 2012-05-11 18:11:17

    End time: 2012-05-11 18:12:50

    Requested action: Install

    Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120511_181027\sql_rs_Cpu64_1.log

    Exception help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.1600.22

    Machine Properties:

    Machine name: HELWS047

    Machine processor count: 4

    OS version: Windows Vista

    OS service pack: Service Pack 1

    OS region: Sverige

    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 MSSQLSERVER MSSQL10.MSSQLSERVER Database Engine Services 1033 Standard Edition 10.0.1600.22 No

    Sql Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER SQL Server Replication 1033 Standard Edition 10.0.1600.22 No

    Sql Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER Full-Text Search 1033 Standard Edition 10.0.1600.22 No

    Sql Server 2008 MSSQLSERVER MSAS10.MSSQLSERVER Analysis Services 1033 Standard Edition 10.0.1600.22 No

    Sql Server 2008 Management Tools - Basic 1033 Standard Edition 10.0.1600.22 No

    Sql Server 2008 Management Tools - Complete 1033 Standard Edition 10.0.1600.22 No

    Sql Server 2008 Client Tools Connectivity 1033 Standard Edition 10.0.1600.22 No

    Sql Server 2008 Client Tools Backwards Compatibility 1033 Standard Edition 10.0.1600.22 No

    Sql Server 2008 Client Tools SDK 1033 Standard Edition 10.0.1600.22 No

    Sql Server 2008 Integration Services 1033 Standard 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: 0

    Installation location: E:\x64\setup Installation edition: STANDARD

    User Input Settings:

    ACTION: Install

    ADDCURRENTUSERASSQLADMIN: False

    AGTSVCACCOUNT: <empty>

    AGTSVCPASSWORD: *****

    AGTSVCSTARTUPTYPE: Manual

    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\20120511_181027\ConfigurationFile.ini

    ENABLERANU: False

    ERRORREPORTING: False

    FEATURES: RS

    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: MSSQLSERVER

    INSTANCENAME: MSSQLSERVER

    ISSVCACCOUNT: NT AUTHORITY\NetworkService

    ISSVCPASSWORD: *****

    ISSVCSTARTUPTYPE: Automatic

    MEDIASOURCE: E: NPENABLED: 0

    PID: *****

    QUIET: False

    QUIETSIMPLE: False

    RSINSTALLMODE: FilesOnlyMode

    RSSVCACCOUNT: NT AUTHORITY\LOCAL SERVICE

    RSSVCPASSWORD: *****

    RSSVCSTARTUPTYPE: Automatic

    SAPWD: *****

    SECURITYMODE: <empty>

    SQLBACKUPDIR: <empty>

    SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS

    SQLSVCACCOUNT: <empty>

    SQLSVCPASSWORD: *****

    SQLSVCSTARTUPTYPE: Automatic

    SQLSYSADMINACCOUNTS: <empty>

    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\20120511_181027\ConfigurationFile.ini

    Detailed results:

    Feature: Reporting Services

    Status: Failed: see logs for details

    MSI status: Failed: see details below

    MSI error code: 0xBE6A08D9

    MSI log file location: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120511_181027\sql_rs_Cpu64_1.log

    MSI error description:

    Configuration status: Passed

    Rules with failures:

    Global rules:

    Scenario specific rules:

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

    BR

    Samuel

  • Samuel,

    The log shows that your setup file is corrupted. I would suggest you installing from a newer medium and that after you have deleted all the bad installed files.

    Just try it and lemme know if it helps.

    Regards,

    Rafayz

  • If I was in your position, I would ask for Windows to be re-installed.

    IMHO it is never worth uninstalling SQL Server. After it is installed, it should be considered as a core part of the OS, and if a situation arises where the SQL Server services must be removed fom the box, then the safest way to do this is by installing a new copy of the OS.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • I finally accepted that it was best to reinstall Windows. Not fun, but now it works.

    Thanks for you help.

  • SS2K8 R2 Ent install on Win2K8 R2 Ent 64 bit hates me 😉

    I give up, it is time rebuild the server from scratch :hehe:

  • I was having the same problem with Sp1. I found that the install directory can not have any spaces at all. You should notice that t installation folder for SQL has underscores instead of spaces, the path to this directory must not have spaces as well. So if you place this in a folder on the c: drive called "install folder", for example, then replace the space with an underscore or remove it. So the old would be c:\install folder\sqlinstall and the new path would be c:\install_folder\sqlinstall. This should fix the error.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply