MSDE 2000 SP3 fails to install

MSDE 2000 SP3 fails to install on a windows 2000 terminal server. The error
message I get is "MSDE 200 SP3 installation failed with exit code 1603" and
“A strong password is required for security reasons. Please use SAPWD switch
to supply the same. Refer to read me for more details. Setup will now exit.”
I have come across this once before and removed the server from the domain,
in this case that is not an option. I have denied the read right to the
default domain policy which is the only policy that is applying. Anybody have
any ideas on how I can install this.
hi bob,
bob wrote:
> MSDE 2000 SP3 fails to install on a windows 2000 terminal server. The
> error message I get is "MSDE 200 SP3 installation failed with exit
> code 1603" and "A strong password is required for security reasons.
> Please use SAPWD switch to supply the same. Refer to read me for more
> details. Setup will now exit." I have come across this once before
> and removed the server from the domain, in this case that is not an
> option. I have denied the read right to the default domain policy
> which is the only policy that is applying. Anybody have any ideas on
> how I can install this.
as indicated by the error description, you have to provide a strong password
for "sa" login as a parameter, in the form of
c:\...\>setup.exe ... SAPWD="your strong password" ...
all available parameters for the setup.exe bootstrap installer are provided
at
http://msdn.microsoft.com/library/de...stsql_84xl.asp
or, if you really are sure (please don't) you do not need a strong sa
password, you have to provide the
BLANKSAPWD=1
parameter
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea
I tried BLANKSAPWD=1 and I even tried setting a strong password, neither one
worked. Do you have any other suggestions?
"Andrea Montanari" wrote:

> hi bob,
> bob wrote:
> as indicated by the error description, you have to provide a strong password
> for "sa" login as a parameter, in the form of
> c:\...\>setup.exe ... SAPWD="your strong password" ...
> all available parameters for the setup.exe bootstrap installer are provided
> at
> http://msdn.microsoft.com/library/de...stsql_84xl.asp
> or, if you really are sure (please don't) you do not need a strong sa
> password, you have to provide the
> BLANKSAPWD=1
> parameter
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi Bob,
bob wrote:
> Andrea
> I tried BLANKSAPWD=1 and I even tried setting a strong password,
> neither one worked. Do you have any other suggestions?
>
can you please post your paramenters?
what kind of error do you get?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE - ADP Question

Hi,

After upsizing on MSDE, I created ADP on my terminal.

When the created ADP I need to copy to another user to get connected to MSDE hosted on my pc I followed these steps.

First I copied ADP to the user's pc and

1. Opened Administration Tools on user's pc
2. Clicked twice Data Source (ODBC) icon
3. Selected System DSN and clicked Add
4. Selected SQL Server (Last item) and Finish
5. Given new connection name (any name) in the field 'Name'. Description left empty. In Servaer, typed server name.
6. In the next page, I selected SQL Server Authentication and...

Here is my question:

Should I use at this step System Administrator's login id and password ?

OR

Should I use user's pc id and password ?

I tried both way. But login fails.

Where might have gone wrong? BTW, this the first user I trying on.

Any help would be highly appreviated.

With kind regards,

Ashfaquecreate a sql login in our MSDE using sp_addlogin and then use sp_adduser to grant them specific db access. see details in BOL. if you are using Wndows XP SP2 you may have to create an exception in the personal firewall r drop it altogether.|||Thanks Thrasymachus,

I would appreciate it very much if you could little bit in detail as I am new bee for this area.

With kind regards,

Ashfaque|||Do you have Books Online? If so (it's included free with SQL Server), open it up and go to the Index tab. Type in "logins-SQL Server" and start reading. It will give you more than enough information to accomplish this task. You can also type in the stored procedures he gave you to get syntax and usage information.|||oh why use the reference material. I drove for a couple of years without a license when I was a kid.|||Hi Guys,

No, I don't have Books Online..

Justi moving around with the help of you people...

I attached jpg image to give you a clear pic to know whats wrong..

With kind regards,

Ashfaque|||Hello Gentlemen,

I am still waiting for your valuable response..

With kind regards,

Ashfaque