MSDE setup / installation

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

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

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

MSDE problems

Hi!

I'm working on a website that will be a webshop in the end. I chosed MSDE as database for the project. Now I have a problem. When i want to have a counter (for the cusomers number for exampel) i can't turn autoincresement on. Well I can, but I can't save it. If i try I get an errormessage.
Why is it so and how will i get it to work?
I'm running the newest version...
Thanks for any help!What is the error message you are receiving?

In order to make a column an Identity column the data type must be integer and it may not allow nulls.

Terri|||I have translated the errormessage from swedish to english. I don't think it's absolutley correkt translated but i hope you will understand it anyway:
(And yes i have the column as Int and not allow nulls)

There was an error saving the design of this table. No changes were made.

[Microsoft][ODBC SQL server driver][SQL server] Unable to create standardvalue on colums with IDENTITY-attribut. Tabel 'tbkunder', column 'kundnummer.
[Microsoft][ODBC SQL server driver][SQL server] Unable to create restriction. Watch previous errormessage.|||This is very difficult with the language difference.

It sounds to me like you are trying to set the IDENTITY property on a column that has a Default Value set, which can't be done.

Terri

MSDE on Vista

Hi
I know that MS SQL Server 2000 versions (including MSDE) are not
supported on Windows Vista, but still I'd like to ask if anyone knows
why when MSDE is installed on Vista, each time after a user logs in
to Windows, the instalation dialog appears for few seconds.
The dialog title is the MSDE product name ("Microsoft SQL Server
Desktop Engine". The text in dialog is "Please wait while Windows
configures Microsoft SQL Server Desktop Engine". The dialog appears
regardless of UAC being on or off. Same dialog appears on Windows
Vista Basic and Windows Vista Premium.
If you know anything about it (how to get rid of it would be
great), then please do not hesitate to post here.
Hilarion
JPD <nospam@.nospam.com> wrote:
> As you said, MSDE is not supported on Windows Vista.
So? Does that mean that no one knows anything about MS SQL Server 2000
on Vista? I'm not asking for Microsoft's support help, I just hope that
someone out there had the same issue and figured out what is causing it
and how to deal with it.
I'd be grateful for any suggestions and/or ideas.

> Why don't you just download SQL Server 2005 Express? After all it is free.
The app, that I'm forced to use, uses MS SQL Server and is only supported
with 2000 edition.
I know that the problem I described does not appear with MS SQL 2005.
I know that Express Edition is free. I know how to install it on Vista
and how to copy the databases from MSDE to 2005 EE. I know how to ensure
that backward compatibility components (like SQL DMO) are installed,
but still I'd prefer not to be forced to move to 2005.
Hilarion
PS.: AFAIK MS SQL Server 2005 will officially be supported on Vista from
SP2 version (of MS SQL, not Vista), so the current version is not,
just as MSDE.
|||Hilarion,
SQL Server versions prior to SQL Server 2005 SP2 are not supported on Vista.
RLF
"Hilarion" <hilarion@.nomail.nospam> wrote in message
news:u0$2XUIyHHA.1576@.TK2MSFTNGP03.phx.gbl...
> JPD <nospam@.nospam.com> wrote:
> So? Does that mean that no one knows anything about MS SQL Server 2000
> on Vista? I'm not asking for Microsoft's support help, I just hope that
> someone out there had the same issue and figured out what is causing it
> and how to deal with it.
> I'd be grateful for any suggestions and/or ideas.
>
> The app, that I'm forced to use, uses MS SQL Server and is only supported
> with 2000 edition.
> I know that the problem I described does not appear with MS SQL 2005.
> I know that Express Edition is free. I know how to install it on Vista
> and how to copy the databases from MSDE to 2005 EE. I know how to ensure
> that backward compatibility components (like SQL DMO) are installed,
> but still I'd prefer not to be forced to move to 2005.
>
> Hilarion
> PS.: AFAIK MS SQL Server 2005 will officially be supported on Vista from
> SP2 version (of MS SQL, not Vista), so the current version is not,
> just as MSDE.
|||Russell Fields <russellfields@.nomail.com> wrote:
> SQL Server versions prior to SQL Server 2005 SP2 are not supported on Vista.
Is it not what I wrote here:
[vbcol=seagreen]
If you are referring to this:
[vbcol=seagreen]
then you are right, the current version IS supported. I somehow missed
SP2 release. My fault.
Hilarion
|||JPD <nospam@.nospam.com> wrote:
> FYI. SP2 for SQL Server 2005 has been released some time ago.
Yes, you are right. I somehow missed it's release. I apologise.
Still, the app I'm forced to use is not supported with SQL
Server 2005, so still I'd be grateful for any info regarding
strange behavior of MSDE on Vista.
Hilarion
|||Hilarion,
I believe we are saying we do not know how to get rid of the message since
MSDE (which is a version of SQL Server 2000) is not supported on Vista.
Why not? This has to do with the new security enhancements in Vista (I do
not remember the details) which is why even SQL Server 2005 needs SP2 in
order to work.
If you must continue to use MSDE, then you cannot use Vista. Scale back to
Windows XP.
RLF
"Hilarion" <hilarion@.nomail.nospam> wrote in message
news:uvBhrPTyHHA.4928@.TK2MSFTNGP03.phx.gbl...
> JPD <nospam@.nospam.com> wrote:
> Yes, you are right. I somehow missed it's release. I apologise.
> Still, the app I'm forced to use is not supported with SQL
> Server 2005, so still I'd be grateful for any info regarding
> strange behavior of MSDE on Vista.
>
> Hilarion
|||Or run that Vista-incompatible app in a Xp VPC on Vista. I do this for an
old version of QuickBooks we still use.
Ginny
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:OCBZckTyHHA.3940@.TK2MSFTNGP05.phx.gbl...
> Hilarion,
> I believe we are saying we do not know how to get rid of the message since
> MSDE (which is a version of SQL Server 2000) is not supported on Vista.
> Why not? This has to do with the new security enhancements in Vista (I do
> not remember the details) which is why even SQL Server 2005 needs SP2 in
> order to work.
> If you must continue to use MSDE, then you cannot use Vista. Scale back
> to Windows XP.
> RLF
> "Hilarion" <hilarion@.nomail.nospam> wrote in message
> news:uvBhrPTyHHA.4928@.TK2MSFTNGP03.phx.gbl...
>
|||Hi
Russell Fields wrote:
> I believe we are saying we do not know how to get rid of the message since
> MSDE (which is a version of SQL Server 2000) is not supported on Vista.
> Why not? This has to do with the new security enhancements in Vista (I do
> not remember the details) which is why even SQL Server 2005 needs SP2 in
> order to work.
I know that there are reasons behind no support for MS SQL 2000 on Vista
and I'm not arguing them nor the decision not to support it. I was just
asking if anyone knows the cause of described behavior.
The said instance of MSDE seems to be working fine on my Vista (regardless
of UAC being on or off). The only thing is this, and it looks like it's
related to the MSDE installation package, not to the MSDE itself.

> If you must continue to use MSDE, then you cannot use Vista. Scale back to
> Windows XP.
Can't. Have no license for Windows XP anymore.
Thank you for your feedback anyway, and I hope for more.
Hilarion
|||Ginny Caughey [MVP] wrote:
> Or run that Vista-incompatible app in a Xp VPC on Vista. I do this for an
> old version of QuickBooks we still use.
I still need license on Windows XP to use it VPC environment.
I'm stuck with Vista (and it - the Vista - really starts to annoy me,
and lack of support for MSDE on it is not the key issue here).
Thank you for your feedback anyway, and I hope for new ideas.
Hilarion
|||It appears that some registry entry that confirms that the installation is
completed is either not set or is missing altogether. Why check reg entries
for MSDE / Installation etc.
Microsoft should have supported at least MSDE 2000 on Vista. Though Vista
has major changes, it should have supported at least 1 version down the
compatibility tree. I don't think corporations are jumping in transition to
Vista. It took my company 4 years to give me an XP machine. Though making
Vista incompatible down the versions gets me some $$ as consultant, at
personal level I am also at loss as many of applications on my personal
laptop don't work with Vista. I don't know if any VB6 code works on it
(anyway that is not relevant to this newsgroup).
ThanQ...
"Hilarion" wrote:

