Install Problem...Please Help!

Exactly the same problem here, on a W2K machine.
The event log provides me with: "Product: Microsoft SQL
Server Desktop Engine -- Installation operation failed.".
In close proximity to these error messages, I can see
some "LoadPerf" error messages and warnings. Seem these
messages are related.
Cool, another one of these "helpful" error messages.
I thried the 3rd party install and a manual install, but
to no avail.
Any idea, someone?
Best regards, Klaus
>--Original Message--
>A third party application is trying to install MSDE 2000
on our XP Professional machine. Install gets to about "2
seconds remaining" then backs out and simply quits. No
error messages. Saw a similar post on here but it was
never resolved. I've made sure the Server service is
running and that File and Print Sharing for Microsoft
Networks is installed and enabled. Any help would be
greatly appreciated...this is a very important application
we are trying to install. Thanks.
>Floyd
>.
>
hi Klaus,
"Klaus Stock" <ks@.expose-media.de> ha scritto nel messaggio
news:2d1201c47e2d$bf57b1c0$a401280a@.phx.gbl...
> Exactly the same problem here, on a W2K machine.
> The event log provides me with: "Product: Microsoft SQL
> Server Desktop Engine -- Installation operation failed.".
> In close proximity to these error messages, I can see
> some "LoadPerf" error messages and warnings. Seem these
> messages are related.
> Cool, another one of these "helpful" error messages.
> I thried the 3rd party install and a manual install, but
> to no avail.
please have a look if http://support.microsoft.com/?id=315083 can help
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Install MSDE without Microsoft .NET Framework

Hi
I want to include MSDE in my apps installation.
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
Deployment Toolkit (Release Candidate) from
http://www.microsoft.com/downloads/d...DisplayLang=en
I have looked into the deployment toolkit which need Microsoft .NET
Framework.
But my client does not want to install the .NET Framework.
How can I do it?
Many thanks
Ken
You have two options if you can't use the loader:
1) Create your own loader using a non-managed language (C++, Delphi, VB6).
2) You can purchase a third party installation package
Cheers,
Brian A. Randell
MCW Technologies
"Ken" <kenchan@.fdlweb.com> wrote in message
news:uW7GAP7JEHA.208@.tk2msftngp13.phx.gbl...
> Hi
> I want to include MSDE in my apps installation.
> Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
> Deployment Toolkit (Release Candidate) from
>
http://www.microsoft.com/downloads/d...DisplayLang=en
> I have looked into the deployment toolkit which need Microsoft .NET
> Framework.
> But my client does not want to install the .NET Framework.
> How can I do it?
> Many thanks
> Ken
>
|||Thanks.
I have installshield version 9. How can I do it?
Thanks a lot
Ken
"Brian A. Randell" <brianr@.nospam.mcwtech.com> wrote in message
news:%23kSlIh7JEHA.2660@.TK2MSFTNGP09.phx.gbl...
> You have two options if you can't use the loader:
> 1) Create your own loader using a non-managed language (C++, Delphi, VB6).
> 2) You can purchase a third party installation package
>
> Cheers,
> Brian A. Randell
> MCW Technologies
> "Ken" <kenchan@.fdlweb.com> wrote in message
> news:uW7GAP7JEHA.208@.tk2msftngp13.phx.gbl...
>
http://www.microsoft.com/downloads/d...DisplayLang=en
>
|||Sorry Ken, I'm not familiar enough with InstallShield to provide qualified
advice. Maybe you can check with the InstallSheild folks to see what the
recommend.
Cheers,
Brian A. Randell
MCW Technologies
"Ken" <kenchan@.fdlweb.com> wrote in message
news:erU75xQKEHA.1156@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Thanks.
> I have installshield version 9. How can I do it?
> Thanks a lot
> Ken
>
> "Brian A. Randell" <brianr@.nospam.mcwtech.com> wrote in message
> news:%23kSlIh7JEHA.2660@.TK2MSFTNGP09.phx.gbl...
VB6).
>
http://www.microsoft.com/downloads/d...DisplayLang=en
>

Install Error

I was using SQL 7. I uninstalled this and started installing SQL Server 2000 DEsktop Engine. However, install never goes thru and I get this message.
Any ideas would be appreciated.
ThanksHave you tried what the message says?|||This is what the READ ME file says.

3.1.4 Desktop Engine Setup Parameters

SQL Server Books Online topics "Merging the Desktop Engine into
Windows Installer" and "SQL Server 2000 Desktop Engine Setup"
document two parameters that are ignored by the final version
of the Desktop Engine Setup: USEDEFAULTSAPWD and SAPASSWORD.

By default, when run on the Microsoft Windows NT 4.0 or Windows
2000 operating system, the Desktop Engine Setup configures the
installed instance of Microsoft SQL Server to use Windows
Authentication, and places the Windows local administrator's group
in the SQL Server sysadmin fixed server role. When running Desktop
Engine Setup on the Windows NT 4.0 or Windows 2000 operating
system, you can specify a SECURITYMODE=SQL parameter to have the
installed instance configured to use SQL Server Authentication
with a null sa password. When run on the Windows 98 operating
system, the Desktop Engine Setup always configures the installed
instance to use SQL Server Authentication, regardless of whether
or not SECURITYMODE=SQL is specified.

