Showing posts with label msde2000. Show all posts
Showing posts with label msde2000. Show all posts

Friday, March 30, 2012

MSDE SP4 Upgrade problem

Recently when I try to upgrade my current MSDE2000 (SP3a) to SP4 in Windows
XP – SP2, the system just keep on failing me. He is the scenario:
1. Download the MSDE 2000 SP4 from Microsoft site
2. Extract the MSDE SP4
3. Run the following command via command prompt or batch file:
echo off
echo "Start to Upgrade MSDE SP4 ... "
setup.exe /UPGRADESP SQLRUN INSTANCENAME=JSNG SECURITYMODE=SQL
UPGRADEUSER=sa UPGRADEPWD=Th3B3st /L*v c:\MSDE_Log.log
echo "SP4 Upgrade Process completed!"
4. Once the above batch file was run, the standard configuration
screen (gathering information) will be triggered
5. However, after a while the installation will just stopped (before
the title of the windows has changed to show the instance name)
6. When I checked on the verbose log, I have found out that the failure
of the installation is due to the system has failed to configure the server.
PFB for the last few rows of the verbose log:
=== Logging stopped: 8/22/2006 17:36:49 ===
MSI (c) (90:88) [17:36:49:865]: Note: 1: 1729
MSI (c) (90:88) [17:36:49:865]: Product: Microsoft SQL Server Desktop Engine
-- Configuration failed.
MSI (c) (90:88) [17:36:49:865]: Grabbed execution mutex.
MSI (c) (90:88) [17:36:49:865]: Cleaning up uninstalled install packages, if
any exist
MSI (c) (90:88) [17:36:49:865]: MainEngineThread is returning 1603
=== Verbose logging stopped: 8/22/2006 17:36:49 ===
7. Since this is the configuration error, so I have tried to locate
the cnfgsvr.out and hope to get some hints from there, but unfortunately the
config server file is still not updated yet where it still keep the old info
during the installation of MSDE 2000 SP3a.
8. When I try to locate the error (value = 3), I have found out the
its due to the system has detected blank sa password, but I am sure that the
password that I has provided is correct. PFB for the error recorded in the
verbose log:
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{EFB70B01-B1F3-4960-AB69-4A280084A60C}
Starting custom action UpgDetectBlankSaLogin()
Entering Function MyMsiEvaluateCondition
MsiEvaluateCondition for VersionNT returned TRUE
End Function MyMsiEvaluateCondition
An error was encountered during connection to server: 1
Ending custom action UpgDetectBlankSaLogin().
Action ended 9:37:45:
UpgDetectBlankSaLogin.2D02443E_7002_4C0B_ABC9_EAB2 C064397B. Return value 3.
Action ended 9:37:45: INSTALL. Return value 3.
Property(S): UpgradeCode = {421A321C-2214-4713-B3EB-253F2FBCCE49}
Property(S): SqlDataDir = C:\Program Files\Microsoft SQL Server\
Property(S): SqlProgramDir = C:\Program Files\Microsoft SQL Server\
Property(S): SqlInstanceName = EASYSHIP
Property(S): SqlSecurityMode = SQL
Property(S): SqlSa...
Property(S): SqlDisableNetworkProtocols = 0
Property(S): SqlDoUpgrade = 1
Property(S): ProductName = Microsoft SQL Server Desktop Engine (EASYSHIP)
Property(S): VersionNT = 501
Property(S): ALLUSERS = 1
Property(S): ARPNOMODIFY = 1
Property(S): DefaultUIFont = Tahoma8
9. I have even try to use a different command line and yet it failed.
PFB for the alternative command line that I have used:
setup.exe /UPGRADESP SQLRUN INSTANCENAME=JSNG SECURITYMODE=SQL SAPWD=Th3B3st
/L*v
10. I have tried the same in a Windows 2000 Std Server - SP4, and yet it
failed.
During my testing, I have closed down all SQL related activities, including
the followings:
1. Microsoft OutLook
2. SQL Agent Service
3. Easyship Scheduler
But I still experience the above.
I have tried to re-run the same in one of my fresh Windows XP (in virtual
machine), and everything just works fine. Could it be any unclean registry
entry that fail this? Or could it be any software component that is
incompatible with this? Does it have anything to do with the version of MS
Installer being installed in my machine? FYI, I have installed the latest MS
Installer 3.1 before when I tried to install SQL Express, however after I
have remove it, the problem still persist.
Do you have any idea on the above? PFA for the versbose log.
HI,
I am also facing the same issue in my domain.
Unable to find much details.
Is your issue resolved?If yes kindly help me out.
Thanks in advance,
Harish K
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
|||HI,
I am also facing the same issue in my domain.
Unable to find much details.
Is your issue resolved?If yes kindly help me out.
Thanks in advance,
Harish K
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
sql

