Failed to install MSDE 2000a

I have been tring to install the MSDE 200Aon my marchine that is using
the command prompt.
this is the command that i was using:
(setup INSTANCENAME="SA" SECURITYMODE=SQL SAPWD="SqlAdmin1"
TARGETDIR="C:\" )
but it gave me the following error message;
(Go to the control panel to install and configure system components)
now i really dont know what to do from here can you advice me?
hi Tino,
Tino wrote:
> I have been tring to install the MSDE 200Aon my marchine that is using
> the command prompt.
> this is the command that i was using:
> (setup INSTANCENAME="SA" SECURITYMODE=SQL SAPWD="SqlAdmin1"
> TARGETDIR="C:\" )
> but it gave me the following error message;
> (Go to the control panel to install and configure system components)
> now i really dont know what to do from here can you advice me?
did you navigate and posittioned your command prompt window in the folder
hosting the setup.exe boostrap installer of MSDE?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply
sql

failed to create SQL Server Agent Multi_Server Admin

Failed at the last step

Prompt: Window NT User or Group '.\Administrator' not found?

I used this account log on SQL Server Agent, What's wrong with this?

My OS is windows2000 sp4, MSSQL is 2005 sp1

any idea? thanks

I tried to use another account to log on SQL Server Agent

and I found the SQL Server Agent service account no longer needs to be a member of the local Administrators group on the box great!

However still failed to create Multi_server admin,any idea ?|||

Have you set the encryption options as directed here?

http://msdn2.microsoft.com/en-us/library/ms365379.aspx

jkh

|||

nope,the registry subkey MsxEncryptChannelOptions' value is 2

I change this to 0, but still could not working

|||Did you change it to 0 on all systems?|||

I'm setting Master Server

do i also need to set this on all target server at the same time?

|||

Your hypothesis is correct.

It is the target server that initiates the job download, and so it is the target server that needs the crypto options set.

Let us know if this works out,

Thanks,

jkh

failed to create SQL Server Agent Multi_Server Admin

Failed at the last step

Prompt: Window NT User or Group '.\Administrator' not found?

I used this account log on SQL Server Agent, What's wrong with this?

My OS is windows2000 sp4, MSSQL is 2005 sp1

any idea? thanks

I tried to use another account to log on SQL Server Agent

and I found the SQL Server Agent service account no longer needs to be a member of the local Administrators group on the box great!

However still failed to create Multi_server admin,any idea ?|||

Have you set the encryption options as directed here?

http://msdn2.microsoft.com/en-us/library/ms365379.aspx

jkh

|||

nope,the registry subkey MsxEncryptChannelOptions' value is 2

I change this to 0, but still could not working

|||Did you change it to 0 on all systems?|||

I'm setting Master Server

do i also need to set this on all target server at the same time?

|||

Your hypothesis is correct.

It is the target server that initiates the job download, and so it is the target server that needs the crypto options set.

Let us know if this works out,

Thanks,

jkh

Faced unknown problems on SQL Server (Urgent)

Hi all,

I'm facing some unknown errors occured in SQL server. SQL server prompt out the errors and I'm aware when are those errors occur.

Server displayed the sentences as below which I do not have any idea with its.


1) xpstar.dll to execute extended stored procedure 'xp_MSADEnabled'
2) xpsqlbot.dll to execute extended stored procedure 'xp_qv'

Anyone has any idea on how to solve those problem or any idea how is it caused?

I'm very appreciate for any reply and thank you for helping!!The second one is normally found in SQL Server's errorlog. I am not sure about xp_MSADEnabled. Have you registered the SQL Server with AD in Enterprise Manager? These messages are normally recorded in the errorlog, and do not normally indicate a problem.|||Hi,

Thank you for reply, MCrowley.
Any idea or suggestion on how to make the SQL server can execute back
because the system users could not login because of the database.|||Depends on what is wrong. What error are the users getting?|||Hi,

Users could not login to the system since both the issues happened. :S