Problem to install SQL Server 2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Problem to install SQL Server 2008

Problem to install SQL Server 2008

Rate Topic

Display Mode

Topic Options

Author

Message

samueldhedin

Posted Friday, May 11, 2012 2:10 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, October 05, 2012 1:24 AM
Points: 4, Visits: 100

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

Post #1298402

Pradyothana Shastry

Posted Friday, May 11, 2012 3:31 AM

SSCommitted

Group: General Forum Members
Last Login: Monday, March 25, 2013 5:30 AM
Points: 1,640, Visits: 423

Please uninstall previous version completly, from control panel.
Then reboot. Start fresh instalations.

If still error paste the log from boot startup folder :)

- Pradyothana

http://www.msqlserver.com

Post #1298430

samueldhedin

Posted Friday, May 11, 2012 6:27 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, October 05, 2012 1:24 AM
Points: 4, Visits: 100

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

Post #1298531

rumsmaster

Posted Friday, May 11, 2012 7:33 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, October 23, 2012 7:41 AM
Points: 54, Visits: 80

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

Post #1298586

samueldhedin

Posted Friday, May 11, 2012 10:25 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, October 05, 2012 1:24 AM
Points: 4, Visits: 100

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

Post #1298750

rumsmaster

Posted Monday, May 14, 2012 12:26 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, October 23, 2012 7:41 AM
Points: 54, Visits: 80

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

Post #1299368

EdVassie

Posted Tuesday, May 15, 2012 2:35 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:57 AM
Points: 2,621, Visits: 2,758

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.

Author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005. 25 March 2013: now over 23,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.

Post #1300089

samueldhedin

Posted Wednesday, May 16, 2012 3:28 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, October 05, 2012 1:24 AM
Points: 4, Visits: 100

I finally accepted that it was best to reinstall Windows. Not fun, but now it works.
Thanks for you help.

Post #1300880

Leon . Orlov .

Posted Thursday, September 20, 2012 2:31 PM

SSC Rookie

Group: General Forum Members
Last Login: Friday, April 05, 2013 11:47 AM
Points: 30, Visits: 234

SS2K8 R2 Ent install on Win2K8 R2 Ent 64 bit hates me ;)

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

Post #1362317

« Prev Topic | Next Topic »

Permissions