MSDE SetUp Hell: Newbie Help

I am trying to setup MSDE for the very first time. So I am absolutely a
newbie. I downloaded sql2ksp3 from microsoft site. I unpacked the file to a
folder and then clicked on setup.
I get an error message about using the command line to supply a strong
password and the setup exits...
I use the command line to supply a password like
setup SAPWD="Pwd777b7" and then the setup seems to install or change some
files.
I click on the setup again and I get an error an invalid Instance name name
error. I have read and reread the (from a first user's point of view) the
very unhelpful help file I download with MSDE setup.
I have been going back and forth on this. Anyone know what's wrong... Anyone
know of a URL where I can find a step-by-step method of installing MSDE.
Thanks in advance
hi,
JP Bless wrote:
> I am trying to setup MSDE for the very first time. So I am absolutely
> a newbie. I downloaded sql2ksp3 from microsoft site. I unpacked the
> file to a folder and then clicked on setup.
> I get an error message about using the command line to supply a strong
> password and the setup exits...
> I use the command line to supply a password like
> setup SAPWD="Pwd777b7" and then the setup seems to install or change
> some files.
you should have a new default instace of MSDE installed, with no network
protocols enabled and allowing only Windows authenticated connections..
please verify using the Windows Services applet (control panel->management
tools->services) you have a MSSQLSERVER and SQLSERVERAGENT entry for the
related services...

> I click on the setup again and I get an error an invalid Instance
> name name error.
it failed as you tried that way to install a second default instance of MSDE
and ony 1 default instace is allowed... you can install other (up to 15, for
a max of 16 instances in total) named instances providing the additional
parameter
INSTANCENAME=whatever_name

>I have read and reread the (from a first user's
> point of view) the very unhelpful help file I download with MSDE
> setup.
> I have been going back and forth on this. Anyone know what's wrong...
> Anyone know of a URL where I can find a step-by-step method of
> installing MSDE.
>
if you can read/understand french,
http://perso.wanadoo.fr/jm.doudoux/m...msde/msde.htm, if you can
read/understand italian, http://www.visual-basic.it/articoli/scMsde01.htm,
but I do not know english sites
anyway, you should not just click on the setup.exe boostrap installer but
call it from a command window and provide all the required parameters,
usually (depending on your needs) in the form of
c:\...\>setupe.exe INSTANCENAME=whatever SAPWD=your_strong_pwd
SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 /L*v "C:\MSDELOG.txt"
this typical command line will install a named instance named "whatever",
with "sa" login pwd = "your_strong_pwd", enabling SQL Server standard
connections (mixed mode authentication, allowing both integrated security a
standard SQL Server connections), enabling network protocols and thus
enabling remote connections and finally enabling verbose logging of the
installation process to a text file of about 2mb for a successfull
installation you can inspect in case of troubles for
RETURN VALUE 3
entries... this entries are localized in the particular MSDE localized
flavour, and about 10/15 lines before each entry some (sometime cryptic)
description of the problem will be reported...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea. It helped. Now I am done with with installation, I guess I
just cleared the first hurdle. My next task is to know how to add tables and
queries. I see there is no GUI (like Enterprise Manager) in the full/server
version, to administer/add table/Queries etc. Any tips where to begin?
Once again, thanks for the help, I really appreciate it.
Joe
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3rv3laFloeqnU1@.individual.net...
> hi,
> JP Bless wrote:
> you should have a new default instace of MSDE installed, with no network
> protocols enabled and allowing only Windows authenticated connections..
> please verify using the Windows Services applet (control panel->management
> tools->services) you have a MSSQLSERVER and SQLSERVERAGENT entry for the
> related services...
> it failed as you tried that way to install a second default instance of
MSDE
> and ony 1 default instace is allowed... you can install other (up to 15,
for
> a max of 16 instances in total) named instances providing the additional
> parameter
> INSTANCENAME=whatever_name
>
> if you can read/understand french,
> http://perso.wanadoo.fr/jm.doudoux/m...msde/msde.htm, if you can
> read/understand italian, http://www.visual-basic.it/articoli/scMsde01.htm,
> but I do not know english sites
> anyway, you should not just click on the setup.exe boostrap installer but
> call it from a command window and provide all the required parameters,
> usually (depending on your needs) in the form of
> c:\...\>setupe.exe INSTANCENAME=whatever SAPWD=your_strong_pwd
> SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 /L*v "C:\MSDELOG.txt"
> this typical command line will install a named instance named "whatever",
> with "sa" login pwd = "your_strong_pwd", enabling SQL Server standard
> connections (mixed mode authentication, allowing both integrated security
a
> standard SQL Server connections), enabling network protocols and thus
> enabling remote connections and finally enabling verbose logging of the
> installation process to a text file of about 2mb for a successfull
> installation you can inspect in case of troubles for
> RETURN VALUE 3
> entries... this entries are localized in the particular MSDE localized
> flavour, and about 10/15 lines before each entry some (sometime cryptic)
> description of the problem will be reported...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Joe,
JP Bless wrote:
> Thanks Andrea. It helped. Now I am done with with installation, I
> guess I just cleared the first hurdle. My next task is to know how to
> add tables and queries. I see there is no GUI (like Enterprise
> Manager) in the full/server version, to administer/add table/Queries
> etc. Any tips where to begin?
>
my tip is to use the prj you can find at the link following my sign., which
provides free a user interface similar to Enterprise Manager written in vb6
on top of SQL-DMO object model as long as a lot of dynamic SQL :D, but I'm
deeply involved in that advice :D
you have further choices, both commercial and free at
http://www.microsoft.com/sql/msde/partners and
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks a million... I appreciate the help. I will look at the sites and
tools.
Once again thanks.
Joe
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3rvco3FkpmcvU1@.individual.net...
> hi Joe,
> JP Bless wrote:
> my tip is to use the prj you can find at the link following my sign.,
which
> provides free a user interface similar to Enterprise Manager written in
vb6
> on top of SQL-DMO object model as long as a lot of dynamic SQL :D, but I'm
> deeply involved in that advice :D
> you have further choices, both commercial and free at
> http://www.microsoft.com/sql/msde/partners and
> http://www.aspfaq.com/show.asp?id=2442
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

MSDE Setup -- Wheres the Server?

I am using VB.net to build ASP.net pages. I finally decided it was time to start using SQL server based code. So, I installed MSDE...or so I thought.

I have the server Icon in the bottom systray and it's green and seems to be running.

I have been able to use Microsoft Access' Database Upgrade Wizard to create BB.adp file.

An in VB.net I see a master.dbo connection in Server Explorer.

But I can't figure out how to access the database via the SQL server. When I right click on Server Explorer...the Create a New SQL database menu item is greyed out.

My concern is that my installation is not complete and/or I don't know how to locate and verify the server.

Any help would be appreciated. ThanksMSDN link http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msderoadmap.asp to run thru the details.

MSDE service stops and does not restart, it takes reboot to restar

Dears,
We have a problem with MSDE 2000 installed on win2003, the services get
stoped after some time and it does not restart mannual , it gets start only
after we reboot the system.
Advice us some solutions for the same.
Thanks in Advance.
Dinesh Bhandare.
Hi Dinesh,
If it won't start, there should be something in the system event log to give
you a hint.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Dinesh Bhandare" <DineshBhandare@.discussions.microsoft.com> wrote in
message news:02550A8E-80EC-4FBB-8197-58B0E435FCA4@.microsoft.com...
> Dears,
> We have a problem with MSDE 2000 installed on win2003, the services get
> stoped after some time and it does not restart mannual , it gets start
> only
> after we reboot the system.
> Advice us some solutions for the same.
> Thanks in Advance.
> Dinesh Bhandare.
>
sql

MSDE Reboot Question (2 parts)

1) When I install and MSDE instance for the first time on a machine,
the install states that I must reboot the machine. However if I
manually start the instance, then my programs can access that instance
without a reboot.
2) If I uninstall the instance done in 1 above, through the Add/Remove
programs process, then subsequent installs of the same instance do not
prompt for a reboot.
So my basic question is:
Is a reboot REALLY necessary and if I manually (or programmatically)
start the instance? If a reboot is NOT really necessary, is there a
command line option that will keep that prompt from being displayed?
TIA for all replies
Wardell Castles
hi Wardell,
"Wardell Castles" <wardellcastles@.hotmail.com> ha scritto nel messaggio
news:65f20689.0412020822.1f340d53@.posting.google.c om
> 1) When I install and MSDE instance for the first time on a machine,
> the install states that I must reboot the machine. However if I
> manually start the instance, then my programs can access that instance
> without a reboot.
> 2) If I uninstall the instance done in 1 above, through the Add/Remove
> programs process, then subsequent installs of the same instance do not
> prompt for a reboot.
> So my basic question is:
> Is a reboot REALLY necessary and if I manually (or programmatically)
> start the instance? If a reboot is NOT really necessary, is there a
> command line option that will keep that prompt from being displayed?
> TIA for all replies
> Wardell Castles
usually a reboot is required to fullfill and commit all COM pending
registrations and services setting... and, when prompted, it's usually a
good idea to do it...
I do think that Windows Installer support a REBOOT=ReallySuppress
declaration, but I never used it... please have a look at
http://tinyurl.com/3tx4a
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

MSDE on win98 / WinME

I have a lot of problems installing MSDE on a Win98 and WinME computer.
Most of the time SQL Server will not start.
If I am lucky and SQL Server will start I can not create a Database.
It will pop up a message 42000 18452.
Any ideas how to solve this?
hi Peter,
Peter Herijgers wrote:
> I have a lot of problems installing MSDE on a Win98 and WinME
> computer. Most of the time SQL Server will not start.
> If I am lucky and SQL Server will start I can not create a Database.
> It will pop up a message 42000 18452.
> Any ideas how to solve this?
as per
http://msdn.microsoft.com/library/de...rview_74vn.asp ,
MSDE should be supported on Win98/ME, but actually I never installed it on
that platform...
what is the "verbose" message you got along with the 42000 exception?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||If have installed WinME on a brand new computer with all the latest updates.
Installing MSDE is going well but if I want to access the database the
following error appears:
SQL Server Error: SQL State: 42000, SQL Error Code: 18452
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
MSDTC and SQL Server Agent are turned off.
SQL Server is turned on.
I installed MSDE with the following parameters:
[OPTIONS]
INSTANCENAME="TEST" SECURITYMODE=SQL SAPWD="QEW624gHHF6" /L*v C:/MSDELog.log
Thanks
"Andrea Montanari" wrote:

> hi Peter,
> Peter Herijgers wrote:
> as per
> http://msdn.microsoft.com/library/de...rview_74vn.asp ,
> MSDE should be supported on Win98/ME, but actually I never installed it on
> that platform...
> what is the "verbose" message you got along with the 42000 exception?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||BTW
The password for login on ME is different then the MSDE password.
I don't know if this would cause any problems.
"Peter Herijgers" wrote:
[vbcol=seagreen]
> If have installed WinME on a brand new computer with all the latest updates.
> Installing MSDE is going well but if I want to access the database the
> following error appears:
> SQL Server Error: SQL State: 42000, SQL Error Code: 18452
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> MSDTC and SQL Server Agent are turned off.
> SQL Server is turned on.
> I installed MSDE with the following parameters:
> [OPTIONS]
> INSTANCENAME="TEST" SECURITYMODE=SQL SAPWD="QEW624gHHF6" /L*v C:/MSDELog.log
> Thanks
>
> "Andrea Montanari" wrote:
|||hi Peter,
Peter Herijgers wrote:
> If have installed WinME on a brand new computer with all the latest
> updates. Installing MSDE is going well but if I want to access the
> database the following error appears:
> SQL Server Error: SQL State: 42000, SQL Error Code: 18452
> Login failed for user '(null)'. Reason: Not associated with a trusted
> SQL Server connection.
are you mixing up trusted connection with user defined credentials for
login?
how and with what tool are you trying to connect to the MSDE instance?
if you use oSql.exe, the command line tool provided with MSDE, you have 2
different ways to connect..
specifying a trusted WinNT connection,
c:\...\>osql.exe -E -S(Local)
or with a standard SQL Server authenticated connection,
c:\..\>osql.exe -Usa -Pyourpwd -S(Local)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||hi Again,
BTW, can you please verify the mixed mode authentication is enabled?..
run regsvr32.exe, locate the registry "LoginMode" key as indicated in
http://support.microsoft.com/default...b;en-us;285097 and verify
it's value is 2
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I recently installed quite a few MSDE (SP3) on laptops for one of my apps
(Win2K and WinXP SP2). I found that the SQL Security was not enabled in
spite if including "SECURITYMODE=SQL" in setup command. I did not spend time
to figure it out why. I simply went to Windows Registry to manually enable
SQL Security mode:
HKEY_LocalMachine->Software->Microsoft->MSSQLServer-MSSQLServer->LoginMode,
set it to 2.
This will enable SQL Security mode, which is used for Win9x & ME.
"Peter Herijgers" <PeterHerijgers@.discussions.microsoft.com> wrote in
message news:C9EFFF51-4EA8-4F58-9625-812852BAE099@.microsoft.com...[vbcol=seagreen]
> If have installed WinME on a brand new computer with all the latest
> updates.
> Installing MSDE is going well but if I want to access the database the
> following error appears:
> SQL Server Error: SQL State: 42000, SQL Error Code: 18452
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> MSDTC and SQL Server Agent are turned off.
> SQL Server is turned on.
> I installed MSDE with the following parameters:
> [OPTIONS]
> INSTANCENAME="TEST" SECURITYMODE=SQL SAPWD="QEW624gHHF6" /L*v
> C:/MSDELog.log
> Thanks
>
> "Andrea Montanari" wrote:
|||Maybe I have made a big mistake but it is running now.
On a WinXP machine I code the following (Delphi):
SQLConnection.Close;
SQLConnection.Params.Clear;
SQLConnection.Params.Add('DriverName=MSSQL');
SQLConnection.Params.Add('HostName=MachineName\TES T');
SQLConnection.Params.Add('DataBase=Test');
SQLConnection.Params.Add('User_Name=MyName');
SQLConnection.Params.Add('Password=WhatEver');
SQLConnection.Params.Add('BlobSize=-1');
SQLConnection.Params.Add('ErrorResourceFile=');
SQLConnection.Params.Add('LocaleCode=0000');
SQLConnection.Params.Add('MSSQL TransIsolation=ReadCommited');
SQLConnection.Params.Add('OS Authentication=True');
I have changed this into:
SQLConnection.Close;
SQLConnection.Params.Clear;
SQLConnection.Params.Add('DriverName=MSSQL');
SQLConnection.Params.Add('HostName=MachineName\TES T');
SQLConnection.Params.Add('DataBase=Test');
SQLConnection.Params.Add('User_Name=sa');
SQLConnection.Params.Add('Password=WhatEver');
SQLConnection.Params.Add('BlobSize=-1');
SQLConnection.Params.Add('ErrorResourceFile=');
SQLConnection.Params.Add('LocaleCode=0000');
SQLConnection.Params.Add('MSSQL TransIsolation=ReadCommited');
SQLConnection.Params.Add('OS Authentication=False');
Now it works very find.
It runs on both Win98 and WinXP.
Thanks.
"Norman Yuan" wrote:

> I recently installed quite a few MSDE (SP3) on laptops for one of my apps
> (Win2K and WinXP SP2). I found that the SQL Security was not enabled in
> spite if including "SECURITYMODE=SQL" in setup command. I did not spend time
> to figure it out why. I simply went to Windows Registry to manually enable
> SQL Security mode:
> HKEY_LocalMachine->Software->Microsoft->MSSQLServer-MSSQLServer->LoginMode,
> set it to 2.
> This will enable SQL Security mode, which is used for Win9x & ME.
> "Peter Herijgers" <PeterHerijgers@.discussions.microsoft.com> wrote in
> message news:C9EFFF51-4EA8-4F58-9625-812852BAE099@.microsoft.com...
>
>
sql

MSDE login problem - Windows

I'm confused.
OS = Win XP Pro
I installed MSDE2000A on a new laptop using mixed security - Windows and
SQL. Everything went fine. At the time my everyday Windows user account wa
s
set up as a Windows (not SQL) administrator, so that I could get some other
software installed, too.
I subsequently changed my Windows user account to be a power user and NOT a
Windows administrator and now I cannot connect to MSDE with that Windows
account. If I switch the account back to Windows adminstrator all is well
with MSDE.
How can I coax MSDE to recognize this user account when it is no longer a
Windows administrator?Add your windows account to the Logins for MSDE. You are
getting in due to the default behavior of SQL Server adding
BUILTIN\Administrators as a login. That would include all
logins that are members of the local admins group.
You can add your login using sp_grantlogin. You can find
more information in books online.
-Sue
On Mon, 9 Jan 2006 08:07:04 -0800, "Duke Carey"
<DukeCarey@.discussions.microsoft.com> wrote:

>I'm confused.
>OS = Win XP Pro
>I installed MSDE2000A on a new laptop using mixed security - Windows and
>SQL. Everything went fine. At the time my everyday Windows user account w
as
>set up as a Windows (not SQL) administrator, so that I could get some other
>software installed, too.
>I subsequently changed my Windows user account to be a power user and NOT a
>Windows administrator and now I cannot connect to MSDE with that Windows
>account. If I switch the account back to Windows adminstrator all is well
>with MSDE.
>How can I coax MSDE to recognize this user account when it is no longer a
>Windows administrator?
>|||Sue -
Thanks for the guidance, but it looks like sp_grantlogin requires me to use
a domain name. The laptop is not part of a domain. Is there a workaround
for that?
"Sue Hoegemeier" wrote:

> Add your windows account to the Logins for MSDE. You are
> getting in due to the default behavior of SQL Server adding
> BUILTIN\Administrators as a login. That would include all
> logins that are members of the local admins group.
> You can add your login using sp_grantlogin. You can find
> more information in books online.
> -Sue
> On Mon, 9 Jan 2006 08:07:04 -0800, "Duke Carey"
> <DukeCarey@.discussions.microsoft.com> wrote:
>
>|||If you are logging into the laptop using a local account,
you would use:
MachineName\LoginName
-Sue
On Mon, 9 Jan 2006 16:29:02 -0800, "Duke Carey"
<DukeCarey@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sue -
>Thanks for the guidance, but it looks like sp_grantlogin requires me to use
>a domain name. The laptop is not part of a domain. Is there a workaround
>for that?
>"Sue Hoegemeier" wrote:
>|||Sue -
I logged in to the laptop as Administrator and was automatically logged in
to MSDE. Within MSDE I then ran EXEC sp_grantlogin 'pc_name\duke' and it ra
n
successfully.
However, after logging in as Duke *without Windows administrator rights* I
was still unable to login to MSDE.
I have to be so dense, but what am I missing?
Duke
"Sue Hoegemeier" wrote:

> If you are logging into the laptop using a local account,
> you would use:
> MachineName\LoginName
> -Sue
> On Mon, 9 Jan 2006 16:29:02 -0800, "Duke Carey"
> <DukeCarey@.discussions.microsoft.com> wrote:
>
>|||If the login is there, you should be able to at least
connect.
So when you log in as Duke and try to log in to MSDE, what
is the exact error message - all the details?
-Sue
On Thu, 19 Jan 2006 08:24:04 -0800, "Duke Carey"
<DukeCarey@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sue -
>I logged in to the laptop as Administrator and was automatically logged in
>to MSDE. Within MSDE I then ran EXEC sp_grantlogin 'pc_name\duke' and it r
an
>successfully.
>However, after logging in as Duke *without Windows administrator rights* I
>was still unable to login to MSDE.
>I have to be so dense, but what am I missing?
>Duke
>"Sue Hoegemeier" wrote:
>|||Sue -
There are no error messages as such
What is happening is that the SQL Service Mgr in the systray shows an empty
circle. When I open it I have to type in the pc name and select SQL Server
as the service. It then shows that it is already running. When I go into
MSDE Manager (Vale Software's management tool), it shows me logged in as
guest. It also shows the database owner (there's only one user database so
far) as hp_notebook\duke and says that I do not have permisssion to access
that database
If I grant my Windows login Windows Administrator status, MSDE starts fine
and I log in to the MSDE as myself
I don't know enough to provide you more helpful information
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:1q00t11aka3drrkih9ev7rofpbidk5c6dr@.
4ax.com...
> If the login is there, you should be able to at least
> connect.
> So when you log in as Duke and try to log in to MSDE, what
> is the exact error message - all the details?
> -Sue
>|||Okay...so you get on the server but can't do anything in
that database or can't access the database.
Add your Duke login as a user in the database using
sp_grantdbaccess.
If you need that login to be able to do anything and
everything on the MSDE instance, you can add that login to
the sysadmins server role using:
EXEC sp_addsrvrolemember 'pc_name\duke', 'sysadmin'
-Sue
On Thu, 19 Jan 2006 19:02:51 -0500, "Duke Carey"
<dukecarey@.hotmail.com> wrote:

> When I go into
>MSDE Manager (Vale Software's management tool), it shows me logged in as
>guest. It also shows the database owner (there's only one user database so
>far) as hp_notebook\duke and says that I do not have permisssion to access
>that database|||Sue -
Thanks for sticking with me. It appears that things are working correctly
now.
EXEC sp_addsrvrolemember 'pc_name\duke', 'sysadmin' seems to have done the
trick.
"Sue Hoegemeier" wrote:

> Okay...so you get on the server but can't do anything in
> that database or can't access the database.
> Add your Duke login as a user in the database using
> sp_grantdbaccess.
> If you need that login to be able to do anything and
> everything on the MSDE instance, you can add that login to
> the sysadmins server role using:
> EXEC sp_addsrvrolemember 'pc_name\duke', 'sysadmin'
> -Sue
> On Thu, 19 Jan 2006 19:02:51 -0500, "Duke Carey"
> <dukecarey@.hotmail.com> wrote:
>
>|||Good to hear it's all working now - thanks for posting back!
-Sue
On Mon, 23 Jan 2006 06:31:04 -0800, "Duke Carey"
<DukeCarey@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sue -
>Thanks for sticking with me. It appears that things are working correctly
>now.
>EXEC sp_addsrvrolemember 'pc_name\duke', 'sysadmin' seems to have done the
>trick.
>
>"Sue Hoegemeier" wrote:
>

MSDE installation woes

I have tried 3 times to install MSDE on my laptop,
different problem each time. I have wiped the hard drive
and reinstalled XP sp2 to try again, downloaded MSDE 2000
rel A. Installed with the command Setup SAPWD="eight"
SECURITYMODE=SQL
COLLATION="SQL_Latin1_General_CP1_Cl_AS" /L*v c:\MSDE.log.
The installation just terminates abruptly. Search
for 'return value 3' turns up this:
An error was encountered during connection to server: 3
Ending custom action UpgDetectBlankSaLogin().
Action ended 9:19:42:
UpgDetectBlankSaLogin.2D02443E_7002_4C0B_ABC9_EAB2 C064397B
.. Return value 3.
Action ended 9:19:42: INSTALL. Return value 3.
Property(S): UpgradeCode = {421A321C-2214-4713-B3EB-
253F2FBCCE49}
Property(S): SqlCollation = SQL_Latin1_General_CP1_Cl_AS
Property(S): SqlDataDir = C:\Program Files\Microsoft SQL
Server\
Property(S): SqlProgramDir = C:\Program Files\Microsoft
SQL Server\
Property(S): SqlInstanceName = MSSQLSERVER
Property(S): SqlSecurityMode = SQL
Property(S): SqlSa...
Property(S): SqlDisableNetworkProtocols = 0
Property(S): VersionNT = 501
Property(S): ALLUSERS = 1
Property(S): ARPNOMODIFY = 1
I've lost a week on this, getting desparate!
Thanks, Brian
hi Brian,
"Brian" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:167e01c4b551$02b56fc0$a301280a@.phx.gbl
> I have tried 3 times to install MSDE on my laptop,
> different problem each time. I have wiped the hard drive
> and reinstalled XP sp2 to try again, downloaded MSDE 2000
> rel A. Installed with the command Setup SAPWD="eight"
> SECURITYMODE=SQL
> COLLATION="SQL_Latin1_General_CP1_Cl_AS" /L*v c:\MSDE.log.
> The installation just terminates abruptly. Search
> for 'return value 3' turns up this:
> An error was encountered during connection to server: 3
> Ending custom action UpgDetectBlankSaLogin().
> Action ended 9:19:42:
> UpgDetectBlankSaLogin.2D02443E_7002_4C0B_ABC9_EAB2 C064397B
> . Return value 3.
> Action ended 9:19:42: INSTALL. Return value 3.
> Property(S): UpgradeCode = {421A321C-2214-4713-B3EB-
> 253F2FBCCE49}
> Property(S): SqlCollation = SQL_Latin1_General_CP1_Cl_AS
> Property(S): SqlDataDir = C:\Program Files\Microsoft SQL
> Server\
> Property(S): SqlProgramDir = C:\Program Files\Microsoft
> SQL Server\
> Property(S): SqlInstanceName = MSSQLSERVER
> Property(S): SqlSecurityMode = SQL
> Property(S): SqlSa...
> Property(S): SqlDisableNetworkProtocols = 0
> Property(S): VersionNT = 501
> Property(S): ALLUSERS = 1
> Property(S): ARPNOMODIFY = 1
> I've lost a week on this, getting desparate!
> Thanks, Brian
the only info I've found are listed in
http://www.google.it/groups?as_q=Upg...&num=100&hl=it
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
|||try a stronger password than "eight." I had the same issue and the problem
is that rel A wants a secure SA password. It will reject a simple one and
you are left with the error saying there is no password, hence "Ending
custom action 'UpgDetectBlankSaLogin' "
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2tkeqmF21euj1U1@.uni-berlin.de...
> hi Brian,
> "Brian" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
> news:167e01c4b551$02b56fc0$a301280a@.phx.gbl
> the only info I've found are listed in
>
http://www.google.it/groups?as_q=Upg...&num=100&hl=it
> --
> 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
>

MSDE Installation

About a year or so ago, I had some dialog with this newsgroup about MSDE.
At that time, it seems that Microsoft or someone was making a free product
to make installations of MSDE a lot simpler. Has this been developed? I
mean no one wants to release a commerical product designed for SQL Server
among other DBs and MSDE for stand alone users and yet expect the user to be
smart enough to do much of anything in the setup. Has such a thing been
created?
I did quite a bit of research on it then, but am just now looking at the
issue afresh.
Thanks for any help,
Shane
What shall the installation do ? Something like creating a database,
creating tables, executing script for some filling tables. That works
allready, if you are developing with .NET just have a look at the Setup
Modules, these will help you further.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Shane Story" <shanesREMOVETHIS@.dv-corp.com> schrieb im Newsbeitrag
news:OYg$3dnSFHA.1232@.TK2MSFTNGP15.phx.gbl...
> About a year or so ago, I had some dialog with this newsgroup about MSDE.
> At that time, it seems that Microsoft or someone was making a free product
> to make installations of MSDE a lot simpler. Has this been developed? I
> mean no one wants to release a commerical product designed for SQL Server
> among other DBs and MSDE for stand alone users and yet expect the user to
> be smart enough to do much of anything in the setup. Has such a thing
> been created?
> I did quite a bit of research on it then, but am just now looking at the
> issue afresh.
> Thanks for any help,
> Shane
>
|||hi Shane,
Shane Story wrote:
> About a year or so ago, I had some dialog with this newsgroup about
> MSDE.
> At that time, it seems that Microsoft or someone was making a free
> product to make installations of MSDE a lot simpler. Has this been
> developed? I mean no one wants to release a commerical product
> designed for SQL Server among other DBs and MSDE for stand alone
> users and yet expect the user to be smart enough to do much of
> anything in the setup. Has such a thing been created?
> I did quite a bit of research on it then, but am just now looking at
> the issue afresh.
> Thanks for any help,
> Shane
do you mean
http://www.microsoft.com/downloads/d...displaylang=en ?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Could be, I just remember that I wanted to do mixed security and that
required some sort of INI file or something. At least I remember there were
some settings I needed to setup and unfortunately it would have been a bear
for the user. At the time I was trying to install MSDE on a network server
for a 5-10 user .NET application. I wanted to just ship a CD and things
install easily with a server setup and client setup, but at that time this
was terrible. I remember reading that Microsoft was working on a solution.
Maybe this was it.
Have you used it?
What does the group think about it?
Grazie, Ciao,
Shane
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3d98i0F6s6gdbU1@.individual.net...
> hi Shane,
> Shane Story wrote:
> do you mean
> http://www.microsoft.com/downloads/d...displaylang=en ?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Perhaps Andrea's post is the answer I was looking for. Please read my
response there and see if you have any further thoughts.
Thanks for responding.
Shane
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:OZkqVqqSFHA.204@.TK2MSFTNGP12.phx.gbl...
> What shall the installation do ? Something like creating a database,
> creating tables, executing script for some filling tables. That works
> allready, if you are developing with .NET just have a look at the Setup
> Modules, these will help you further.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Shane Story" <shanesREMOVETHIS@.dv-corp.com> schrieb im Newsbeitrag
> news:OYg$3dnSFHA.1232@.TK2MSFTNGP15.phx.gbl...
>
|||hi Shane,
> Have you used it?
> What does the group think about it?
never used.. in it's early stage it was not that good thing everyon
expected, but do not know about the RTM... I stay wit my vb6 based interface
:D

> Grazie, Ciao,
prego, ciao :D
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE install problems...log attached

I am trying to install MSDE desktop engine and I having the most
difficult time.
I installed it once and then tried uninstalling it while it was still
running. Half of it uninstalled the other half still being there. I
then could not reinstall or uninstall cause a the DLL kept running. I
booted in safe mode and uninstalled the rest of the engine folder.
I tried to reinstall and it kept rolling back. I then installed and
turned off rollback. It said my version of SQL server is corrupt and I
have to reinstall it. I deleleted the folder and tried to reinstall. It
now kicks out at the gathering information portion of the install.
Below is a copy of my log. can someone decifer it for me please...
=3D=3D=3D Verbose logging started: 10/31/2005 17:11:35 Build type: SHIP
UNICODE 2.00.2600.1106 Calling process:
C:\WINDOWS\System32\msiexec.exe =3D=3D=3D
MSI (c) (24:F0): Resetting cached policy values
MSI (c) (24:F0): Machine policy value 'Debug' is 0
MSI (c) (24:F0): ******* RunEngine:
******* Product: C:\sql2ksp3\MSDE\Setup\SqlRun01.msi
******* Action:
******* CommandLine: **********
MSI (c) (24:F0): Machine policy value 'DisableUserInstalls' is 0
MSI (c) (24:F0): SOFTWARE RESTRICTION POLICY: Verifying package -->
'C:\sql2ksp3\MSDE\Setup\SqlRun01.msi' against software restriction
policy
MSI (c) (24:F0): Note: 1: 2262 2: DigitalSignature 3: -2147287038
MSI (c) (24:F0): SOFTWARE RESTRICTION POLICY:
C:\sql2ksp3\MSDE\Setup\SqlRun01.msi is not digitally signed
MSI (c) (24:F0): SOFTWARE RESTRICTION POLICY:
C:\sql2ksp3\MSDE\Setup\SqlRun01.msi is permitted to run at the
'unrestricted' authorization level.
MSI (c) (24:F0): Cloaking enabled.
MSI (c) (24:F0): End dialog not enabled
MSI (c) (24:F0): Original package =3D=3D>
C:\sql2ksp3\MSDE\Setup\SqlRun01.msi
MSI (c) (24:F0): Package we're running from =3D=3D>
C:\DOCUME~1\518494\LOCALS~1\Temp\2bf23d.msi
MSI (c) (24:F0): APPCOMPAT: looking for appcompat database entry with
ProductCode '{E09B48B5-E141-427A-AB0C-D3605127224A}'.
MSI (c) (24:F0): APPCOMPAT: no matching ProductCode found in database.
MSI (c) (24:F0): Machine policy value 'TransformsSecure' is 0
MSI (c) (24:F0): User policy value 'TransformsAtSource' is 0
MSI (c) (24:F0): APPCOMPAT: looking for appcompat database entry with
ProductCode '{E09B48B5-E141-427A-AB0C-D3605127224A}'.
MSI (c) (24:F0): APPCOMPAT: no matching ProductCode found in database.
MSI (c) (24:F0): Transforms are not secure.
MSI (c) (24:F0): Note: 1: 2262 2: Control 3: -2147287038
MSI (c) (24:F0): Command Line: sa...
MSI (c) (24:F0): Product Code passed to Engine.Initialize: ''
MSI (c) (24:F0): Product Code from property table before transforms:
'{E09B48B5-E141-427A-AB0C-D3605127224A}'
MSI (c) (24:F0): Product Code from property table after transforms:
'{E09B48B5-E141-427A-AB0C-D3605127224A}'
MSI (c) (24:F0): Product not registered: beginning first-time install
MSI (c) (24:F0): Entering CMsiConfigurationManager::SetLastUsedSource.
MSI (c) (24:F0): User policy value 'SearchOrder' is 'nmu'
MSI (c) (24:F0): Adding new sources is allowed.
MSI (c) (24:F0): Package name extracted from package path:
'SqlRun01.msi'
MSI (c) (24:F0): Package to be registered: 'SqlRun01.msi'
MSI (c) (24:F0): Note: 1: 2262 2: AdminProperties 3: -2147287038
MSI (c) (24:F0): Machine policy value 'DisableMsi' is 0
MSI (c) (24:F0): Machine policy value 'AlwaysInstallElevated' is 0
MSI (c) (24:F0): User policy value 'AlwaysInstallElevated' is 0
MSI (c) (24:F0): Product installation will be elevated because user is
admin and product is being installed per-machine.
MSI (c) (24:F0): Running product
'{E09B48B5-E141-427A-AB0C-D3605127224A}' with elevated privileges:
Product is assigned.
MSI (c) (24:F0): TRANSFORMS property is now:
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\Application Data
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\Favorites
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\NetHood
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\My Documents
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\PrintHood
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\Recent
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\SendTo
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\Templates
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\All Users\Application Data
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\Local Settings\Application Data
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\My Documents\My Pictures
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\All Users\Start Menu\Programs\Administrative Tools
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\All Users\Start Menu\Programs\Startup
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\All Users\Start Menu\Programs
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\All Users\Start Menu
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\All Users\Desktop
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\Start Menu\Programs\Administrative Tools
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\Start Menu\Programs\Startup
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\Start Menu\Programs
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\Start Menu
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\Desktop
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\All Users\Templates
MSI (c) (24:F0): SHELL32::SHGetFolderPath returned: C:\WINDOWS\Fonts
MSI (c) (24:F0): Note: 1: 2898 2: MS Sans Serif 3: MS Sans Serif 4: 0
5: 16
MSI (c) (24:F0): MSCOREE not loaded loading copy from system32
MSI (c) (24:F0): Note: 1: 1402 2:
HKEY_CURRENT_USER\Software\Microsoft\MS Setup (ACME)\User Info 3: 2
MSI (c) (24:F0): Note: 1: 1402 2:
HKEY_CURRENT_USER\Software\Microsoft\MS Setup (ACME)\User Info 3: 2
=3D=3D=3D Logging started: 10/31/2005 17:11:35 =3D=3D=3D
MSI (c) (24:F0): Machine policy value 'DisableRollback' is 0
MSI (c) (24:F0): User policy value 'DisableRollback' is 0
MSI (c) (24:F0): Doing action: INSTALL
Action start 17:11:35: INSTALL.
MSI (c) (24:F0): UI Sequence table 'InstallUISequence' is present and
populated.
MSI (c) (24:F0): In client but switching to server to run
ExecuteSequence
MSI (c) (24:F0): Grabbed execution mutex.
MSI (c) (24:F0): Incrementing counter to disable shutdown. Counter
after increment: 0
MSI (c) (24:F0): Note: 1: 2262 2: Control 3: -2147287038
MSI (c) (24:F0): Switching to server: SA...
MSI (s) (70:B8): Resetting cached policy values
MSI (s) (70:B8): Machine policy value 'Debug' is 0
MSI (s) (70:B8): ******* RunEngine:
******* Product: C:\sql2ksp3\MSDE\Setup\SqlRun01.msi
******* Action: INSTALL
******* CommandLine: **********
MSI (s) (70:B8): Machine policy value 'DisableUserInstalls' is 0
MSI (s) (70:B8): Setting cached product context: User non-assigned for
product: 06C7E36CBE523D11E8AD000A9C118E5E
MSI (s) (70:B8): Using cached product context: User non-assigned for
product: 06C7E36CBE523D11E8AD000A9C118E5E
MSI (s) (70:B8): Setting cached product context: User non-assigned for
product: 1A934039E94B45A44A9913DB1C9AD15E
MSI (s) (70:B8): Using cached product context: User non-assigned for
product: 1A934039E94B45A44A9913DB1C9AD15E
MSI (s) (70:B8): Setting cached product context: User non-assigned for
product: 95C59463C9801D94DB51E9B58DD69C1A
MSI (s) (70:B8): Using cached product context: User non-assigned for
product: 95C59463C9801D94DB51E9B58DD69C1A
MSI (s) (70:B8): Setting cached product context: User non-assigned for
product: c3b9757207456944ebc6c07862471ff9
MSI (s) (70:B8): Using cached product context: User non-assigned for
product: c3b9757207456944ebc6c07862471ff9
MSI (s) (70:B8): Setting cached product context: machine assigned for
product: 069DB0F15256EEF45B7742377FF72177
MSI (s) (70:B8): Using cached product context: machine assigned for
product: 069DB0F15256EEF45B7742377FF72177
MSI (s) (70:B8): Setting cached product context: machine assigned for
product: 0B79C053C7D38EE4AB9A00CB3B5D2472
MSI (s) (70:B8): Using cached product context: machine assigned for
product: 0B79C053C7D38EE4AB9A00CB3B5D2472
MSI (s) (70:B8): Setting cached product context: machine assigned for
product: 0DEF1459F7230FD4B869FE75FE26F291
MSI (s) (70:B8): Using cached product context: machine assigned for
product: 0DEF1459F7230FD4B869FE75FE26F291
MSI (s) (70:B8): Setting cached product context: machine assigned for
product: 2C22E5E46831EA74E8ED23DDDCDC6635
MSI (s) (70:B8): Using cached product context: machine assigned for
product: 2C22E5E46831EA74E8ED23DDDCDC6635
MSI (s) (70:B8): Setting cached product context: machine assigned for
product: 47CB7D76FD8E1184B91406328A9CBBF3
MSI (s) (70:B8): Using cached product context: machine assigned for
product: 47CB7D76FD8E1184B91406328A9CBBF3
MSI (s) (70:B8): Setting cached product context: machine assigned for
product: 497CA84818B8A04418EA464733D75B72
MSI (s) (70:B8): Using cached product context: machine assigned for
product: 497CA84818B8A04418EA464733D75B72
MSI (s) (70:B8): Setting cached product context: machine assigned for
product: 68AB67CA000000000000068247A7ED10
MSI (s) (70:B8): Using cached product context: machine assigned for
product: 68AB67CA000000000000068247A7ED10
MSI (s) (70:B8): Setting cached product context: machine assigned for
product: 68AB67CA7DA73301B7440A0000000010
MSI (s) (70:B8): Using cached product context: machine assigned for
product: 68AB67CA7DA73301B7440A0000000010
MSI (s) (70:B8): Setting cached product context: machine assigned for
product: 8A0F841731866D117AB7000B0D410204
MSI (s) (70:B8): Using cached product context: machine assigned for
product: 8A0F841731866D117AB7000B0D410204
MSI (s) (70:B8): Setting cached product context: machine assigned for
product: 9040110900063D11C8EF10054038389C
MSI (s) (70:B8): Using cached product context: machine assigned for
product: 9040110900063D11C8EF10054038389C
MSI (s) (70:B8): Setting cached product context: machine assigned for
product: 9040150900063D11C8EF10054038389C
MSI (s) (70:B8): Using cached product context: machine assigned for
product: 9040150900063D11C8EF10054038389C
MSI (s) (70:B8): Setting cached product context: machine assigned for
product: 9040250900063D11C8EF10054038389C
MSI (s) (70:B8): Using cached product context: machine assigned for
product: 9040250900063D11C8EF10054038389C
MSI (s) (70:B8): Setting cached product context: machine assigned for
product: 9040EA0900063D11C8EF10054038389C
MSI (s) (70:B8): Using cached product context: machine assigned for
product: 9040EA0900063D11C8EF10054038389C
MSI (s) (70:B8): Setting cached product context: machine assigned for
product: AB4CD6A618FCA8641B528D4408C96335
MSI (s) (70:B8): Using cached product context: machine assigned for
product: AB4CD6A618FCA8641B528D4408C96335
MSI (s) (70:B8): Setting cached product context: machine assigned for
product: AC97FE678A6A4C14EA944EB90A57AF15
MSI (s) (70:B8): Using cached product context: machine assigned for
product: AC97FE678A6A4C14EA944EB90A57AF15
MSI (s) (70:B8): Setting cached product context: machine assigned for
product: B2129F0245AAA384387D83CBBBFCBAFC
MSI (s) (70:B8): Using cached product context: machine assigned for
product: B2129F0245AAA384387D83CBBBFCBAFC
MSI (s) (70:B8): Setting cached product context: machine assigned for
product: B2D1BCADB2B1DA944937DB84F3FA9333
MSI (s) (70:B8): Using cached product context: machine assigned for
product: B2D1BCADB2B1DA944937DB84F3FA9333
MSI (s) (70:B8): Setting cached product context: machine assigned for
product: BEFEE19DF569579409494108C80C6D15
MSI (s) (70:B8): Using cached product context: machine assigned for
product: BEFEE19DF569579409494108C80C6D15
MSI (s) (70:B8): Setting cached product context: machine assigned for
product: D1D05B87C24698B4CB7C53E2EA63417D
MSI (s) (70:B8): Using cached product context: machine assigned for
product: D1D05B87C24698B4CB7C53E2EA63417D
MSI (s) (70:B8): Setting cached product context: machine assigned for
product: DDE7F2BCF1D91C3409CFF425AE1E271A
MSI (s) (70:B8): Using cached product context: machine assigned for
product: DDE7F2BCF1D91C3409CFF425AE1E271A
MSI (s) (70:B8): Setting cached product context: machine assigned for
product: ECFD4F8763317204CB2BA1002CA46835
MSI (s) (70:B8): Using cached product context: machine assigned for
product: ECFD4F8763317204CB2BA1002CA46835
MSI (s) (70:B8): File will have security applied from OpCode.
MSI (s) (70:B8): SOFTWARE RESTRICTION POLICY: Verifying package -->
'C:\sql2ksp3\MSDE\Setup\SqlRun01.msi' against software restriction
policy
MSI (s) (70:B8): Note: 1: 2262 2: DigitalSignature 3: -2147287038
MSI (s) (70:B8): SOFTWARE RESTRICTION POLICY:
C:\sql2ksp3\MSDE\Setup\SqlRun01.msi is not digitally signed
MSI (s) (70:B8): SOFTWARE RESTRICTION POLICY:
C:\sql2ksp3\MSDE\Setup\SqlRun01.msi is permitted to run at the
'unrestricted' authorization level.
MSI (s) (70:B8): End dialog not enabled
MSI (s) (70:B8): Original package =3D=3D>
C:\sql2ksp3\MSDE\Setup\SqlRun01.msi
MSI (s) (70:B8): Package we're running from =3D=3D>
C:\WINDOWS\Installer\2ae4a3.msi
MSI (s) (70:B8): APPCOMPAT: looking for appcompat database entry with
ProductCode '{E09B48B5-E141-427A-AB0C-D3605127224A}'.
MSI (s) (70:B8): APPCOMPAT: no matching ProductCode found in database.
MSI (s) (70:B8): Machine policy value 'TransformsSecure' is 0
MSI (s) (70:B8): User policy value 'TransformsAtSource' is 0
MSI (s) (70:B8): APPCOMPAT: looking for appcompat database entry with
ProductCode '{E09B48B5-E141-427A-AB0C-D3605127224A}'.
MSI (s) (70:B8): APPCOMPAT: no matching ProductCode found in database.
MSI (s) (70:B8): Transforms are not secure.
MSI (s) (70:B8): Note: 1: 2262 2: Control 3: -2147287038
MSI (s) (70:B8): Command Line: SA...
MSI (s) (70:B8): Product Code passed to Engine.Initialize: ''
MSI (s) (70:B8): Product Code from property table before transforms:
'{E09B48B5-E141-427A-AB0C-D3605127224A}'
MSI (s) (70:B8): Product Code from property table after transforms:
'{E09B48B5-E141-427A-AB0C-D3605127224A}'
MSI (s) (70:B8): Product not registered: beginning first-time install
MSI (s) (70:B8): Entering CMsiConfigurationManager::SetLastUsedSource.
MSI (s) (70:B8): User policy value 'SearchOrder' is 'nmu'
MSI (s) (70:B8): Adding new sources is allowed.
MSI (s) (70:B8): Package name extracted from package path:
'SqlRun01.msi'
MSI (s) (70:B8): Package to be registered: 'SqlRun01.msi'
MSI (s) (70:B8): Note: 1: 2262 2: AdminProperties 3: -2147287038
MSI (s) (70:B8): Machine policy value 'DisableMsi' is 0
MSI (s) (70:B8): Machine policy value 'AlwaysInstallElevated' is 0
MSI (s) (70:B8): User policy value 'AlwaysInstallElevated' is 0
MSI (s) (70:B8): Product installation will be elevated because user is
admin and product is being installed per-machine.
MSI (s) (70:B8): Running product
'{E09B48B5-E141-427A-AB0C-D3605127224A}' with elevated privileges:
Product is assigned.
MSI (s) (70:B8): TRANSFORMS property is now:
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\Application Data
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\Favorites
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\NetHood
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\My Documents
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\PrintHood
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\Recent
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\SendTo
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\Templates
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\All Users\Application Data
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\Local Settings\Application Data
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\My Documents\My Pictures
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\All Users\Start Menu\Programs\Administrative Tools
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\All Users\Start Menu\Programs\Startup
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\All Users\Start Menu\Programs
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\All Users\Start Menu
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\All Users\Desktop
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\Start Menu\Programs\Administrative Tools
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\Start Menu\Programs\Startup
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\Start Menu\Programs
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\Start Menu
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\518494\Desktop
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\Documents and
Settings\All Users\Templates
MSI (s) (70:B8): SHELL32::SHGetFolderPath returned: C:\WINDOWS\Fonts
MSI (s) (70:B8): Note: 1: 2898 2: MS Sans Serif 3: MS Sans Serif 4: 0
5: 16
MSI (s) (70:B8): MSCOREE not loaded loading copy from system32
=3D=3D=3D Logging started: 10/31/2005 17:11:35 =3D=3D=3D
MSI (s) (70:B8): Machine policy value 'DisableRollback' is 0
MSI (s) (70:B8): User policy value 'DisableRollback' is 0
MSI (s) (70:B8): Doing action: INSTALL
Action start 17:11:35: INSTALL.
MSI (s) (70:B8): Running ExecuteSequence
MSI (s) (70:B8): Doing action:
ProgramFilesFolder.66CDF039_0EDE_453E_A1E5_1931046 C4056
Action start 17:11:35:
ProgramFilesFolder.66CDF039_0EDE_453E_A1E5_1931046 C4056.
Action ended 17:11:35:
ProgramFilesFolder.66CDF039_0EDE_453E_A1E5_1931046 C4056. Return value
1=2E
MSI (s) (70:B8): Doing action:
ProgramFilesFolder.ACD7EC22_4989_4067_B267_6DB5716 695BC
Action start 17:11:35:
ProgramFilesFolder.ACD7EC22_4989_4067_B267_6DB5716 695BC.
Action ended 17:11:35:
ProgramFilesFolder.ACD7EC22_4989_4067_B267_6DB5716 695BC. Return value
1=2E
MSI (s) (70:B8): Doing action:
ProgramFilesFolder.0C7570D6_6225_4960_B951_4D16DD9 06838
Action start 17:11:35:
ProgramFilesFolder.0C7570D6_6225_4960_B951_4D16DD9 06838.
Action ended 17:11:35:
ProgramFilesFolder.0C7570D6_6225_4960_B951_4D16DD9 06838. Return value
1=2E
MSI (s) (70:B8): Doing action:
ProgramFilesFolder.88C26F26_166C_4CD7_8175_38297C2 276D7
Action start 17:11:35:
ProgramFilesFolder.88C26F26_166C_4CD7_8175_38297C2 276D7.
Action ended 17:11:35:
ProgramFilesFolder.88C26F26_166C_4CD7_8175_38297C2 276D7. Return value
1=2E
MSI (s) (70:B8): Doing action:
ProgramFilesFolder.CC1A8C58_27D1_4D38_BF1B_C0A5CBB 90616
Action start 17:11:35:
ProgramFilesFolder.CC1A8C58_27D1_4D38_BF1B_C0A5CBB 90616.
Action ended 17:11:36:
ProgramFilesFolder.CC1A8C58_27D1_4D38_BF1B_C0A5CBB 90616. Return value
1=2E
MSI (s) (70:B8): Doing action:
StartupFolder.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616
Action start 17:11:36:
StartupFolder.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 .
Action ended 17:11:36:
StartupFolder.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 . Return value 1.
MSI (s) (70:B8): Doing action:
SystemFolder.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616
Action start 17:11:36:
SystemFolder.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616.
Action ended 17:11:36:
SystemFolder.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616. Return value 1.
MSI (s) (70:B8): Doing action:
ProgramFilesFolder.BF65A835_E76E_4CA5_8B97_E8FD33E 7C475
Action start 17:11:36:
ProgramFilesFolder.BF65A835_E76E_4CA5_8B97_E8FD33E 7C475.
Action ended 17:11:36:
ProgramFilesFolder.BF65A835_E76E_4CA5_8B97_E8FD33E 7C475. Return value
1=2E
MSI (s) (70:B8): Doing action:
ProgramFilesFolder.C4D32C83_C28D_4329_A829_31C4C60 34F59
Action start 17:11:36:
ProgramFilesFolder.C4D32C83_C28D_4329_A829_31C4C60 34F59.
Action ended 17:11:36:
ProgramFilesFolder.C4D32C83_C28D_4329_A829_31C4C60 34F59. Return value
1=2E
MSI (s) (70:B8): Doing action:
ProgramFilesFolder.EF490CFB_7BC2_4102_8395_426CE58 70B18
Action start 17:11:36:
ProgramFilesFolder.EF490CFB_7BC2_4102_8395_426CE58 70B18.
Action ended 17:11:36:
ProgramFilesFolder.EF490CFB_7BC2_4102_8395_426CE58 70B18. Return value
1=2E
MSI (s) (70:B8): Doing action:
ProgramFilesFolder.DCDF3AA8_FCF8_49F6_9877_752F754 DD676
Action start 17:11:36:
ProgramFilesFolder.DCDF3AA8_FCF8_49F6_9877_752F754 DD676.
Action ended 17:11:36:
ProgramFilesFolder.DCDF3AA8_FCF8_49F6_9877_752F754 DD676. Return value
1=2E
MSI (s) (70:B8): Doing action:
ProgramFilesFolder.D9BC9C10_2DCD_44D3_AACC_9C58CAF 76128
Action start 17:11:36:
ProgramFilesFolder.D9BC9C10_2DCD_44D3_AACC_9C58CAF 76128.
Action ended 17:11:36:
ProgramFilesFolder.D9BC9C10_2DCD_44D3_AACC_9C58CAF 76128. Return value
1=2E
MSI (s) (70:B8): Doing action:
ProgramFilesFolder.185C1D8F_1545_4277_BB64_857D262 2DB57
Action start 17:11:36:
ProgramFilesFolder.185C1D8F_1545_4277_BB64_857D262 2DB57.
Action ended 17:11:36:
ProgramFilesFolder.185C1D8F_1545_4277_BB64_857D262 2DB57. Return value
1=2E
MSI (s) (70:B8): Doing action:
ProgramFilesFolder.9240E1C0_49D2_40A2_93CE_E62CD8B 48DDC
Action start 17:11:36:
ProgramFilesFolder.9240E1C0_49D2_40A2_93CE_E62CD8B 48DDC.
Action ended 17:11:36:
ProgramFilesFolder.9240E1C0_49D2_40A2_93CE_E62CD8B 48DDC. Return value
1=2E
MSI (s) (70:B8): Doing action:
ProgramFilesFolder.55BCEE28_CDBF_4D7F_97C4_082D6B5 8B9FF
Action start 17:11:36:
ProgramFilesFolder.55BCEE28_CDBF_4D7F_97C4_082D6B5 8B9FF.
Action ended 17:11:36:
ProgramFilesFolder.55BCEE28_CDBF_4D7F_97C4_082D6B5 8B9FF. Return value
1=2E
MSI (s) (70:B8): Doing action:
ProgramFilesFolder.6496AA57_4ABB_4A5B_A0A9_E712ECF A8092
Action start 17:11:36:
ProgramFilesFolder.6496AA57_4ABB_4A5B_A0A9_E712ECF A8092.
Action ended 17:11:36:
ProgramFilesFolder.6496AA57_4ABB_4A5B_A0A9_E712ECF A8092. Return value
1=2E
MSI (s) (70:B8): Doing action:
ProgramFilesFolder.9B023A3C_3C86_4E4B_90D5_DE42FB9 019F7
Action start 17:11:36:
ProgramFilesFolder.9B023A3C_3C86_4E4B_90D5_DE42FB9 019F7.
Action ended 17:11:36:
ProgramFilesFolder.9B023A3C_3C86_4E4B_90D5_DE42FB9 019F7. Return value
1=2E
MSI (s) (70:B8): Doing action:
ProgramFilesFolder.AC2DB678_071D_4330_A52D_9286D61 8F650
Action start 17:11:36:
ProgramFilesFolder.AC2DB678_071D_4330_A52D_9286D61 8F650.
Action ended 17:11:36:
ProgramFilesFolder.AC2DB678_071D_4330_A52D_9286D61 8F650. Return value
1=2E
MSI (s) (70:B8): Doing action:
ProgramFilesFolder.F5ABDAB8_DDBD_4D92_BEAD_A0511D9 C85DB
Action start 17:11:36:
ProgramFilesFolder.F5ABDAB8_DDBD_4D92_BEAD_A0511D9 C85DB.
Action ended 17:11:36:
ProgramFilesFolder.F5ABDAB8_DDBD_4D92_BEAD_A0511D9 C85DB. Return value
1=2E
MSI (s) (70:B8): Doing action:
SystemFolder.F26FFD4A_05B4_4969_A552_30C7F9BAB1F4
Action start 17:11:36:
SystemFolder.F26FFD4A_05B4_4969_A552_30C7F9BAB1F4.
Action ended 17:11:36:
SystemFolder.F26FFD4A_05B4_4969_A552_30C7F9BAB1F4. Return value 1.
MSI (s) (70:B8): Doing action:
ProgramFilesFolder.F26FFD4A_05B4_4969_A552_30C7F9B AB1F4
Action start 17:11:36:
ProgramFilesFolder.F26FFD4A_05B4_4969_A552_30C7F9B AB1F4.
Action ended 17:11:36:
ProgramFilesFolder.F26FFD4A_05B4_4969_A552_30C7F9B AB1F4. Return value
1=2E
MSI (s) (70:B8): Doing action:
TempFolder.F26FFD4A_05B4_4969_A552_30C7F9BAB1F4
Action start 17:11:36: TempFolder.F26FFD4A_05B4_4969_A552_30C7F9BAB1F4.
Action ended 17:11:36: TempFolder.F26FFD4A_05B4_4969_A552_30C7F9BAB1F4.
Return value 1.
MSI (s) (70:B8): Doing action:
ProgramFilesFolder.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B
Action start 17:11:36:
ProgramFilesFolder.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B.
Action ended 17:11:36:
ProgramFilesFolder.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B. Return value
1=2E
MSI (s) (70:B8): Doing action:
StartupFolder.2D02443E_7002_4C0B_ABC9_EAB2C064397B
Action start 17:11:36:
StartupFolder.2D02443E_7002_4C0B_ABC9_EAB2C064397B .
Action ended 17:11:36:
StartupFolder.2D02443E_7002_4C0B_ABC9_EAB2C064397B . Return value 1.
MSI (s) (70:B8): Doing action:
SystemFolder.2D02443E_7002_4C0B_ABC9_EAB2C064397B
Action start 17:11:36:
SystemFolder.2D02443E_7002_4C0B_ABC9_EAB2C064397B.
Action ended 17:11:36:
SystemFolder.2D02443E_7002_4C0B_ABC9_EAB2C064397B. Return value 1.
MSI (s) (70:B8): Doing action: SetInstallDir
Action start 17:11:36: SetInstallDir.
Action ended 17:11:36: SetInstallDir. Return value 1.
MSI (s) (70:B8): Doing action: SetDataDir
Action start 17:11:36: SetDataDir.
Action ended 17:11:36: SetDataDir. Return value 1.
MSI (s) (70:B8): Doing action: SetInstanceName
Action start 17:11:36: SetInstanceName.
Action ended 17:11:36: SetInstanceName. Return value 1.
MSI (s) (70:B8): Doing action: SetCollation
Action start 17:11:36: SetCollation.
Action ended 17:11:36: SetCollation. Return value 1.
MSI (s) (70:B8): Doing action: SetCallback
Action start 17:11:36: SetCallback.
Action ended 17:11:36: SetCallback. Return value 1.
MSI (s) (70:B8): Doing action: SetSecurityMode
Action start 17:11:36: SetSecurityMode.
Action ended 17:11:36: SetSecurityMode. Return value 1.
MSI (s) (70:B8): Doing action: SetUpgrade
Action start 17:11:36: SetUpgrade.
Action ended 17:11:36: SetUpgrade. Return value 1.
MSI (s) (70:B8): Doing action: SetUpgradeUser
Action start 17:11:36: SetUpgradeUser.
Action ended 17:11:36: SetUpgradeUser. Return value 1.
MSI (s) (70:B8): Skipping action: SetUpgradeUserWin9x (condition is
false)
MSI (s) (70:B8): Skipping action: SetSecurityMode9x (condition is
false)
MSI (s) (70:B8): Doing action: SetSaPword
Action start 17:11:36: SetSaPword.
Action ended 17:11:36: SetSaPword. Return value 1.
MSI (s) (70:B8): Doing action: SetUpgradeUserPword
Action start 17:11:36: SetUpgradeUserPword.
Action ended 17:11:36: SetUpgradeUserPword. Return value 1.
MSI (s) (70:B8): Doing action: SetAllowBlankSaPword
Action start 17:11:36: SetAllowBlankSaPword.
Action ended 17:11:36: SetAllowBlankSaPword. Return value 1.
MSI (s) (70:B8): Skipping action: SetSqlDoUpgrade (condition is false)
MSI (s) (70:B8): Doing action: SetDisableAgentStartup
Action start 17:11:36: SetDisableAgentStartup.
Action ended 17:11:36: SetDisableAgentStartup. Return value 1.
MSI (s) (70:B8): Doing action: SetAllowXDBChaining
Action start 17:11:36: SetAllowXDBChaining.
Action ended 17:11:36: SetAllowXDBChaining. Return value 1.
MSI (s) (70:B8): Doing action:
DefaultProgramDir.2D02443E_7002_4C0B_ABC9_EAB2C064 397B
Action start 17:11:36:
DefaultProgramDir.2D02443E_7002_4C0B_ABC9_EAB2C064 397B.
Action ended 17:11:36:
DefaultProgramDir.2D02443E_7002_4C0B_ABC9_EAB2C064 397B. Return value 1.
MSI (s) (70:B8): Doing action:
DefaultDataDir.2D02443E_7002_4C0B_ABC9_EAB2C064397 B
Action start 17:11:36:
DefaultDataDir.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.
Action ended 17:11:36:
DefaultDataDir.2D02443E_7002_4C0B_ABC9_EAB2C064397 B. Return value 1.
MSI (s) (70:B8): Doing action:
SQLVersion.2D02443E_7002_4C0B_ABC9_EAB2C064397B
Action start 17:11:36: SQLVersion.2D02443E_7002_4C0B_ABC9_EAB2C064397B.
Action ended 17:11:36: SQLVersion.2D02443E_7002_4C0B_ABC9_EAB2C064397B.
Return value 1.
MSI (s) (70:B8): Doing action:
StreamSupportFiles.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B
Action start 17:11:36:
StreamSupportFiles.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B.
MSI (s) (70:B8): Creating MSIHANDLE (65) of type 790542 for thread 3512
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Creating CA Temp Directory :
C:\DOCUME~1\518494\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Streamed setupex.2D02443E_7002_4C0B_ABC9_EAB2C064397B to
C:\DOCUME~1\518494\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\set=
upex.dll
Streamed sqdedev.2D02443E_7002_4C0B_ABC9_EAB2C064397B to
C:\DOCUME~1\518494\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqd=
edev.dll
Streamed sqlsut.2D02443E_7002_4C0B_ABC9_EAB2C064397B to
C:\DOCUME~1\518494\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sql=
sut.dll
Streamed sqlunirl.2D02443E_7002_4C0B_ABC9_EAB2C064397B to
C:\DOCUME~1\518494\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sql=
unirl.dll
Streamed sqlresld.2D02443E_7002_4C0B_ABC9_EAB2C064397B to
C:\DOCUME~1\518494\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sql=
resld.dll
Streamed sqlcaxrll.2D02443E_7002_4C0B_ABC9_EAB2C064397B to
C:\DOCUME~1\518494\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sql=
cax.rll
Streamed sqlstp.2D02443E_7002_4C0B_ABC9_EAB2C064397B to
C:\DOCUME~1\518494\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sql=
stp.dll
Streamed sqlstprll.2D02443E_7002_4C0B_ABC9_EAB2C064397B to
C:\DOCUME~1\518494\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sql=
stp.rll
Streamed sqlcax.2D02443E_7002_4C0B_ABC9_EAB2C064397B to
C:\DOCUME~1\518494\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sql=
cax.dll
Action ended 17:11:36:
StreamSupportFiles.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B. Return value
1=2E
MSI (s) (70:B8): Doing action:
SetPropSQLMSDEInstalled.2D02443E_7002_4C0B_ABC9_EA B2C064397B
Action start 17:11:36:
SetPropSQLMSDEInstalled.2D02443E_7002_4C0B_ABC9_EA B2C064397B.
MSI (s) (70:B8): Creating MSIHANDLE (113) of type 790542 for thread
3512
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\518494\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\518494\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sql=
cax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action SetPropSQLMSDEInstalled
FindSet for ProductCode <{E09B48B5-E141-427A-AB0C-D3605127224A}>
returned 1
Setting SQLMSDEInstalled by MsiSetProperty returned 0
Setting SQLMSDESelected by MsiSetProperty returned 0
End SetPropSQLMSDEInstalled
Action ended 17:11:37:
SetPropSQLMSDEInstalled.2D02443E_7002_4C0B_ABC9_EA B2C064397B. Return
value 1.
MSI (s) (70:B8): Doing action:
RestoreSetupParams.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B
Action start 17:11:37:
RestoreSetupParams.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B.
MSI (s) (70:B8): Creating MSIHANDLE (123) of type 790542 for thread
3512
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Entering Function MyMsiEvaluateCondition
MsiEvaluateCondition for SQLMSDEInstalled returned TRUE
End Function MyMsiEvaluateCondition
Error reading setup parameters
Action ended 17:11:37:
RestoreSetupParams.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B. Return value
3=2E
Action ended 17:11:37: INSTALL. Return value 3.
MSI (s) (70:B8): Note: 1: 2262 2: Control 3: -2147287038
Property(S): UpgradeCode =3D {421A321C-2214-4713-B3EB-253F2FBCCE49}
Property(S): SqlDataDir =3D C:\Program Files\Microsoft SQL Server\
Property(S): SqlProgramDir =3D C:\Program Files\Microsoft SQL Server\
Property(S): SqlSecurityMode =3D sql
Property(S): SqlSa...
Property(S): VersionNT =3D 501
Property(S): ALLUSERS =3D 1
Property(S): ARPNOMODIFY =3D 1
Property(S): DefaultUIFont =3D Tahoma8
Property(S): INSTALLLEVEL =3D 3
Property(S): LIMITUI =3D 1
Property(S): Manufacturer =3D Microsoft Corporation
Property(S): ProductCode =3D {E09B48B5-E141-427A-AB0C-D3605127224A}
Property(S): ProductLanguage =3D 1033
Property(S): ProductName =3D Microsoft SQL Server Desktop Engine
Property(S): ProductVersion =3D 8.00.761
Property(S): MsiHiddenProperties =3D SqlSa...
Property(S): ProgramFilesFolder.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B =3D
C:\Program Files\
Property(S): StartupFolder.2D02443E_7002_4C0B_ABC9_EAB2C064397B =3D
C:\Documents and Settings\All Users\Start Menu\Programs\Startup\
Property(S): SystemFolder.2D02443E_7002_4C0B_ABC9_EAB2C064397B =3D
C:\WINDOWS\System32\
Property(S): SQLVersion.2D02443E_7002_4C0B_ABC9_EAB2C064397B =3D 8.00.194
Property(S): SQLMSDEInstalled =3D 1
Property(S): SQLExitCode.2D02443E_7002_4C0B_ABC9_EAB2C064397B =3D 1603
Property(S): APPS_TEST =3D 1
Property(S): SQLMSDESelected =3D 1
Property(S): CSDVersionNumber =3D 768
Property(S): CSDVersion =3D 8.00.761
Property(S): SQLVersion =3D 8.00.194
Property(S): SystemFolder.F26FFD4A_05B4_4969_A552_30C7F9BAB1F4 =3D
C:\WINDOWS\System32\
Property(S): ProgramFilesFolder.F26FFD4A_05B4_4969_A552_30C7F9B AB1F4 =3D
C:\Program Files\
Property(S): TempFolder.F26FFD4A_05B4_4969_A552_30C7F9BAB1F4 =3D
C:\DOCUME~1\518494\LOCALS~1\Temp\
Property(S): ProgramFilesFolder.F5ABDAB8_DDBD_4D92_BEAD_A0511D9 C85DB =3D
C:\Program Files\
Property(S): ProgramFilesFolder.AC2DB678_071D_4330_A52D_9286D61 8F650 =3D
C:\Program Files\
Property(S): ProgramFilesFolder.9B023A3C_3C86_4E4B_90D5_DE42FB9 019F7 =3D
C:\Program Files\
Property(S): ProgramFilesFolder.6496AA57_4ABB_4A5B_A0A9_E712ECF A8092 =3D
C:\Program Files\
Property(S): ProgramFilesFolder.55BCEE28_CDBF_4D7F_97C4_082D6B5 8B9FF =3D
C:\Program Files\
Property(S): ProgramFilesFolder.9240E1C0_49D2_40A2_93CE_E62CD8B 48DDC =3D
C:\Program Files\
Property(S): ProgramFilesFolder.185C1D8F_1545_4277_BB64_857D262 2DB57 =3D
C:\Program Files\
Property(S): ProgramFilesFolder.D9BC9C10_2DCD_44D3_AACC_9C58CAF 76128 =3D
C:\Program Files\
Property(S): ProgramFilesFolder.DCDF3AA8_FCF8_49F6_9877_752F754 DD676 =3D
C:\Program Files\
Property(S): ProgramFilesFolder.EF490CFB_7BC2_4102_8395_426CE58 70B18 =3D
C:\Program Files\
Property(S): ProgramFilesFolder.C4D32C83_C28D_4329_A829_31C4C60 34F59 =3D
C:\Program Files\
Property(S): ProgramFilesFolder.BF65A835_E76E_4CA5_8B97_E8FD33E 7C475 =3D
C:\Program Files\
Property(S): ProgramFilesFolder.CC1A8C58_27D1_4D38_BF1B_C0A5CBB 90616 =3D
C:\Program Files\
Property(S): StartupFolder.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 =3D
C:\Documents and Settings\All Users\Start Menu\Programs\Startup\
Property(S): SystemFolder.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 =3D
C:\WINDOWS\System32\
Property(S): ProgramFilesFolder.88C26F26_166C_4CD7_8175_38297C2 276D7 =3D
C:\Program Files\
Property(S): ProgramFilesFolder.0C7570D6_6225_4960_B951_4D16DD9 06838 =3D
C:\Program Files\
Property(S): ProgramFilesFolder.ACD7EC22_4989_4067_B267_6DB5716 695BC =3D
C:\Program Files\
Property(S): ProgramFilesFolder.66CDF039_0EDE_453E_A1E5_1931046 C4056 =3D
C:\Program Files\
Property(S): SystemFolder =3D C:\WINDOWS\System32\
Property(S): PackageCode =3D {D29DCF7A-8199-4373-BA0D-2F3635EC940C}
Property(S): ProductState =3D -1
Property(S): PackagecodeChanging =3D 1
Property(S): SA...
Property(S): SECURITYMODE =3D sql
Property(S): CURRENTDIRECTORY =3D C:\sql2ksp3\MSDE
Property(S): CLIENTUILEVEL =3D 0
Property(S): CLIENTPROCESSID =3D 3876
Property(S): USERNAME =3D Booz Allen Hamilton
Property(S): COMPANYNAME =3D Booz Allen Hamilton
Property(S): ACTION =3D INSTALL
Property(S): VersionDatabase =3D 110
Property(S): VersionMsi =3D 2.00
Property(S): WindowsBuild =3D 2600
Property(S): ServicePackLevel =3D 1
Property(S): ServicePackLevelMinor =3D 0
Property(S): MsiNTProductType =3D 1
Property(S): WindowsFolder =3D C:\WINDOWS\
Property(S): WindowsVolume =3D C:\
Property(S): System16Folder =3D C:\WINDOWS\System\
Property(S): RemoteAdminTS =3D 1
Property(S): TempFolder =3D C:\DOCUME~1\518494\LOCALS~1\Temp\
Property(S): ProgramFilesFolder =3D C:\Program Files\
Property(S): CommonFilesFolder =3D C:\Program Files\Common Files\
Property(S): AppDataFolder =3D C:\Documents and
Settings\518494\Application Data\
Property(S): FavoritesFolder =3D C:\Documents and
Settings\518494\Favorites\
Property(S): NetHoodFolder =3D C:\Documents and Settings\518494\NetHood\
Property(S): PersonalFolder =3D C:\Documents and Settings\518494\My
Documents\
Property(S): PrintHoodFolder =3D C:\Documents and
Settings\518494\PrintHood\
Property(S): RecentFolder =3D C:\Documents and Settings\518494\Recent\
Property(S): SendToFolder =3D C:\Documents and Settings\518494\SendTo\
Property(S): TemplateFolder =3D C:\Documents and Settings\All
Users\Templates\
Property(S): CommonAppDataFolder =3D C:\Documents and Settings\All
Users\Application Data\
Property(S): LocalAppDataFolder =3D C:\Documents and
Settings\518494\Local Settings\Application Data\
Property(S): MyPicturesFolder =3D C:\Documents and Settings\518494\My
Documents\My Pictures\
Property(S): AdminToolsFolder =3D C:\Documents and Settings\All
Users\Start Menu\Programs\Administrative Tools\
Property(S): StartupFolder =3D C:\Documents and Settings\All Users\Start
Menu\Programs\Startup\
Property(S): ProgramMenuFolder =3D C:\Documents and Settings\All
Users\Start Menu\Programs\
Property(S): StartMenuFolder =3D C:\Documents and Settings\All
Users\Start Menu\
Property(S): DesktopFolder =3D C:\Documents and Settings\All
Users\Desktop\
Property(S): FontsFolder =3D C:\WINDOWS\Fonts\
Property(S): GPTSupport =3D 1
Property(S): OLEAdvtSupport =3D 1
Property(S): ShellAdvtSupport =3D 1
Property(S): Intel =3D 6
Property(S): PhysicalMemory =3D 1023
Property(S): VirtualMemory =3D 2173
Property(S): AdminUser =3D 1
Property(S): LogonUser =3D 518494
Property(S): UserSID =3D S-1-5-21-1079118523-3685698554-67682326-1008
Property(S): UserLanguageID =3D 1033
Property(S): ComputerName =3D BAH518494ABTAHI
Property(S): SystemLanguageID =3D 1033
Property(S): ScreenX =3D 1024
Property(S): ScreenY =3D 768
Property(S): CaptionHeight =3D 19
Property(S): BorderTop =3D 1
Property(S): BorderSide =3D 1
Property(S): TextHeight =3D 16
Property(S): ColorBits =3D 32
Property(S): TTCSupport =3D 1
Property(S): MsiNetAssemblySupport =3D 1.1.4322.2032
Property(S): MsiWin32AssemblySupport =3D 5.1.2600.1579
Property(S): RedirectedDllSupport =3D 2
Property(S): Time =3D 17:11:37
Property(S): Date =3D 10/31/2005
Property(S): Privileged =3D 1
Property(S): DATABASE =3D C:\WINDOWS\Installer\2ae4a3.msi
Property(S): OriginalDatabase =3D C:\sql2ksp3\MSDE\Setup\SqlRun01.msi
Property(S): UILevel =3D 3
MSI (s) (70:B8): MainEngineThread is returning 1603
MSI (c) (24:F0): Back from server. Return value: 1603
MSI (c) (24:F0): Decrementing counter to disable shutdown. If counter
>=3D 0, shutdown will be denied. Counter after decrement: -1
Action ended 17:11:37: INSTALL. Return value 3.
MSI (c) (24:F0): Note: 1: 2262 2: Control 3: -2147287038
Property(C): UpgradeCode =3D {421A321C-2214-4713-B3EB-253F2FBCCE49}
Property(C): VersionNT =3D 501
Property(C): ALLUSERS =3D 1
Property(C): ARPNOMODIFY =3D 1
Property(C): DefaultUIFont =3D Tahoma8
Property(C): INSTALLLEVEL =3D 3
Property(C): LIMITUI =3D 1
Property(C): Manufacturer =3D Microsoft Corporation
Property(C): ProductCode =3D {E09B48B5-E141-427A-AB0C-D3605127224A}
Property(C): ProductLanguage =3D 1033
Property(C): ProductName =3D Microsoft SQL Server Desktop Engine
Property(C): ProductVersion =3D 8.00.761
Property(C): MsiHiddenProperties =3D SqlSa...
Property(C): SQLVersion.2D02443E_7002_4C0B_ABC9_EAB2C064397B =3D 8.00.194
Property(C): SQLExitCode.2D02443E_7002_4C0B_ABC9_EAB2C064397B =3D 1603
Property(C): APPS_TEST =3D 1
Property(C): SQLMSDESelected =3D 1
Property(C): CSDVersionNumber =3D 768
Property(C): CSDVersion =3D 8.00.761
Property(C): SystemFolder =3D C:\WINDOWS\System32\
Property(C): PackageCode =3D {D29DCF7A-8199-4373-BA0D-2F3635EC940C}
Property(C): ProductState =3D -1
Property(C): PackagecodeChanging =3D 1
Property(C): SA...
Property(C): SECURITYMODE =3D sql
Property(C): CURRENTDIRECTORY =3D C:\sql2ksp3\MSDE
Property(C): CLIENTUILEVEL =3D 0
Property(C): CLIENTPROCESSID =3D 3876
Property(C): VersionDatabase =3D 110
Property(C): VersionMsi =3D 2.00
Property(C): WindowsBuild =3D 2600
Property(C): ServicePackLevel =3D 1
Property(C): ServicePackLevelMinor =3D 0
Property(C): MsiNTProductType =3D 1
Property(C): WindowsFolder =3D C:\WINDOWS\
Property(C): WindowsVolume =3D C:\
Property(C): System16Folder =3D C:\WINDOWS\System\
Property(C): RemoteAdminTS =3D 1
Property(C): TempFolder =3D C:\DOCUME~1\518494\LOCALS~1\Temp\
Property(C): ProgramFilesFolder =3D C:\Program Files\
Property(C): CommonFilesFolder =3D C:\Program Files\Common Files\
Property(C): AppDataFolder =3D C:\Documents and
Settings\518494\Application Data\
Property(C): FavoritesFolder =3D C:\Documents and
Settings\518494\Favorites\
Property(C): NetHoodFolder =3D C:\Documents and Settings\518494\NetHood\
Property(C): PersonalFolder =3D C:\Documents and Settings\518494\My
Documents\
Property(C): PrintHoodFolder =3D C:\Documents and
Settings\518494\PrintHood\
Property(C): RecentFolder =3D C:\Documents and Settings\518494\Recent\
Property(C): SendToFolder =3D C:\Documents and Settings\518494\SendTo\
Property(C): TemplateFolder =3D C:\Documents and Settings\All
Users\Templates\
Property(C): CommonAppDataFolder =3D C:\Documents and Settings\All
Users\Application Data\
Property(C): LocalAppDataFolder =3D C:\Documents and
Settings\518494\Local Settings\Application Data\
Property(C): MyPicturesFolder =3D C:\Documents and Settings\518494\My
Documents\My Pictures\
Property(C): AdminToolsFolder =3D C:\Documents and Settings\All
Users\Start Menu\Programs\Administrative Tools\
Property(C): StartupFolder =3D C:\Documents and Settings\All Users\Start
Menu\Programs\Startup\
Property(C): ProgramMenuFolder =3D C:\Documents and Settings\All
Users\Start Menu\Programs\
Property(C): StartMenuFolder =3D C:\Documents and Settings\All
Users\Start Menu\
Property(C): DesktopFolder =3D C:\Documents and Settings\All
Users\Desktop\
Property(C): FontsFolder =3D C:\WINDOWS\Fonts\
Property(C): GPTSupport =3D 1
Property(C): OLEAdvtSupport =3D 1
Property(C): ShellAdvtSupport =3D 1
Property(C): Intel =3D 6
Property(C): PhysicalMemory =3D 1023
Property(C): VirtualMemory =3D 2175
Property(C): AdminUser =3D 1
Property(C): LogonUser =3D 518494
Property(C): UserSID =3D S-1-5-21-1079118523-3685698554-67682326-1008
Property(C): UserLanguageID =3D 1033
Property(C): ComputerName =3D BAH518494ABTAHI
Property(C): SystemLanguageID =3D 1033
Property(C): ScreenX =3D 1024
Property(C): ScreenY =3D 768
Property(C): CaptionHeight =3D 19
Property(C): BorderTop =3D 1
Property(C): BorderSide =3D 1
Property(C): TextHeight =3D 16
Property(C): ColorBits =3D 32
Property(C): TTCSupport =3D 1
Property(C): MsiNetAssemblySupport =3D 1.1.4322.2032
Property(C): MsiWin32AssemblySupport =3D 5.1.2600.1579
Property(C): RedirectedDllSupport =3D 2
Property(C): Time =3D 17:11:38
Property(C): Date =3D 10/31/2005
Property(C): Privileged =3D 1
Property(C): USERNAME =3D Booz Allen Hamilton
Property(C): COMPANYNAME =3D Booz Allen Hamilton
Property(C): DATABASE =3D C:\DOCUME~1\518494\LOCALS~1\Temp\2bf23d.msi
Property(C): OriginalDatabase =3D C:\sql2ksp3\MSDE\Setup\SqlRun01.msi
Property(C): UILevel =3D 3
Property(C): ACTION =3D INSTALL
=3D=3D=3D Logging stopped: 10/31/2005 17:11:38 =3D=3D=3D
MSI (c) (24:F0): Note: 1: 1708
MSI (c) (24:F0): Product: Microsoft SQL Server Desktop Engine --
Installation operation failed.
MSI (c) (24:F0): Grabbed execution mutex.
MSI (c) (24:F0): Cleaning up uninstalled install packages, if any exist
MSI (c) (24:F0): MainEngineThread is returning 1603
=3D=3D=3D Verbose logging stopped: 10/31/2005 17:11:38 =3D=3D=3D
hi,
youngveh wrote:
> I am trying to install MSDE desktop engine and I having the most
> difficult time.
try having a look at http://tinyurl.com/7j4mt
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||that worked but now it installs and rollsback.

MSDE install problem

I've been using Jet databases for my websites for quite some time. I was
going to try MSDE a year or so ago but there were some limitations to it
back then that prevented me from using it.
After subscribing to the newsgroup yesterday and reading some of the posts I
saw the limitations had been removed in the recent release. So I decised to
download and install it.
I am now trying to install, but I get this error each time...
"The instance name specified is invalid"
I havent specified any instance name, so I don't know what to do.
I'm using WinXP-Pro.
Any ideas what the problem is ?
Thanks,
PW
On Sat, 17 Apr 2004 06:41:11 +0800, "PW" <pwa@.NObigSPAMpond.net.au>
wrote:

>I've been using Jet databases for my websites for quite some time. I was
>going to try MSDE a year or so ago but there were some limitations to it
>back then that prevented me from using it.
>After subscribing to the newsgroup yesterday and reading some of the posts I
>saw the limitations had been removed in the recent release. So I decised to
>download and install it.
>I am now trying to install, but I get this error each time...
>"The instance name specified is invalid"
>I havent specified any instance name, so I don't know what to do.
>I'm using WinXP-Pro.
>Any ideas what the problem is ?
Do you already have SQL server installed? If you don't specify an
instance name, it uses the default which is the same as SQLServer.
Also, check your registry key,'HKLM\Software\Microsoft\Microsoft SQL
Server', value 'InstalledInstances'.

MSDE Install fails. Please Help someone

The installation of MSDE fails and I dont find any solution to get it
work. If I start the setup than a windows with the time bar appears and
says it will take 1 minute. After nearly 1 minute it closes the window
and gives no additional information. But I see that it generates first
all the directories and files in c:\Programme but after the setup is end
everything is deleted. Nearly everything , I see a service
"MSSQLServerADHelper" is still installed.
Must everytime delete it via regedit.
I am using WindowsXP SP1 with MDAC 2.8
I get this at the end of the generated protokoll
after I start setup with
"setup SAPWD="mypasswort" SECURITYMODE=SQL /L*v D:/MSDELog.log"

Property(C): StartupFolder = C:\Dokumente und Einstellungen\All
Users\Startmen\Programme\Autostart\
Property(C): ProgramMenuFolder = C:\Dokumente und Einstellungen\All
Users\Startmen\Programme\
Property(C): StartMenuFolder = C:\Dokumente und Einstellungen\All
Users\Startmen\
Property(C): DesktopFolder = C:\Dokumente und Einstellungen\All
Users\Desktop\
Property(C): FontsFolder = C:\WINDOWS\Fonts\
Property(C): GPTSupport = 1
Property(C): OLEAdvtSupport = 1
Property(C): ShellAdvtSupport = 1
Property(C): Intel = 6
Property(C): PhysicalMemory = 448
Property(C): VirtualMemory = 805
Property(C): AdminUser = 1
Property(C): LogonUser = BILOAGA
Property(C): UserSID = S-1-5-21-1606980848-1563985344-1202660629-1003
Property(C): UserLanguageID = 1031
Property(C): ComputerName = JUSTLER
Property(C): SystemLanguageID = 1031
Property(C): ScreenX = 1024
Property(C): ScreenY = 768
Property(C): CaptionHeight = 19
Property(C): BorderTop = 1
Property(C): BorderSide = 1
Property(C): TextHeight = 16
Property(C): ColorBits = 16
Property(C): TTCSupport = 1
Property(C): MsiNetAssemblySupport = 1.1.4322.573
Property(C): MsiWin32AssemblySupport = 5.1.2600.1106
Property(C): RedirectedDllSupport = 2
Property(C): Time = 19:43:01
Property(C): Date = 18.12.2003
Property(C): Privileged = 1
Property(C): USERNAME = BILOAGA
Property(C): COMPANYNAME = xxx
Property(C): DATABASE = C:\DOKUME~1\BILOAGA\LOKALE~1\Temp\5b2b57.msi
Property(C): OriginalDatabase = C:\SQL2ksp3install\Setup\SqlRun01.msi
Property(C): UILevel = 3
Property(C): ACTION = INSTALL
=== Protokollierung beendet: 18.12.2003 19:43:01 ===
MSI (c) (B0:20): Note: 1: 1708
MSI (c) (B0:20): Produkt: Microsoft SQL Server Desktop Engine --
Installationsvorgang fehlgeschlagen.

MSI (c) (B0:20): Grabbed execution mutex.
MSI (c) (B0:20): Cleaning up uninstalled install packages, if any exist
MSI (c) (B0:20): MainEngineThread is returning 1603
=== Verbose logging stopped: 18.12.2003 19:43:01 ===

It would be super if anyone can help me. Havent find any informations
about this.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Update:
I have forget to say that it is MSDE 2000 Version A

and have found a information that I must look for value 3 in the log
file

here is the part of log with return value 3:

Starting custom action CallSQLAdHlp
C:\Programme\Microsoft SQL Server\80\Tools\Binn\sqladhlp.exe : 0
MSI (s) (48:FC): Executing op:
ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C0643
97B,,)
Aktion 19:42:22:
RollbackAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2 C064397B.
MSI (s) (48:FC): Executing op:
CustomActionSchedule(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC
9_EAB2C064397B,ActionType=1281,Source=BinaryData,T arget=UnInstSQLAgentSe
curity,)
MSI (s) (48:FC): Executing op:
ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C06439
7B,,)
Aktion 19:42:22:
InstallAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2C 064397B.
MSI (s) (48:FC): Executing op:
CustomActionSchedule(Action=InstallAgentSecurity.2 D02443E_7002_4C0B_ABC9
_EAB2C064397B,ActionType=1025,Source=BinaryData,Ta rget=InstallSQLAgentSe
curity,)
MSI (s) (48:FC): Creating MSIHANDLE (254) of type 790536 for thread 2556
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOKUME~1\BILOAGA\LOKALE~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}
\
Loading extended custom action library
C:\DOKUME~1\BILOAGA\LOKALE~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}
\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (JUSTLER,LocalSystem,87).
Aktion beendet um 19:42:23: InstallFinalize. Rckgabewert 3.
MSI (s) (48:FC): User policy value 'DisableRollback' is 0
MSI (s) (48:FC): Machine policy value 'DisableRollback' is 0
MSI (s) (48:FC): Executing op:
Header(Signature=1397708873,Version=200,Timestamp= 798137610,LangId=1031,
Platform=0,ScriptType=2,ScriptMajorVersion=21,Scri ptMinorVersion=4,Scrip
tAttributes=1)
MSI (s) (48:FC): Executing op: DialogInfo(Type=0,Argument=1031)
MSI (s) (48:FC): Executing op: DialogInfo(Type=1,Argument=Microsoft SQL
Server Desktop Engine)
MSI (s) (48:FC): Executing op:
RollbackInfo(,RollbackAction=Rollback,RollbackDesc ription=Aktion wird
rckgngig
gemacht:,RollbackTemplate=,CleanupAction=RollbackC leanup,CleanupDescript
ion=Sicherungsdateien werden entfernt,CleanupTemplate=Datei: )
Aktion 19:42:23: Rollback. Aktion wird rckgngig gemacht:
Rollback: InstallAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2C 064397B
MSI (s) (48:FC): Executing op:
ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C06439
7B,,)
MSI (s) (48:FC): Executing op:
ProductInfo(ProductKey={E09B48B5-E141-427A-AB0C-D3605127224A},ProductNam
e=Microsoft SQL Server Desktop
Engine,PackageName=SqlRun01.msi,Language=1031,Vers ion=134218489,Assignme
nt=1,ObsoleteArg=0,,,PackageCode={D29DCF7A-8199-4
373-BA0D-2F3635EC940C},,,InstanceType=0)
Rollback: RollbackAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2 C064397B
MSI (s) (48:FC): Executing op:
ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C0643
97B,,)
MSI (s) (48:FC): Executing op:
CustomActionRollback(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC
9_EAB2C064397B,ActionType=1281,Source=BinaryData,T arget=UnInstSQLAgentSe
curity,)
MSI (s) (48:FC): Creating MSIHANDLE (261) of type 790536 for thread 2556
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOKUME~1\BILOAGA\LOKALE~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}
\
Loading extended custom action library
C:\DOKUME~1\BILOAGA\LOKALE~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}
\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action UnInstSQLAgentSecurity
Starting custom action UnInstSQLAgentSecurity
Rollback: InstallSQLAdHlp.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B

----------------
----------------
here i get a return value 3
"InstallSQLAgentSecurity failed (JUSTLER,LocalSystem,87).
Aktion beendet um 19:42:23: InstallFinalize. Rckgabewert 3."

But still dont now why the installation of SQLAgentSecurity fails.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

MSDE Help

Hey,

I have produced an asp.net application, and it's time for me to look to installing it at my clients site.

The application uses MS SQL. I have a redistribution license for MSDE 2000. So I have spent all morning ( :-( ) trying to work out how I can distribute it.

I have worked out how to install MSDE, however I can't find any information on:

1. How to connect to the MSDE instance (both for admin and through the asp.net pages).
2. What tools I can use to add/import a database to the MSDE instance.
3. If there is a way to create a distribution package other than using Visual Studio (which I don't have)

I have named the instance WENS, I set the password to XXXXX (not that)

I have worked out how to start the service by opening the service manager. However there are no admin tools provided, and when I use the MS SQL admin tools I can't connect, it doesn't accept the user account
sa, XXXXX

So, basically, any help you can give me would be fantastic, I'm at a loose end, lol.

Thanks a lot for your help.

(Tools I have at my disposal, web matrix, MS SQL Enterprise Edition, MSDE, and I'll download anything that will help (and is legal to use) )http://support.microsoft.com/default.aspx?scid=kb;EN-US;321698 - KBA to start with and refer to corresponding KBA links too.|||Hey,

That seemed to fix a lot of my problems, thanks ;-).

I still have one issue I can't seem to find an answer to in there.

When I connect to the database from another computer, I get an error message saying

Please verify SQL Server is running and check your SQL Server registration properties ...

The instance is called WENS and is located on a computer named ASHG

so I am attempting to connect to

ASHG\WENS

is that correct? what could be causeing this error? all the services in the services manager for the WENS instance as running.

Thanks
-Ashleigh