Installin sqlserver 2005 error

I get the following error message when I install sqlserver 2005.

TITLE: Microsoft SQL Server 2005 Setup

The installer has encountered an unexpected error. The error code is 2380. Error opening file for write: 5. GetLastError: SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=2380&EvtType=sqlca%5csqlsecurityca.cpp%40Do_sqlGroup%40Do_sqlGroup%40x5

BUTTONS:

&Retry
Cancel

Anybody got an idea?

Thanks

Hi ttfo,

Are you remotely installing SQLExpress? If so please see this article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;896613
You cannot connect to Visual Studio SQL Server Express on a remote Windows XP Service Pack 2-based computer

HTH

Jeremy

|||

Jeremy,

Thanks for the reply.

I am not remotely installing.

ttfo

|||does the directory have write permission?|||

ahmedilyas,

Not sure which directory it is trying to update.

Thanks,

Tony

|||

Hi Tony,

Thanks for the update.

TITLE: Microsoft SQL Server 2005 Setup

The installer has encountered an unexpected error. The error code is 2380. Error opening file for write: 5. GetLastError: SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=2380&EvtType=sqlca%5csqlsecurityca.cpp%40Do_sqlGroup%40Do_sqlGroup%40x5

1. Regarding the error message when you install sqlserver 2005. Can you confirm the following points, cheers:
a. Operating System? (XP?)

b. OS Service Pack level? (SP2?)

c. What flavour of SQL? (Express?)

c. Is this a second instance of SQL or the default one thats failing? (first based on the registry key error?)

d. Have you logged on as local administrator, cleared the temp directory, copied the files onto to the C:\ and tried to install from harddisk?

2. Should you continue to experience problems with this machine, is it possible to test with another PC or rebuild the problematic one?

I've encountered this issue on one PC, yet I was able to install SQL Express successfully on another PC via RDP at the same site but not on another PC that was producing the error your seeing. To cut a long story short, we got onsite staff to reboot the (WinXP SP2) Pc and it started showing symptoms seen in this KB article:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;826955
"Virus alert about the Blaster worm and its variants"

3. If you can NOT get another PC to rule-out virus, hardware, media &/or etc related issues as the root cause and would like to pursue troubleshooting.. Can you please run FileMon & RegMon traces (and provide the SQL SETUP LOGS) on the PC while your installing SQL?

Based on the error message, the problem stems from "Error opening file for write: 5." and the API for GetLastError reports a Registry key is to blame: "GetLastError: SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup." - hence the FileMon and Regmon traces are needed to aid troubleshooting,

To get a FileMon & RegMon traces

goto www.SysInternals.com (I believe the company and its tools were recently purchased by Microsoft - Mark Russinovich and Bruce Cogwell)

Search for FileMon/Regmon
Scroll to bottom of pages
Download the Programs

0. Remote in as Admin and clear the Temp directory.

1. Save Filemon and Regmon to the PC
2. Get ready to start the SQL Express install
3. Launch open Filemon and Regmon. - To start with I recommend stopping the traces and clearing the logs (with tool bar buttons) because when you launch open the programs they quickly start tracing out Disk and Registry Activity
4. When you get very close to the problem occurring start FileMon/RegMon together - tracing out all the activity in real-time.
5. After you encounter the problem, stop the FileMon/Regmon traces
6. Zip up ALL the traces INCLUDING ALL THE SQL SETUP LOGS YOU CAN FIND - hehe and also RUN THE "mps reports" -sql flavour, on the pc - and post them online!!

Regarding the error messages link: setup.rll 2380 error, try looking in your application event log for the events leading up to the problem and cross reference them with www.EventID.net

HTH

PS the tip to analysing these Regmon/FileMon files is (off the top of my head) > Excel > Data menu > Filter item > Auto Filter item. Then select the combobox with Success, Path not found > and set it to DEVICE DATA ERROR or ACCESS DENIED & hunt down those leads!!

|||

Thanks for the reply, although I am a little late in responding. I ended up formating the disk and starting over. It worked ok then.

Thansk for the help.

|||

Thanks for the update Tony,

Good move reformatting the HDD... as your dont want a production system thats potentially been corrupted.

Cheers,

Jeremy