Wednesday, March 28, 2012

MSDE setup / installation

Hi
I am a beginner in this, may I asked some basic question
1. do I need any version of MSDE before installing MSDE2000 sp3?
2. I have an environment with two servers, each of these has a web server
with a DC running, and I have written a .NET application for administrator
to maintain user a/c in this domain. Now, I would like to use a MSDE server
for keeping logs.
Can I have an installation of MSDE on each of these servers such that the
two installation would synchronize on a periodic basis?
Please note that changes of records are expected on either of these servers!
TIA
hi,
dl wrote:
> Hi
> I am a beginner in this, may I asked some basic question
> 1. do I need any version of MSDE before installing MSDE2000 sp3?
no, you can just directly install MSDE Rel A (sp3a level) and upgrade to sp4
via http://www.microsoft.com/sql/downloads/2000/sp4.mspx MSDE package (or
directly install MSDE at the sp4 level... but currently it's not clear to me
if general users not owning a "required" SQL Server license as per
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp are eligile for
direct sp4 use... just a note, Microsoft representatives already exposed a
refresh of MSDE Rel A updated at sp4 level will be made available...)

> 2. I have an environment with two servers, each of these has a web
> server with a DC running, and I have written a .NET application for
> administrator to maintain user a/c in this domain. Now, I would like
> to use a MSDE server for keeping logs.
> Can I have an installation of MSDE on each of these servers such that
> the two installation would synchronize on a periodic basis?
> Please note that changes of records are expected on either of these
> servers!
>
yes, you can install MSDE on both servers, and even provide a replication
paht between the 2 MSDE instances, as MSDE supports merge and snapshot
replication
(http://msdn.microsoft.com/library/de...lover_694n.asp)
but, unfortunately, without Enterprise Manager tool it will be not trivial
to set it up
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||In message <ei6anK5cFHA.3488@.tk2msftngp13.phx.gbl>, dl@.?.?.invalid
writes
>Hi
>I am a beginner in this, may I asked some basic question
>1. do I need any version of MSDE before installing MSDE2000 sp3?
If your download file for sp3 is about 60-70mb then know it will install
MSDE at the same time if not present. You would be better using the
MSDERelA package (which includes sp3).

>2. I have an environment with two servers, each of these has a web server
>with a DC running, and I have written a .NET application for administrator
>to maintain user a/c in this domain. Now, I would like to use a MSDE server
>for keeping logs.
>Can I have an installation of MSDE on each of these servers such that the
>two installation would synchronize on a periodic basis?
>Please note that changes of records are expected on either of these servers!
Yes. You can have as many instances per server as you like (well up to
16 anyway - I think thats the right number). Yes you can use DTS to
keep the servers synchronised (you would normally pick one as the master
however). Just make sure your database and table design are decent (ie:
Primary Keys etc).
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com

Monday, March 26, 2012

MSDE refuses to install

I have installed MSDE2000 on several new laptops and wrokstations but for
some reason, I have one new sony vaio that the msde installer gets so far
and then rolls itself back. The event viewer just says that it failed to
install event ID 11708. I am logged in with administrator account and have
shared both hard drives. I am at loss for an answer.
Robert woke up on Fri, 10 Sep 2004 20:39:11 GMT and sat in
microsoft.public.sqlserver.msde writing in message
news:O6NU7Y3lEHA.2680@.TK2MSFTNGP15.phx.gbl

> I have installed MSDE2000 on several new laptops and wrokstations but
> for some reason, I have one new sony vaio that the msde installer gets
> so far and then rolls itself back. The event viewer just says that it
> failed to install event ID 11708. I am logged in with administrator
> account and have shared both hard drives. I am at loss for an answer.
I just downloaded the newer version MSDE2000A and it installed when I
provided the SAPWD.

Wednesday, March 21, 2012

MSDE or SQL 2005 Express?

Which one would you choose for a small application that needs to go in
production NOW? SQL 2005 Express is supposed to be the successor of MSDE
2000, but is it stable enough for production?
NOW - I would look at MSDE.
If you can wait until Nov 7th, you might consider SqlExpress.
SqlExpress seems quite stable, but I find it hard to justify going into
production with it when we are so close to the release date. Also, depending
on whether or not you are also running any v2.0 .NET apps, you could have
issues with similar but still different versions of the CLR. Lastly, do you
qualify for the Go Live License and does that license apply to SqlExpress or
only Visual Studo?
-Andrew
"JDG" <JDG@.discussions.microsoft.com> wrote in message
news:745B1A5C-F8B1-47C7-BD19-E1F254231D7B@.microsoft.com...
> Which one would you choose for a small application that needs to go in
> production NOW? SQL 2005 Express is supposed to be the successor of MSDE
> 2000, but is it stable enough for production?
>
|||Thanks Andrew. Three weeks sounds manageable... Is this a published date?
I've registered for the Go Live license, including SQLExpress.
"Andrew Robinson" wrote:

> NOW - I would look at MSDE.
> If you can wait until Nov 7th, you might consider SqlExpress.
> SqlExpress seems quite stable, but I find it hard to justify going into
> production with it when we are so close to the release date. Also, depending
> on whether or not you are also running any v2.0 .NET apps, you could have
> issues with similar but still different versions of the CLR. Lastly, do you
> qualify for the Go Live License and does that license apply to SqlExpress or
> only Visual Studo?
> -Andrew
>
> "JDG" <JDG@.discussions.microsoft.com> wrote in message
> news:745B1A5C-F8B1-47C7-BD19-E1F254231D7B@.microsoft.com...
>
>

MSDE ON WINDOWS XP - Unable to determine system default collation.

Please help Me,
I need Install MSDE2000 On Windows XP, but this message is show in the proces
Product: Microsoft SQL Server Desktop Engine -- Unable to determine system default collation.Are you running Windows XP Pro or Home?|||Please help Me,

I need Install MSDE2000 On Windows XP PRO, but this message is show in the proces

Product: Microsoft SQL Server Desktop Engine -- Unable to determine system default collation.|||Have you tried to logon with a user with administrator privileges?|||Originally posted by Dynatoz
Have you tried to logon with a user with administrator privileges?

Yes, I using the Administrator Acount

Friday, March 9, 2012

MSDE installation failure

Like a lot of other people I am having problems installing MSDE2000 on
W2k3 server. I have edited the registry by dleting instnace of SQL,
deleted program File listing of SQL, etc. I ran install with following
command:
c:\sql2ksp3\msde\Setup.exe SAPWD=Whois2005 /L*v C:\MSDELog.log
INSTANCENAME=ASTRO DISABLENETWORKPROTOCOLS=0 diablerollback=1
Below is the final error in cnfgsvr.out:
Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
and the return value 3 errors in MSDELog.log (3 total errors):
Starting custom action ConfigServer
Executing "c:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "ASTRO" -Q
"SQL_Latin1_General_CP1_CI_AS""
MSI (c) (F8:44) [10:44:04:515]: Font created. Charset: Req=0, Ret=0,
Font: Req=MS Shell Dlg, Ret=MS Shell Dlg
1) Setup failed to configure the server. Refer to the server error logs
and setup error logs for more information.
MSI (s) (20!DC) [10:44:07:000]: Product: Microsoft SQL Server Desktop
Engine -- Setup failed to configure the server. Refer to the server
error logs and setup error logs for more information.
Action ended 10:44:07: InstallFinalize. Return value 3.
2) Start custom action DeferProperties
Defer Properties returns: 0
MSI (s) (20:30) [10:44:17:406]: Executing op:
End(Checksum=0,ProgressTotalHDWord=0,ProgressTotal LDWord=0)
MSI (s) (20:30) [10:44:17:406]: Error in rollback skipped.Return: 5
MSI (s) (20:30) [10:44:17:406]: No System Restore sequence number for
this installation.
MSI (s) (20:30) [10:44:17:406]: Unlocking Server
MSI (s) (20:30) [10:44:17:406]: PROPERTY CHANGE: Deleting UpdateStarted
property. Its current value is '1'.
Action ended 10:44:17: INSTALL. Return value 3.
3) MSI (s) (20:30) [10:44:17:625]: MainEngineThread is returning 1603
MSI (s) (20:CC) [10:44:17:625]: Destroying RemoteAPI object.
MSI (s) (20:AC) [10:44:17:625]: Custom Action Manager thread ending.
MSI (c) (F8:54) [10:44:17:656]: Back from server. Return value: 1603
MSI (c) (F8:54) [10:44:17:656]: Decrementing counter to disable
shutdown. If counter >= 0, shutdown will be denied. Counter after
decrement: -1
Action ended 10:44:17: INSTALL. Return value 3.
If you need the full logs I can post them as well. This all came about
by uninstalling Veritas (to move it from the C drive to F drive)
because of upcoming space constraints. The C drive at present has 948MB
of free space. The Veritas MSDE install fails as well.
hi,
Astro wrote:
> 1) Setup failed to configure the server. Refer to the server error
> logs and setup error logs for more information.
this exception is usually related to a dirty situation, where the system has
not been properly cleaned from previous MSDE installation(s)
http://support.microsoft.com/default...99&Product=sql
it has been sometime reported to be related with MDAC problems.. try
repairing it like
first, locate the mdac.inf file in c:\windows\inf right click and install
when prompted for a location, point to c:\windows\servicepackfiles\i386 then
when prompted for the os CD load it..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrew,
I have tried that. I have deleted program folders and run through the
removal of MSDE manually in the registry (KB816499) and the
installation described above still fails. I have reinstalled MDAC as
you proposed to no avail. Is there any thing else I can try. I will be
on site at 3pm CST USA. Would loading the SBS 2003 SQL client tools be
of any use? I am at wits end.
|||hi,
Astro wrote:
> Andrew,
> I have tried that. I have deleted program folders and run through the
> removal of MSDE manually in the registry (KB816499) and the
> installation described above still fails. I have reinstalled MDAC as
> you proposed to no avail. Is there any thing else I can try.
actually not, AFAIK...

>I will be
> on site at 3pm CST USA. Would loading the SBS 2003 SQL client tools be
> of any use? I am at wits end.
you are not legitimated to use SQL Server Client Tools for MSDE use in
production servers... and installing them has nothing to deal with the
server installation...
are you sure you properly cleaned the file system and the registry?
try perhaps installing MSDE from the service pack 4 package,
http://www.microsoft.com/sql/downloads/2000/sp4.mspx ... this package
includes the MDAC stack at 2.8 sp2 level..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE Installation fails

When trying to install MSDE2000 in an XP Home edition machine the
installation fails (progress bar almost gets at the end but it then rolls
back) with no message.
There is should be a log file but I do not know how to get. Also where can I
find descriptions of the error messages?
In a previous message a similar problem was solved by installing File and
Print sharing. Unfortunately I do not know what this means.
Any ideas?
Thanks
Yannis
hi Yannis,
"Yannis Makarounis" <Yannis.Makarounis@.ace-hellas.gr> ha scritto nel
messaggio news:e%23gecCVoEHA.800@.TK2MSFTNGP14.phx.gbl
> When trying to install MSDE2000 in an XP Home edition machine the
> installation fails (progress bar almost gets at the end but it then
> rolls back) with no message.
> There is should be a log file but I do not know how to get. Also
> where can I find descriptions of the error messages?
> In a previous message a similar problem was solved by installing File
> and Print sharing. Unfortunately I do not know what this means.
> Any ideas?
> Thanks
> Yannis
open the control panel applet -> services... check the "Server" service is
running... this service allows file and pront sharing activities...
if not present, select your network connection properties... File and
Printer sharing for Microsoft network must be installed if not present..
when running the MSDE setup.exe, please add the
/L*v "c:\MsdeLog.txt"
parameter, in order to log the installation process to file, about 2mb, you
can later inspect for troubleshooting, looking for
RETURN VALUE 3
entries
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply