Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
dibby44
Starting Member
2 Posts |
Posted - 2009-11-20 : 14:53:16
|
Can anyone help? I am a [very] mature IT student and need to have SQL Server Express 2008 & Management Studio available to do coursework. I have loaded both without a problem on my laptop, but on my pc the installation doesn't work. Although I answer the setup questions the same as for the laptop, I get error messages. I tried loading from the MS web-site [various different options] and from SQLEXPRWT_x86_ENU.exe and from SQLManagementStudio_x86_ENU.exe - I either get an error message with a code like 17113 or 17058 and a web-site prompt that displays a message that "no further information is available, but thanks for letting us know", or, when I load Management Studio, I can't connect to SQL Express and finish up with SQL Compact instead [which is not what I need!]. One time, I got a message that SQL Server failed to install because of Invalid ID, whatever that is supposed to mean. I have had "connection timed out", and messages about pipes, etc. Each time installation failed, I have tried to rectify using info from web-site message boards - to no avail, and then had to uninstall all SQL apps and delete all files, run a registry checker and re-boot. Going on 4 days now, and I am very frustrated at the lack of information as to how to rectify and install properly. I am running a Vista Home Premium setup, the same as my laptop, on which it is all correctly installed first time.Any help to a speedy resolution would be appreciated.Dave B. |
|
dibby44
Starting Member
2 Posts |
Posted - 2009-12-04 : 14:02:04
|
Great news! Following a great tip from MS Guru Richard Marr, the following has resulted in a correct installation.1. Run rsfx.msi and select Repair [probably inC:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Update Cache\KB968369\ServicePack\x64\setup - but may be in the installation setup folder]2. Uninstall all SQL components using Control Panel3. Delete all SQL folders and files manually4. Run Registry checker to clean errors5. Run Windows Install Clean Up to remove all previous SQL installation attempts6. Run SQLEXPRADV_x86_ENU.exe as Administrator7. Follow detailed instructions in the Install para. on http://www.symantec.com/connect/articles/install-and-configure-sql-server-2008-expressBUT watch for a. install .NET 3.5 Framework - if not already installed b. install Windows Installer 4.5 - if not already installed c. install Powershell 1.0 – ? may not suitable for the pc?8. My Installation succeeded9. Use SQL Configuration Manager to Enable TCP/IP and Named Pipes [as per instructions]10. Add 2 programs to Firewall Exceptions list [as per instructions]11. Re-boot p.c.At first loading, I selected SQL Express, but this was not the Named Instance [as per instructions] and did not work.Next, I selected SQL Engine and DAVE-PC and Windows Authentication et voila, the program connected !If you had the same problem as I did, follow this and enjoy SQL Serverend=================== |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|