Re: Failed SQL 2005 install, unable to start again.

Hello RossB,

Is your OS a Windows Vista? I just want you to consider UAC (User Access Control) of Windows Vista\Server 2008 or just simply right click on the SQL Server Setup file and click Run as Administrator to run the setup under your administrator role.

Also, before, I've seen that creating a false file with the same name as just the SQL Server Setup asked simply worked. So, you can use this trick. Create a false\empty file named "mssqlsystemrecource1.ldf" under "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\"

To start over, you can go to Control Panel\Programs & Features and remove all installed components of SQL Server and start a new installation from your SQL Server media.

--
Ekrem Önsoy



"RossB" <RossB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:37CF8135-2840-44DA-AB0E-74705C522259@xxxxxxxxxxxxxxxx
Failed SQL 2005 install, unable to start again.. Error in application log is:

Product: Microsoft SQL Server 2005 -- Error 29538. SQL Server Setup did not
have the administrator permissions required to rename a file: c:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mssqlsystemresource1.ldf. To
continue, verify that the file exists, and either grant administrator
permissions to the account currently running Setup or log in with an
administrator account. Then run SQL Server Setup again.
The error code is (5) Access is denied.


-When running setup again, it says components are installed already.

2 Questions
-how can Error 29538 be avoided
-How can I get installer to run again(there is a sql server native client &
sql server setup support files listed in add/remove programs, but no other
SQL components).

.

Relevant Pages

  • RE: SQL Server 2005 faulure when updating to SP1
    ... The local machine's "Administrator" group has an entry on the directory ... and each file granting "Full Control" along with the Local Windows SQL Server ... When installing the Service Pack, the Indexing Service is disabled and I ... have stopped the Antivirus service when I try the Service Pack installation. ...
    (microsoft.public.sqlserver.setup)
  • Re: Cannot install 2005 Developer Edition x64 on new XP x64
    ... support files, MSXML and the client. ... corrupted SQL Server installation and then try to run SQL Server Setup ... This is a fresh installation of XP Professional x64. ...
    (microsoft.public.sqlserver.setup)
  • Re: Connextion Error After Installing SQL Server 2005 on Vista
    ... But Vista User Account Control doesn't automatically pass your administrator credentials to programs. ... The solution is to explicitly grant Bob access to SQL Server. ... During the installation, I was prompted a couple of times to install a service pack for Visual Studio 2005, which is not currently installed. ...
    (microsoft.public.sqlserver.connect)
  • Re: Cannot install 2005 Developer Edition x64 on new XP x64
    ... "Ekrem Önsoy" wrote in message ... corrupted SQL Server installation and then try to run SQL Server Setup again. ... This is a fresh installation of XP Professional x64. ...
    (microsoft.public.sqlserver.setup)
  • Re: Cannot install 2005 Developer Edition x64 on new XP x64
    ... "Ekrem Önsoy" wrote in message ... corrupted SQL Server installation and then try to run SQL Server Setup again. ... This is a fresh installation of XP Professional x64. ...
    (microsoft.public.sqlserver.setup)