I have the evaluation edition of SQL Server 2000 and trying to install the
'client tools' namely the Enterprise Manager on my PC. I'm getting an error
when running the installation program. I get as far as choosing the
location to install to, and when I click "Next" I get the error:

"A previous program installation created pending file operations on the
installation machine. You must restart your computer before running setup".

I've restarted my PC and restarted the setup program numerous times, but
always get the same message.

I do have SQL Server 2005 Express installed - would this make a difference
to installing SQL 2000 (or components thereof)? Perhaps it is causing
conflicts? I'm trying to install only the 'client tools' (as per advice
from my host) so I can interface with their db server (Sql Server 2000)
using the Enterprise Manager.

Is there any issue with connecting with the Management Studio in SQL Server
Express 2005, to a SQL Server 2000?
I have managed to do so, but my host thinks there may be compatibility
issues.

Have a look at the following KB article (specifically step 2)
http://support.microsoft.com/default.aspx?id=312995

--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
http://sqlblogcasts.com/blogs/sqldbatips


"Andrew Murray" <adKillSpammersmurray@iinet.net.au> wrote in message
news:O2i7dmStHHA.4952@TK2MSFTNGP04.phx.gbl...
>I have the evaluation edition of SQL Server 2000 and trying to install the
>'client tools' namely the Enterprise Manager on my PC. I'm getting an
>error when running the installation program. I get as far as choosing the
>location to install to, and when I click "Next" I get the error:
>
> "A previous program installation created pending file operations on the
> installation machine. You must restart your computer before running
> setup".
>
> I've restarted my PC and restarted the setup program numerous times, but
> always get the same message.
>
> I do have SQL Server 2005 Express installed - would this make a difference
> to installing SQL 2000 (or components thereof)? Perhaps it is causing
> conflicts? I'm trying to install only the 'client tools' (as per advice
> from my host) so I can interface with their db server (Sql Server 2000)
> using the Enterprise Manager.
>
> Is there any issue with connecting with the Management Studio in SQL
> Server Express 2005, to a SQL Server 2000?
> I have managed to do so, but my host thinks there may be compatibility
> issues.
>
>

Thanks, your solution worked.
Andrew

"Jasper Smith" <jasper_smith9@hotmail.com> wrote in message
news:eX4HdBetHHA.2124@TK2MSFTNGP02.phx.gbl...
> Have a look at the following KB article (specifically step 2)
> http://support.microsoft.com/default.aspx?id=312995
>
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> http://sqlblogcasts.com/blogs/sqldbatips
>
>
> "Andrew Murray" <adKillSpammersmurray@iinet.net.au> wrote in message
> news:O2i7dmStHHA.4952@TK2MSFTNGP04.phx.gbl...
>>I have the evaluation edition of SQL Server 2000 and trying to install the
>>'client tools' namely the Enterprise Manager on my PC. I'm getting an
>>error when running the installation program. I get as far as choosing the
>>location to install to, and when I click "Next" I get the error:
>>
>> "A previous program installation created pending file operations on the
>> installation machine. You must restart your computer before running
>> setup".
>>
>> I've restarted my PC and restarted the setup program numerous times, but
>> always get the same message.
>>
>> I do have SQL Server 2005 Express installed - would this make a
>> difference to installing SQL 2000 (or components thereof)? Perhaps it is
>> causing conflicts? I'm trying to install only the 'client tools' (as
>> per advice from my host) so I can interface with their db server (Sql
>> Server 2000) using the Enterprise Manager.
>>
>> Is there any issue with connecting with the Management Studio in SQL
>> Server Express 2005, to a SQL Server 2000?
>> I have managed to do so, but my host thinks there may be compatibility
>> issues.
>>
>>
>
>