RUA Volunteer2?
asked on
Unable to instal SQL Server 2008
The only thing that failed is the SQL Server Express 2005 Tools. It says I need to remove SQL 2005 Express Tools. I am afraid to do that as it might mess up another database that uses SQL Server 2005? I thought I could have both installed. Everything else passes in the test.
InstallationRules.png
RuleCheckResult.png
InstallationRules.png
RuleCheckResult.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I do not see "SQL Server Express" anywhere. Are you guys sure I am not going to damage any other application by removing or editing the registry?
Remember I have another program that is using SQL Server 2005 as its DB. I do not want to remove the SQL 2005 DB at all. Very important that I do not. Here is what I do see.
ListOfInstalledApplications.png
Remember I have another program that is using SQL Server 2005 as its DB. I do not want to remove the SQL 2005 DB at all. Very important that I do not. Here is what I do see.
ListOfInstalledApplications.png
ASKER
sqlserver:
I am not going to be migrating 2005 to 2008. I do not think I can with the application we have on the machine. It was designed for 2005 only I believe.
I am not going to be migrating 2005 to 2008. I do not think I can with the application we have on the machine. It was designed for 2005 only I believe.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
SammySeltzer:
I renamed the registry and there were no changes. I still get no activity when I hit next on the Installation rules screen.
Sqlserver:
The following is a list of applications from the Server list I did not see any 3rd party tools. I am assuming you are referring to
Data Comparison
Data Generator
Did you mean TOAD as in the Oracle tool?
Any thoughts anyone?
ServerAppList.png
I renamed the registry and there were no changes. I still get no activity when I hit next on the Installation rules screen.
Sqlserver:
The following is a list of applications from the Server list I did not see any 3rd party tools. I am assuming you are referring to
Data Comparison
Data Generator
Did you mean TOAD as in the Oracle tool?
Any thoughts anyone?
ServerAppList.png
ASKER
I clicked View Details of the SQL Server 2008 Setup under install the installation rules and got this error.
Description:
SQL Server 2008 Setup has encountered an error.
Problem signature:
Problem Event Name: SQL100Exception
Problem Signature 01: SQL2008@RTM@
Problem Signature 02: 0xC5001868
Problem Signature 03: 0xC5001868
Problem Signature 04: 0xDC80C325
Problem Signature 05: 0xDC80C325
Problem Signature 06: GatherUserSettings
Problem Signature 07: Unknown
Problem Signature 08: Unknown
Problem Signature 09: Unknown
Problem Signature 10: Unknown
OS Version: 6.0.6002.2.2.0.272.7
Locale ID: 1033
Additional information about the problem:
LCID: 1033
Read our privacy statement:
http://go.microsoft.com/fwlink/?linkid=50163&clcid=0x0409
Has anyone seen this......?
Description:
SQL Server 2008 Setup has encountered an error.
Problem signature:
Problem Event Name: SQL100Exception
Problem Signature 01: SQL2008@RTM@
Problem Signature 02: 0xC5001868
Problem Signature 03: 0xC5001868
Problem Signature 04: 0xDC80C325
Problem Signature 05: 0xDC80C325
Problem Signature 06: GatherUserSettings
Problem Signature 07: Unknown
Problem Signature 08: Unknown
Problem Signature 09: Unknown
Problem Signature 10: Unknown
OS Version: 6.0.6002.2.2.0.272.7
Locale ID: 1033
Additional information about the problem:
LCID: 1033
Read our privacy statement:
http://go.microsoft.com/fwlink/?linkid=50163&clcid=0x0409
Has anyone seen this......?
ASKER
This is what happened when I did that. Do you think this will mess up any of the databases that are installed with SQL 2005?
UninstallSQLSrvrMgmntExp.png
UninstallSQLSrvrMgmntExp.png
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yikes, I had already renamed the folder HKLM\SOFTWARE\Microsoft\Mi crosoft SQL Server\90
Should I put it back to its original name.....?
I went ahead and clicked okay and got this error message:
TITLE: Microsoft SQL Server 2008 Setup
-------------------------- ----
The following error has occurred:
Error reading from file: C:\Users\Rob Burdine\Downloads\SQLServe r2008\x64\ setup\sql_ common_cor e_loc_msi\ 1033\PFile s\SqlServr \100\KeyFi le\1033\ic yqpif8.dll . Verify that the file exists and that you can access it.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.2531.0&EvtType=0xDF039760%25401201%25401
-------------------------- ----
BUTTONS:
OK
-------------------------- ----
Should I put it back to its original name.....?
I went ahead and clicked okay and got this error message:
TITLE: Microsoft SQL Server 2008 Setup
--------------------------
The following error has occurred:
Error reading from file: C:\Users\Rob Burdine\Downloads\SQLServe
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.2531.0&EvtType=0xDF039760%25401201%25401
--------------------------
BUTTONS:
OK
--------------------------
ASKER
Update. I just updated the registry back to its original format renaming the "90" file back. Then I got this message.
TITLE: Microsoft SQL Server 2008 Setup
-------------------------- ----
The following error has occurred:
Error reading from file: C:\Users\Rob Burdine\Downloads\SQLServe r2008\x64\ setup\sql_ engine_cor e_shared_m si\PFiles3 2\SqlServr \100\Tools \Binn\sche mas\sqlser vr\2004\07 \dta\enkla ez5.xsd. Verify that the file exists and that you can access it.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.2531.0&EvtType=0xDF039760%25401201%25401
-------------------------- ----
BUTTONS:
OK
-------------------------- ----
Any thoughts.
TITLE: Microsoft SQL Server 2008 Setup
--------------------------
The following error has occurred:
Error reading from file: C:\Users\Rob Burdine\Downloads\SQLServe
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.2531.0&EvtType=0xDF039760%25401201%25401
--------------------------
BUTTONS:
OK
--------------------------
Any thoughts.
ruavol2,
You should have ideally uninstalled "Microsoft SQL Server Management Studio Express"(as the other expert also suggested) from your system instead of doing those Registry and other Folder renames(so and so)..
And for the errors mentioned in the last two posts, your setup file seems to be corrupted or missing few files.
You can fix if via
1. Downloading Setup again
2. If you have copy of Iso file, then mount it to a local drive or copy the installer contents to a local drive from Disk or network.
You should have ideally uninstalled "Microsoft SQL Server Management Studio Express"(as the other expert also suggested) from your system instead of doing those Registry and other Folder renames(so and so)..
And for the errors mentioned in the last two posts, your setup file seems to be corrupted or missing few files.
You can fix if via
1. Downloading Setup again
2. If you have copy of Iso file, then mount it to a local drive or copy the installer contents to a local drive from Disk or network.
ASKER
Then do I run the setup again or just go to Add Remove Programs and try to uninstall it? Please advise. Thank you.
Uninstall "Microsoft SQL Server Management Studio Express"
&
Install MS SQL 2008 Setup.
After full setup, open Microsoft SQL Server Management Studio 2008.
&
Install MS SQL 2008 Setup.
After full setup, open Microsoft SQL Server Management Studio 2008.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I know everyone has said uninstall "Microsoft SQL Server Management Studio Express", Guess what it is not there. I have tried reinstalling and uninstalling dozens of times. It is just not working is there any other way I can get this stuff off. I have wasted weeks on this and gotten no where. Is there any other way. Please advise. Thank you.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
sorry for late response.
The registry usually works 99.9% of the time.
I guess this is one of those situations where it didn't work.
I can only suggest to follow the other posters' guidance and hopefully, things will work out.
The registry usually works 99.9% of the time.
I guess this is one of those situations where it didn't work.
I can only suggest to follow the other posters' guidance and hopefully, things will work out.
ASKER
Those all seemed to help. What I finally did was take the link here and manually uninstall it.
http://support.microsoft.com/kb/955404
Thanks for everything.
http://support.microsoft.com/kb/955404
Thanks for everything.
while migrating from sql server 2005 to sql server 2008 , please use update advisor