A set of Desktop Engine merge modules that have been merged into
a Windows Installer setup has the same behavior. On the Windows
NT 4.0 and Windows 2000 operating systems, the instance of SQL
Server is configured to use Windows Authentication if
SECURITYMODE=SQL is not specified, and is configured to use SQL
Server Authentication if SECURITYMODE=SQL is specified. The
instance is always configured to use SQL Server Authentication
on the Windows 98 operating system.

You can specify SECURITYMODE=SQL in the same locations where you
can use USEDEFAULTSAPWD or SAPASSWORD. For more information, see
the SQL Server Books Online topics "Merging the Desktop Engine
into Windows Installer" and "SQL Server 2000 Desktop Engine Setup."

Anyway, under the SETUP.INI file, I placed SAPWD=<PASSWORD> and the installation went through.

:)

installation (instance name)

I am trying to install SqlServer PE on a WinXP desktop.
But I reach "install name" window where I am asked: "for a default
installation leave default checked..." and "to install a named instance clear
the default checkbox..." etc.
But the Default checkbox is grayed and I can just install a named instance.
What do I miss? I think it is not a user problem because I tryed with 2
different users (one is Administrator).
thanks in advanced for any feedback.
Hi
If Setup detects an already installed default instance, it will not let you
select the check box.
Maybe you have an instance of MSDE installed.
Look in Control Panel > Services to see if you have MSDE or SQL server
already installed.
Regards
Mike
"Francesco" wrote:

> I am trying to install SqlServer PE on a WinXP desktop.
> But I reach "install name" window where I am asked: "for a default
> installation leave default checked..." and "to install a named instance clear
> the default checkbox..." etc.
> But the Default checkbox is grayed and I can just install a named instance.
> What do I miss? I think it is not a user problem because I tryed with 2
> different users (one is Administrator).
> thanks in advanced for any feedback.
|||Correct. After the instance installation I have MSSQLSERVER and
MSSQL$my_instance. I suppose the first service is the engine that somebody
else installed previously... I'll try to remove the engine and start again.
Thanks.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> If Setup detects an already installed default instance, it will not let you
> select the check box.
> Maybe you have an instance of MSDE installed.
> Look in Control Panel > Services to see if you have MSDE or SQL server
> already installed.
> Regards
> Mike
> "Francesco" wrote:

installation (instance name)

I am trying to install SqlServer PE on a WinXP desktop.
But I reach "install name" window where I am asked: "for a default
installation leave default checked..." and "to install a named instance clear
the default checkbox..." etc.
But the Default checkbox is grayed and I can just install a named instance.
What do I miss? I think it is not a user problem because I tryed with 2
different users (one is Administrator).
thanks in advanced for any feedback.Hi
If Setup detects an already installed default instance, it will not let you
select the check box.
Maybe you have an instance of MSDE installed.
Look in Control Panel > Services to see if you have MSDE or SQL server
already installed.
Regards
Mike
"Francesco" wrote:
> I am trying to install SqlServer PE on a WinXP desktop.
> But I reach "install name" window where I am asked: "for a default
> installation leave default checked..." and "to install a named instance clear
> the default checkbox..." etc.
> But the Default checkbox is grayed and I can just install a named instance.
> What do I miss? I think it is not a user problem because I tryed with 2
> different users (one is Administrator).
> thanks in advanced for any feedback.|||Correct. After the instance installation I have MSSQLSERVER and
MSSQL$my_instance. I suppose the first service is the engine that somebody
else installed previously... I'll try to remove the engine and start again.
Thanks.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> If Setup detects an already installed default instance, it will not let you
> select the check box.
> Maybe you have an instance of MSDE installed.
> Look in Control Panel > Services to see if you have MSDE or SQL server
> already installed.
> Regards
> Mike
> "Francesco" wrote:
> > I am trying to install SqlServer PE on a WinXP desktop.
> > But I reach "install name" window where I am asked: "for a default
> > installation leave default checked..." and "to install a named instance clear
> > the default checkbox..." etc.
> >
> > But the Default checkbox is grayed and I can just install a named instance.
> > What do I miss? I think it is not a user problem because I tryed with 2
> > different users (one is Administrator).
> > thanks in advanced for any feedback.

installation (instance name)

I am trying to install SqlServer PE on a WinXP desktop.
But I reach "install name" window where I am asked: "for a default
installation leave default checked..." and "to install a named instance clea
r
the default checkbox..." etc.
But the Default checkbox is grayed and I can just install a named instance.
What do I miss? I think it is not a user problem because I tryed with 2
different users (one is Administrator).
thanks in advanced for any feedback.Hi
If Setup detects an already installed default instance, it will not let you
select the check box.
Maybe you have an instance of MSDE installed.
Look in Control Panel > Services to see if you have MSDE or SQL server
already installed.
Regards
Mike
"Francesco" wrote:

> I am trying to install SqlServer PE on a WinXP desktop.
> But I reach "install name" window where I am asked: "for a default
> installation leave default checked..." and "to install a named instance cl
ear
> the default checkbox..." etc.
> But the Default checkbox is grayed and I can just install a named instance
.
> What do I miss? I think it is not a user problem because I tryed with 2
> different users (one is Administrator).
> thanks in advanced for any feedback.|||Correct. After the instance installation I have MSSQLSERVER and
MSSQL$my_instance. I suppose the first service is the engine that somebody
else installed previously... I'll try to remove the engine and start again.
Thanks.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> If Setup detects an already installed default instance, it will not let yo
u
> select the check box.
> Maybe you have an instance of MSDE installed.
> Look in Control Panel > Services to see if you have MSDE or SQL server
> already installed.
> Regards
> Mike
> "Francesco" wrote:
>

Inserts per Second

SQL Server 2005;
What rank of inserts per second could be archived
on a modern desktop (1CPU/3GHz/1GB) hardware?
How this compare to a dedicated server hardware?
And most important question;
In a scenario when an applications writes received data to a database.
Which insert method would give the fastest results?
And which method do you recommended for actual use?
(bulk insert, asynchronous inserts, packaged inserts, or something else)
Thanks,
Mitja SemolicYour question is impossible to answer. There are too many variables.
Your "on a modern desktop" question --
Do you mean that you would have SQL Server installed on this "modern
desktop" and you would be inserting data locally?
Or do you mean that a client application would be running on this desktop
and inserting data to a SQL Server ON THE NETWORK?
How is your application written? How are your stored procedures or insert
statements? Do you SET NOCOUNT ON or do you receive the "n rows affected"
from your insert statement?
Did you drop the non-clustered indexes on your tables before running the
inserts?
If you want a super fast "just get the data in there" routine, BULK INSERT
is probably your fastest bet. If you want to be able to create an error
file you will need to use BCP. If you want to insert your data one row at a
time, read the file and call an insert stored procedure or build the T-SQL
within your application to perform the insert.
Keith Kratochvil
"Mitja Semolic" <mitja.semolic@.ensico.si> wrote in message
news:yTDcg.3320$oj5.1032258@.news.siol.net...
> SQL Server 2005;
> What rank of inserts per second could be archived
> on a modern desktop (1CPU/3GHz/1GB) hardware?
> How this compare to a dedicated server hardware?
> And most important question;
> In a scenario when an applications writes received data to a database.
> Which insert method would give the fastest results?
> And which method do you recommended for actual use?
> (bulk insert, asynchronous inserts, packaged inserts, or something else)
> Thanks,
> Mitja Semolic
>|||I was expecting an obsolete answer,
so I wondered if it was worth posting?
I don't want to confuse you with a simple question.
But are there any concrete benchmark result
that could showcase the SQL server performance
in different scenarios and different hardware?
Let me ask you a similar question:s
How fast a car can go, what is its track time?
How many frames per second can draw a graphics card for a specific game?
Are this questions also impossible to answer?
Some thinks should be left simple.
Mitja Semolic

Inserts per Second

SQL Server 2005;
What rank of inserts per second could be archived
on a modern desktop (1CPU/3GHz/1GB) hardware?
How this compare to a dedicated server hardware?
And most important question;
In a scenario when an applications writes received data to a database.
Which insert method would give the fastest results?
And which method do you recommended for actual use?
(bulk insert, asynchronous inserts, packaged inserts, or something else)
Thanks,
Mitja SemolicYour question is impossible to answer. There are too many variables.
Your "on a modern desktop" question --
Do you mean that you would have SQL Server installed on this "modern
desktop" and you would be inserting data locally?
Or do you mean that a client application would be running on this desktop
and inserting data to a SQL Server ON THE NETWORK?
How is your application written? How are your stored procedures or insert
statements? Do you SET NOCOUNT ON or do you receive the "n rows affected"
from your insert statement?
Did you drop the non-clustered indexes on your tables before running the
inserts?
If you want a super fast "just get the data in there" routine, BULK INSERT
is probably your fastest bet. If you want to be able to create an error
file you will need to use BCP. If you want to insert your data one row at a
time, read the file and call an insert stored procedure or build the T-SQL
within your application to perform the insert.
Keith Kratochvil
"Mitja Semolic" <mitja.semolic@.ensico.si> wrote in message
news:yTDcg.3320$oj5.1032258@.news.siol.net...
> SQL Server 2005;
> What rank of inserts per second could be archived
> on a modern desktop (1CPU/3GHz/1GB) hardware?
> How this compare to a dedicated server hardware?
> And most important question;
> In a scenario when an applications writes received data to a database.
> Which insert method would give the fastest results?
> And which method do you recommended for actual use?
> (bulk insert, asynchronous inserts, packaged inserts, or something else)
> Thanks,
> Mitja Semolic
>|||I was expecting an obsolete answer,
so I wondered if it was worth posting?
I don't want to confuse you with a simple question.
But are there any concrete benchmark result
that could showcase the SQL server performance
in different scenarios and different hardware?
Let me ask you a similar question:s
How fast a car can go, what is its track time?
How many frames per second can draw a graphics card for a specific game?
Are this questions also impossible to answer?
Some thinks should be left simple.
Mitja Semolic