> Hi
> Russell Fields wrote:
> I know that there are reasons behind no support for MS SQL 2000 on Vista
> and I'm not arguing them nor the decision not to support it. I was just
> asking if anyone knows the cause of described behavior.
> The said instance of MSDE seems to be working fine on my Vista (regardless
> of UAC being on or off). The only thing is this, and it looks like it's
> related to the MSDE installation package, not to the MSDE itself.
>
> Can't. Have no license for Windows XP anymore.
> Thank you for your feedback anyway, and I hope for more.
>
> Hilarion
>

MSDE merge modules

Hi
I wonder if anyone can help. I am looking for the MSDE merge modules to use
in a .net 2003 set up and deployment module. see
http://support.microsoft.com/kb/325004/EN-US/
However I have already installed SQL server standard edition on my
development server. How do I get these MSM's to merge into my MSI? Am I
barking up the wrong tree?
Thanking you in advance for any help
Richard
Hello,
Personally, I use the last setup of msde (sql2000.msi and I launch it
from my setup with a custom action.)
With that, I don't need to use the merge modules and if a custommer want
to use SQL Server instead, I don't need to change my setup (I don't need
to install MSDE and just connect to sql server and it will work.)
I can give all the parameters to msiexec (or to the property table of
the msi).
Marc Allard
Allcomp
Richard Wilde wrote:
> Hi
> I wonder if anyone can help. I am looking for the MSDE merge modules to use
> in a .net 2003 set up and deployment module. see
> http://support.microsoft.com/kb/325004/EN-US/
> However I have already installed SQL server standard edition on my
> development server. How do I get these MSM's to merge into my MSI? Am I
> barking up the wrong tree?
> Thanking you in advance for any help
> Richard
>
|||Hi
I am interested in how you do this. You suggest that you can supply the
paramters to msiexec or the property table of MSI? Please can you point me
in the right direction.
After the instance has been created how do you then create the database and
insert any data?
Thank you for your help so far.
Richard
"Allcomp" <marc@.nospam.allcomp.be> wrote in message
news:41e4d0e0$0$329$ba620e4c@.news.skynet.be...[vbcol=seagreen]
> Hello,
> Personally, I use the last setup of msde (sql2000.msi and I launch it from
> my setup with a custom action.)
> With that, I don't need to use the merge modules and if a custommer want
> to use SQL Server instead, I don't need to change my setup (I don't need
> to install MSDE and just connect to sql server and it will work.)
> I can give all the parameters to msiexec (or to the property table of the
> msi).
> Marc Allard
> Allcomp
> Richard Wilde wrote:
|||Hello,
Here is how I do that ...
1) Create a
property MSIExecPos
Value : msiexec
in the table property of the msi file (or the merge module)
2) Create a custom action
InstallMsde
Type : 114 (to ignore the return code because in Win98 sometimes the
return code is not 0 so you have problems).
source : MsiExecPos
Target
/i "MSDE\Sql2000.msi" /qb /l c:\msde.log
Personally, I put the full MSDE installation directory into a sub
directory MSDE so the root of my CD is cleaner
3) In the InstallUISequence (you have tu use InstallUISequence or the
installation won't work)
You add the action
InstallMsde
You can put a install condition or not
For the sequence, you put something in the end (1305 in my case).
After that, you can change the parameters of the MSDE file
In the property table, you put
REBOOT Value : ReallySuppress
to avoid a reboot prompt after the installation of MSDE
INSTANCENAME value : NameofYourInstance
I believe that it is necessary because if a custommer has already MSDE
installed, then you will run into very big problems to install your software
DISABLENETWORKPROTOCOLSValue : 0
If you don't do it, your server will only work locally.
SqlSaPwdValue : YourPassword
I think it is better to pass it directly in the custom action instead of
the property table.
Normally with that, all should be fine
Marc Allard
Allcomp
Richard Wilde wrote:
> Hi
> I am interested in how you do this. You suggest that you can supply the
> paramters to msiexec or the property table of MSI? Please can you point me
> in the right direction.
> After the instance has been created how do you then create the database and
> insert any data?
> Thank you for your help so far.
> Richard
> "Allcomp" <marc@.nospam.allcomp.be> wrote in message
> news:41e4d0e0$0$329$ba620e4c@.news.skynet.be...
>
>

MSDE installation problems

hi

i have downloaded the free MSDERelA from the official website but when i wanna run the installation, it says

"A strong SA password is needed for security reasons.Please use the SAPWD switch to supply the same"

i read the readme doc but i still cant understand how to install n where to find the SAPWD switch ??

Please guide me
Thank you very muchInstructions here

MSDE Installation Help

Hi
I am trying to instal MSDE 2000 on a Windows XP Pro SP2 machine. I type in
....
"Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR SA
PASSWORD>" at the command prompt and the MSDE setup begins to take place. At
the nearly the end of the install, I get a pop-up dialog stating the the
instalation failed.
I checked setupapi.log file under C:\winnt and the follwoing error was in
their...
"
[2005/01/03 21:29:08 2672.1]
#-199 Executing "C:\Documents and Settings\Owner\Local
Settings\Temp\IXP000.TMP\dasetup.exe" with command line: /Q /N
#E077 Could not locate a non-empty section [DefaultInstall] when calculating
disk space in "C:\Documents and Settings\Owner\Local
Settings\Temp\IXP000.TMP\noop.inf". Error 0xe0000102: The required line was
not found in the INF."
Anyone have any ideas as to what the above means. Also, I checked the
dasetup.log file that was created when attempting to install MSDE and I
noticed the following...
: ****************************************
: * Beginning of Install *
: ****************************************
Starting Install: Current Date/Time (U.S. Local Time): 01/03/2005 : 21:29:07
Path: C:\WINNT;C:\WINNT\system32;
Localization: Machine Locale set to: English_United States.1252
Command Line Parameters:
Suppress Reboot: 0
Quiet/Silent Mode: 1
Logging Level: 3
INI File: dasetup.ini
Windows Directory: C:\WINNT
Progress: Loading Resource Library.
Progress: Parsing INI File.
*************************:
** Begin INI File Dump **:
*************************:
Ini Section: General
: ProductName = Microsoft Data Access Components 2.7
: ProductBuild = 2.71.9040.2
: ProductUrl = http://www.microsoft.com/data
: ProductVersionKey = SOFTWARE\Microsoft\DataAccess
: ProductVersionValue = FullInstallVer
: InstanceName = MDAC
: CheckInUseFiles = 1
: EULAFile = MDACEULA.RTF
: EULAType = rtf
: SupportsTS = 1
: SupportsMUI = 0
: CheckForDiskSpace = 1
: ValidOs = 4294967295
I find it starnge that the install is trying to use MDAC 2.7 when I
currently have MDAC 2.8 SP1 installed on my machine (I verified this through
the MDAC compcheck app).
Anyone have any ideas as to what is going on?
PS Sorry for the long message
Thanks
I also found this error in the dahotfix.log
"
[05:03:12]: An error occurred while setup was trying to verify the version
of Microsoft Data Access Components current installed on the machine.
Either the version currently installed does not match the version of this
hotfix package, or setup was unable to determine the version currently
installed.
["
"John Rydenbark" wrote:

> Hi
> I am trying to instal MSDE 2000 on a Windows XP Pro SP2 machine. I type in
> ...
> "Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR SA
> PASSWORD>" at the command prompt and the MSDE setup begins to take place. At
> the nearly the end of the install, I get a pop-up dialog stating the the
> instalation failed.
> I checked setupapi.log file under C:\winnt and the follwoing error was in
> their...
> "
> [2005/01/03 21:29:08 2672.1]
> #-199 Executing "C:\Documents and Settings\Owner\Local
> Settings\Temp\IXP000.TMP\dasetup.exe" with command line: /Q /N
> #E077 Could not locate a non-empty section [DefaultInstall] when calculating
> disk space in "C:\Documents and Settings\Owner\Local
> Settings\Temp\IXP000.TMP\noop.inf". Error 0xe0000102: The required line was
> not found in the INF."
> Anyone have any ideas as to what the above means. Also, I checked the
> dasetup.log file that was created when attempting to install MSDE and I
> noticed the following...
> : ****************************************
> : * Beginning of Install *
> : ****************************************
> Starting Install: Current Date/Time (U.S. Local Time): 01/03/2005 : 21:29:07
> Path: C:\WINNT;C:\WINNT\system32;
> Localization: Machine Locale set to: English_United States.1252
> Command Line Parameters:
> Suppress Reboot: 0
> Quiet/Silent Mode: 1
> Logging Level: 3
> INI File: dasetup.ini
> Windows Directory: C:\WINNT
> Progress: Loading Resource Library.
> Progress: Parsing INI File.
> *************************:
> ** Begin INI File Dump **:
> *************************:
> Ini Section: General
> : ProductName = Microsoft Data Access Components 2.7
> : ProductBuild = 2.71.9040.2
> : ProductUrl = http://www.microsoft.com/data
> : ProductVersionKey = SOFTWARE\Microsoft\DataAccess
> : ProductVersionValue = FullInstallVer
> : InstanceName = MDAC
> : CheckInUseFiles = 1
> : EULAFile = MDACEULA.RTF
> : EULAType = rtf
> : SupportsTS = 1
> : SupportsMUI = 0
> : CheckForDiskSpace = 1
> : ValidOs = 4294967295
> I find it starnge that the install is trying to use MDAC 2.7 when I
> currently have MDAC 2.8 SP1 installed on my machine (I verified this through
> the MDAC compcheck app).
> Anyone have any ideas as to what is going on?
> PS Sorry for the long message
> Thanks
>

MSDE Installation Help

Hi
I am trying to instal MSDE 2000 on a Windows XP Pro SP2 machine. I type in
...
"Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR SA
PASSWORD>" at the command prompt and the MSDE setup begins to take place. At
the nearly the end of the install, I get a pop-up dialog stating the the
instalation failed.
I checked setupapi.log file under C:\winnt and the follwoing error was in
their...
"
[2005/01/03 21:29:08 2672.1]
#-199 Executing "C:\Documents and Settings\Owner\Local
Settings\Temp\IXP000.TMP\dasetup.exe" with command line: /Q /N
#E077 Could not locate a non-empty section [DefaultInstall] when calcula
ting
disk space in "C:\Documents and Settings\Owner\Local
Settings\Temp\IXP000.TMP\noop.inf". Error 0xe0000102: The required line was
not found in the INF."
Anyone have any ideas as to what the above means. Also, I checked the
dasetup.log file that was created when attempting to install MSDE and I
noticed the following...
: ****************************************
: * Beginning of Install *
: ****************************************
Starting Install: Current Date/Time (U.S. Local Time): 01/03/2005 : 21:29:07
Path: C:\WINNT;C:\WINNT\system32;
Localization: Machine Locale set to: English_United States.1252
Command Line Parameters:
Suppress Reboot: 0
Quiet/Silent Mode: 1
Logging Level: 3
INI File: dasetup.ini
Windows Directory: C:\WINNT
Progress: Loading Resource Library.
Progress: Parsing INI File.
*************************:
** Begin INI File Dump **:
*************************:
Ini Section: General
: ProductName = Microsoft Data Access Components 2.7
: ProductBuild = 2.71.9040.2
: ProductUrl = http://www.microsoft.com/data
: ProductVersionKey = SOFTWARE\Microsoft\DataAccess
: ProductVersionValue = FullInstallVer
: InstanceName = MDAC
: CheckInUseFiles = 1
: EULAFile = MDACEULA.RTF
: EULAType = rtf
: SupportsTS = 1
: SupportsMUI = 0
: CheckForDiskSpace = 1
: ValidOs = 4294967295
I find it starnge that the install is trying to use MDAC 2.7 when I
currently have MDAC 2.8 SP1 installed on my machine (I verified this through
the MDAC compcheck app).
Anyone have any ideas as to what is going on?
PS Sorry for the long message
ThanksI also found this error in the dahotfix.log
"
[05:03:12]: An error occurred while setup was trying to verify the versi
on
of Microsoft Data Access Components current installed on the machine.
Either the version currently installed does not match the version of this
hotfix package, or setup was unable to determine the version currently
installed.
["
"John Rydenbark" wrote:

> Hi
> I am trying to instal MSDE 2000 on a Windows XP Pro SP2 machine. I type in
> ...
> "Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR
SA
> PASSWORD>" at the command prompt and the MSDE setup begins to take place.
At
> the nearly the end of the install, I get a pop-up dialog stating the the
> instalation failed.
> I checked setupapi.log file under C:\winnt and the follwoing error was in
> their...
> "
> [2005/01/03 21:29:08 2672.1]
> #-199 Executing "C:\Documents and Settings\Owner\Local
> Settings\Temp\IXP000.TMP\dasetup.exe" with command line: /Q /N
> #E077 Could not locate a non-empty section [DefaultInstall] when calcu
lating
> disk space in "C:\Documents and Settings\Owner\Local
> Settings\Temp\IXP000.TMP\noop.inf". Error 0xe0000102: The required line wa
s
> not found in the INF."
> Anyone have any ideas as to what the above means. Also, I checked the
> dasetup.log file that was created when attempting to install MSDE and I
> noticed the following...
> : ****************************************
> : * Beginning of Install *
> : ****************************************
> Starting Install: Current Date/Time (U.S. Local Time): 01/03/2005 : 21:29:
07
> Path: C:\WINNT;C:\WINNT\system32;
> Localization: Machine Locale set to: English_United States.1252
> Command Line Parameters:
> Suppress Reboot: 0
> Quiet/Silent Mode: 1
> Logging Level: 3
> INI File: dasetup.ini
> Windows Directory: C:\WINNT
> Progress: Loading Resource Library.
> Progress: Parsing INI File.
> *************************:
> ** Begin INI File Dump **:
> *************************:
> Ini Section: General
> : ProductName = Microsoft Data Access Components 2.7
> : ProductBuild = 2.71.9040.2
> : ProductUrl = http://www.microsoft.com/data
> : ProductVersionKey = SOFTWARE\Microsoft\DataAccess
> : ProductVersionValue = FullInstallVer
> : InstanceName = MDAC
> : CheckInUseFiles = 1
> : EULAFile = MDACEULA.RTF
> : EULAType = rtf
> : SupportsTS = 1
> : SupportsMUI = 0
> : CheckForDiskSpace = 1
> : ValidOs = 4294967295
> I find it starnge that the install is trying to use MDAC 2.7 when I
> currently have MDAC 2.8 SP1 installed on my machine (I verified this throu
gh
> the MDAC compcheck app).
> Anyone have any ideas as to what is going on?
> PS Sorry for the long message
> Thanks
>

Msde installation

hi

I am trying to install msde through my .net application.Before that i wnat to check if that instance already exist or not.Can any tell me how i can do that

regards
Dhanya

Try navigating through all the keys under HKEY_CLASSES_ROOT\Installer\Products and check for the key ProductName which contains text "Microsoft SQL Server Desktop Engine". If you can find one, it means that the MSDE is already installed.

And if you are looking for a code snippet then the following may help you

C# SAMPLE
public static bool IsMsdeInstalled()
{
Microsoft.Win32.RegistryKey Key = Microsoft.Win32.Registry.ClassesRoot.OpenSubKey("Installer").OpenSubKey("Products");
foreach (string _key in Key.GetSubKeyNames())
{
string value = Key.OpenSubKey(_key).GetValue("ProductName").ToString();
if(value.Contains("Microsoft SQL Server Desktop Engine"))
return true;
}
return false;
}

VB.NET SAMPLE

Public Shared Function IsMsdeInstalled() As Boolean
Dim Key As Microsoft.Win32.RegistryKey = Microsoft.Win32.Registry.ClassesRoot.OpenSubKey("Installer").OpenSubKey("Products")
For Each _key As String In Key.GetSubKeyNames()
Dim value As String = Key.OpenSubKey(_key).GetValue("ProductName").ToString()
If value.Contains("Microsoft SQL Server Desktop Engine") Then
Return True
End If
Next
Return False
End Function

msde INSTALLATION

Hi

I am trying to install the MSDE.
I followed the steps on this page http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1
on running the setup I get a message showing that the following instance is not valid and it doesn't install the MSDE.

Could somebody help me.

AkshatOK. what's your computer's name?
what command line are you specifying, exactly?|||Thanx for the message.
Computer Name=Akshat

Setup SAPWD=hello SecurityMode=SQL

These are mentioned on the webpage for installation so I just followed them.

http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1

Akshat

MSDE Installation

Hi!

I have a big problem installing msde on an XP Pro. When I try to install (run setup), the process starts and when its nearly finished the progess bar goes quickly down.
There is no error msg or something like that. The event no is 11708 (msi information).

I tried setup with many differnt parameters SAPWD=... Always the same: When quite finished installing, it ends.

I looked now for many hours in the forum and did not find any help.
Does anyone have a good solution ?

thxTry fully removing the current installation, if it's in Add/Remove programs - then, try following this tutorial:
http://aspnet101.com/aspnet101/tutorials.aspx?id=44

If this doesn't work, I'd say, offhand, that you might have some computer problems/issues. If you have Norton's - try running their utilities on your computer to see if anything turns up.

MSDE for Win CE

Hi
I am looking for MSDE for Win CE.
Any clue of how to get that version
Thank you,
Shmuel Shulman
SBS Technologies LTD
hi,
S Shulman wrote:
> Hi
> I am looking for MSDE for Win CE.
> Any clue of how to get that version
> Thank you,
> Shmuel Shulman
> SBS Technologies LTD
there's no MSDE for Win CE, but SQL Server CE...
http://msdn.microsoft.com/library/de..._server_ce.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply