MSDE and installing MS SQL server 2000

Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE. I
read the installation manual but couldn't find the answer:-;
Question:
I've a server running MSDE latest patches etc.
I just purchaced MS SQL server 2000 standaard edition.
Does the installation of MS sql 2000 server takes care of copying and using
the old MSDE database(s)?
There is one application using MSDE with MSSQLSERVER as named instance, I
Think :-?
Or do i need to desintall MSDE?
Thanks for the time
Hi,
SQL Server standard edition Installation will not copy the existing
databases. Databases
you need to copy manually.
Easy approach is:-
1. Install SQL 2000 with same service pack in new machine as old
2. Stop MSSQL Server and SQL Agent service is Old server as well as in new
server
3. Copy MDF and LDF files to the new server (Incluing system databases -
Master, msdb, tempdb, model),
It is a must that you should copy the folders to same folders
as in old server
4. Start MSSQl Server service in new server
5. Login to Query Analyzer in new machine and change the SQL server name
select @.@.servername
-- The name should be old server name
Execute below script to change the server name, this step is no required
if you do not want to change server name.
sp_dropserver <servername>
go
sp_addserver <newserver_name>,local
6. Stop and start MSSQL Server and SQl agent service. Login to Enterprise
manager and see whether all your databases are up.
Note:
Ensure that you install the new SQL server with the same directory structure
as old and copy the MDF and LDF to the same folders. otherwise the database
will not come online.
You can also look into the below links to move the databases.
move the data via backup and restore
http://support.microsoft.com/default...;en-us;Q304692
sp_detach_db and sp_attach_db
http://support.microsoft.com/support.../q224/0/71.asp
one more option -- the copy database wizard
http://support.microsoft.com/default...;en-us;Q274463
PRB: User Logon and/or Permission Errors After Restoring Dump (Q168001)
http://support.microsoft.com/default...;en-us;Q168001
Thanks
Hari
SQL Server MVP
"lau" <lau@.discussions.microsoft.com> wrote in message
news:66F50CDB-4DED-4E50-B7FE-45E0CE5AFCA4@.microsoft.com...
> Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE.
> I
> read the installation manual but couldn't find the answer:-;
> Question:
> I've a server running MSDE latest patches etc.
> I just purchaced MS SQL server 2000 standaard edition.
> Does the installation of MS sql 2000 server takes care of copying and
> using
> the old MSDE database(s)?
> There is one application using MSDE with MSSQLSERVER as named instance, I
> Think :-?
>
> Or do i need to desintall MSDE?
> Thanks for the time
>

MSDE and installing MS SQL server 2000

Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE. I
read the installation manual but couldn't find the answer:-;
Question:
I've a server running MSDE latest patches etc.
I just purchaced MS SQL server 2000 standaard edition.
Does the installation of MS sql 2000 server takes care of copying and using
the old MSDE database(s)?
There is one application using MSDE with MSSQLSERVER as named instance, I
Think :-?
Or do i need to desintall MSDE?
Thanks for the timeHi,
SQL Server standard edition Installation will not copy the existing
databases. Databases
you need to copy manually.
Easy approach is:-
1. Install SQL 2000 with same service pack in new machine as old
2. Stop MSSQL Server and SQL Agent service is Old server as well as in new
server
3. Copy MDF and LDF files to the new server (Incluing system databases -
Master, msdb, tempdb, model),
It is a must that you should copy the folders to same folders
as in old server
4. Start MSSQl Server service in new server
5. Login to Query Analyzer in new machine and change the SQL server name
select @.@.servername
-- The name should be old server name
Execute below script to change the server name, this step is no required
if you do not want to change server name.
sp_dropserver <servername>
go
sp_addserver <newserver_name>,local
6. Stop and start MSSQL Server and SQl agent service. Login to Enterprise
manager and see whether all your databases are up.
Note:
Ensure that you install the new SQL server with the same directory structure
as old and copy the MDF and LDF to the same folders. otherwise the database
will not come online.
----
--
You can also look into the below links to move the databases.
move the data via backup and restore
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q304692
sp_detach_db and sp_attach_db
http://support.microsoft.com/support/kb/articles/q224/0/71.asp
one more option -- the copy database wizard
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274463
PRB: User Logon and/or Permission Errors After Restoring Dump (Q168001)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q168001
Thanks
Hari
SQL Server MVP
"lau" <lau@.discussions.microsoft.com> wrote in message
news:66F50CDB-4DED-4E50-B7FE-45E0CE5AFCA4@.microsoft.com...
> Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE.
> I
> read the installation manual but couldn't find the answer:-;
> Question:
> I've a server running MSDE latest patches etc.
> I just purchaced MS SQL server 2000 standaard edition.
> Does the installation of MS sql 2000 server takes care of copying and
> using
> the old MSDE database(s)?
> There is one application using MSDE with MSSQLSERVER as named instance, I
> Think :-?
>
> Or do i need to desintall MSDE?
> Thanks for the time
>

MSDE and installing MS SQL server 2000

Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE. I
read the installation manual but couldn't find the answer:-;
Question:
I've a server running MSDE latest patches etc.
I just purchaced MS SQL server 2000 standaard edition.
Does the installation of MS sql 2000 server takes care of copying and using
the old MSDE database(s)?
There is one application using MSDE with MSSQLSERVER as named instance, I
Think :-?
Or do i need to desintall MSDE?
Thanks for the timeHi,
SQL Server standard edition Installation will not copy the existing
databases. Databases
you need to copy manually.
Easy approach is:-
1. Install SQL 2000 with same service pack in new machine as old
2. Stop MSSQL Server and SQL Agent service is Old server as well as in new
server
3. Copy MDF and LDF files to the new server (Incluing system databases -
Master, msdb, tempdb, model),
It is a must that you should copy the folders to same folders
as in old server
4. Start MSSQl Server service in new server
5. Login to Query Analyzer in new machine and change the SQL server name
select @.@.servername
-- The name should be old server name
Execute below script to change the server name, this step is no required
if you do not want to change server name.
sp_dropserver <servername>
go
sp_addserver <newserver_name>,local
6. Stop and start MSSQL Server and SQl agent service. Login to Enterprise
manager and see whether all your databases are up.
Note:
Ensure that you install the new SQL server with the same directory structure
as old and copy the MDF and LDF to the same folders. otherwise the database
will not come online.
----
--
You can also look into the below links to move the databases.
move the data via backup and restore
http://support.microsoft.com/defaul...b;en-us;Q304692
sp_detach_db and sp_attach_db
http://support.microsoft.com/suppor...s/q224/0/71.asp
one more option -- the copy database wizard
http://support.microsoft.com/defaul...b;en-us;Q274463
PRB: User Logon and/or Permission Errors After Restoring Dump (Q168001)
http://support.microsoft.com/defaul...b;en-us;Q168001
Thanks
Hari
SQL Server MVP
"lau" <lau@.discussions.microsoft.com> wrote in message
news:66F50CDB-4DED-4E50-B7FE-45E0CE5AFCA4@.microsoft.com...
> Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE.
> I
> read the installation manual but couldn't find the answer:-;
> Question:
> I've a server running MSDE latest patches etc.
> I just purchaced MS SQL server 2000 standaard edition.
> Does the installation of MS sql 2000 server takes care of copying and
> using
> the old MSDE database(s)?
> There is one application using MSDE with MSSQLSERVER as named instance, I
> Think :-?
>
> Or do i need to desintall MSDE?
> Thanks for the time
>

MSDE 2000 SP3a install failure

I am getting an error when installing SP3a of MSDE. I get the error message "The instance name specified is invalid." This is the first SQL database installed, so there is no instance name. I have tried "default" and "MSSQLSERVER" as instance names without success.

your help is appreciated.the instance name is "MSDE"

Why is this not in the setup documentation?

MSDE 2000 SP3 Merge Module does not installing on windowx XP

Dear Sirs.
MSDE 2000 SP 3a Merge Module Does not installing on Windows XP Without XP
Service Pack.
It is work if SP1 is instaled on Windows XP. But how i can use that merge
modules if SP1 is not installed on Windows XP ?
Thank you in advance.
Install SP1 on Windows XP. You can generally do this if it's a legal copy.
"Irakli Lomidze" <Irakli_Lomidze@.access.sanet.ge> wrote in message
news:uzsiaVNuEHA.2196@.TK2MSFTNGP14.phx.gbl...
> Dear Sirs.
> MSDE 2000 SP 3a Merge Module Does not installing on Windows XP Without XP
> Service Pack.
> It is work if SP1 is instaled on Windows XP. But how i can use that merge
> modules if SP1 is not installed on Windows XP ?
> Thank you in advance.
>

MSDE 2000 Release A

I am having problems installing the MSDE 2000 Release A on my Computer. I am
not able to find the Microsoft SQL Server Program when I go to Start-Program.
Can you please tell me a Simple Installation Process for MSDE 2000 Release A.
Thanks.
Hi,
MSDE does not install any shotcuts as it is just the engine and has no tools
that ship with it.
"TAP" <TAP@.discussions.microsoft.com> wrote in message
news:C29639C0-3911-4867-A88B-6EE988445A02@.microsoft.com...
>I am having problems installing the MSDE 2000 Release A on my Computer. I
>am
> not able to find the Microsoft SQL Server Program when I go to
> Start-Program.
> Can you please tell me a Simple Installation Process for MSDE 2000 Release
> A.
> Thanks.

MSDE 2000 on a Domain Controller

Hello everyone, I have searched the forum regarding this topic and have found numerous good threads about installing SQL Express on a DC. My question is, I am assuming that if installing SQL Express on a Domain Controller is not recommended, that installing the MSDE 2000 on a Domain Controller is not recommended either?

Thanks in advance to all replies!

Tim

Yes, it is not recommended.

However, Microsoft Small Business Server does make an exception and install MSDE (previous versions of SBS) or SQL Express on the DC.

The primary reason for the current recommendation is due to traffic. For MSDE, it was for security and traffic.

|||

Thanks Arnie, that is what I thought.

Tim

MSDE 2000 installation on XP

We're having trouble installing MSDE 2000 on two machines here. They were Win98, upgraded to XP Professional using the upgrade CD labelled 'version 2002'. If we run MSDE installation the routine goes virtually to the end, then the progress bar runs backwards down to zero and the product is not installed. As an experiment we installed XP Pro from a full install (as opposed to upgrade) CD and then ran the MSDE installation, and it worked just fine on the same machine. Problem is we've sold these as XP Pro upgrades and so we don't have keys to install full version for the customer. The verbose log informs me that the installation failed but not clearly why (there's almost 3.5Mb of it).

I realise this might not be enough for anyone to help, but I was hoping that the reverse progress bar might be something someone else has experienced. The machines are Celeron 700 or 766, one has 64Mb the other has 128Mb, 20Gb HDDs with plenty (>18Gb) available. All ideas greatly appreciated.The following article addresses your issue:

MSDN Article (http://support.microsoft.com/default.aspx?scid=kb;EN-US;q313939)

Good luck.|||Thank you very much. I'll try that out - looks like it will do the trick as we didn't specifically have file and print sharing loaded.|||Originally posted by theosgb
Thank you very much. I'll try that out - looks like it will do the trick as we didn't specifically have file and print sharing loaded.

We had the same problem here. Once we ran lodctr /r:PrefStringBackup.ini we were able to install the software.|||Hi,
Would you please give me more details on this command.
Your immidiate response is truly appreciated.
Kal

Originally posted by csturgeon
We had the same problem here. Once we ran lodctr /r:PrefStringBackup.ini we were able to install the software.|||I found info on lodctr /r:PrefStringBackup.ini at this URL I don't see how it relates to an XP install problem. It appears to relate to an MSDE install problem on all NT OSes. But, I did NOT read all it said.

Tim S

http://support.microsoft.com/default.aspx?scid=kb;en-us;315083|||Originally posted by TimS
I found info on lodctr /r:PrefStringBackup.ini at this URL I don't see how it relates to an XP install problem. It appears to relate to an MSDE install problem on all NT OSes. But, I did NOT read all it said.

Tim S

http://support.microsoft.com/default.aspx?scid=kb;en-us;315083

We have found that when a user upgrades from 98/ME to XP. the performance counters get messed up. Once the counters are gone, MSDE will not go on. Running this command reset the counters thereby allowing MSDE to be installed.|||I got past the install after running the LODCTR command and then enabling File and Print Sharing. THANK you guys for all the help .

Best regards,
Kal

MSDE 1.0 TO MSDE 2000 Release A

I've used MSDE 1.0 for a number of years.
Today I downloaded Release A with the intention of installing it, but when I
attempt to run Setup I get a dialog saying "The instance name specified is
invalid." What could be causing this?
Also... what impact will an installation of MSDE 2000 have on my existing
MSDE 1.0 databases? Is there a procedure I should be following?
Thanks in advance.
Nancy
hi Nancy,
"Nancy Lorieau" <NancyLorieau@.discussions.microsoft.com> ha scritto nel
messaggio news:81D8BF32-88C8-4F0C-AE24-0C8BCC213BC5@.microsoft.com...
> I've used MSDE 1.0 for a number of years.
> Today I downloaded Release A with the intention of installing it, but when
I
> attempt to run Setup I get a dialog saying "The instance name specified is
> invalid." What could be causing this?
>
personally I never "upgraded" MSDE 1.0 instance to MSDE 2000 ... I always
backedup the users database and restored them on the MSDE2000 new instance
after uninstalling MSDE 1.0.. but I had no reason to maintain the MSDE 1.0
instance at all...
anyway,
http://msdn.microsoft.com/library/de...stsql_84xl.asp
reports you have to add the
UPGRADE=1 UPGRADEUSER=username UPGRADEPWD=userpwd
commandline parameters to your call to the setup.exe bootstrap installer...

> Also... what impact will an installation of MSDE 2000 have on my existing
> MSDE 1.0 databases? Is there a procedure I should be following?
the users databases will be upgraded to MSDE 2000 level... you coul'd be
affected by cross database ownership chaining, which behaviour has been
changed... further info at
http://msdn.microsoft.com/library/de...onfig_8d7m.asp
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

MSDE & SQL Server 2005 Mobile Server Tools problem

After installing MSDE(with SP4) and SQL Server 2000 SP4 Replication Components, the SQL Server 2005 Mobile Server Tools installation fails when running the System Configuration Check with a SQL Server requirement Error.

"You must first install the Replication Components for SQL Server 2000 SP 3a or higher or the SQL Server 2005 Replication Components"

Am I getting this error because I'm using the Desktop Engine version of the SQL Server 2000?

We have NOT tested SQL CE/Mobile Merge Replication with MSDE. And, we dont know the problems you may face.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

I've been using MSDE with SQL CE 2.0 without any problems.

With the release of Windows Mobile 5.0 I had to upgrade my applications using VS 2005 and start using SQL Server 2005 Mobile Edition instead of SQL CE2.0.

With SQL Server 2005 Express Edition things changed a little bit, because this version only works as a Subscriber when using Replication (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp).

The scenario is quite simple. After installing MSDE(SP4) in Windows XP Professional(SP2) and installing Microsoft SQL Server 2000 SP4 Replication Components and Microsoft .NET Framework 2.0 I try to install the SQL Server 2005 Mobile Server Tools, but during the System Configuration Check that error is displayed.

|||Any tips on how it can be achieved? MSDE - SqlCE merge replication I mean.
There is a problem which I'm trying to solve for quite some time:
SQL Server 2000 - SqlCE merge replication works just fine, but in MSDE -SqlCE scenario it seems to be some trouble.
I always get the same error: 29045 - reconciler has failed. Basically it means, that SqlCE server agent cannot start Reconciler under MSDE. What can cause such a disaster? Incompatibility of components used? This isnt connectivity or access rights issue, i'm pretty sure of it.
I've tried to use different versions of MSDE: MSDE SP4 and MSDE SP3a. Searching in different newsgroups for a couple of hours makes me think that older versions of MSDE are more suitable for my task because few posts stated that merge replication works on MSDE SP3a, but this subject isnt covered in detail. Can you provide any help?
|||

READ MY POST YESTERDAY

we are all waiting for Microsoft to bring this function

I will pay for it as you probably will as well

I dont understand why we are the only developers putting pressure on this matter

We need help. The other case is that we can begin referring other 3rd party non microsoft providers....

|||

You need to get onto my post and tell them you want it too

|||

If you are looking for SQL Mobile/SQL Ev to SQL Server synchronization you need to have either SQL Server 2000 or SQL Server 2005 Standard Edition and above.

Thanks

Laxmi Narsimha Rao ORUGNATI, MSFT, SQL Everywhere (SQL Ev), Microsoft Corp.

MSDE & SQL Server 2005 Mobile Server Tools problem

After installing MSDE(with SP4) and SQL Server 2000 SP4 Replication Components, the SQL Server 2005 Mobile Server Tools installation fails when running the System Configuration Check with a SQL Server requirement Error.

"You must first install the Replication Components for SQL Server 2000 SP 3a or higher or the SQL Server 2005 Replication Components"

Am I getting this error because I'm using the Desktop Engine version of the SQL Server 2000?

We have NOT tested SQL CE/Mobile Merge Replication with MSDE. And, we dont know the problems you may face.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

I've been using MSDE with SQL CE 2.0 without any problems.

With the release of Windows Mobile 5.0 I had to upgrade my applications using VS 2005 and start using SQL Server 2005 Mobile Edition instead of SQL CE2.0.

With SQL Server 2005 Express Edition things changed a little bit, because this version only works as a Subscriber when using Replication (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp).

The scenario is quite simple. After installing MSDE(SP4) in Windows XP Professional(SP2) and installing Microsoft SQL Server 2000 SP4 Replication Components and Microsoft .NET Framework 2.0 I try to install the SQL Server 2005 Mobile Server Tools, but during the System Configuration Check that error is displayed.

|||Any tips on how it can be achieved? MSDE - SqlCE merge replication I mean.
There is a problem which I'm trying to solve for quite some time:
SQL Server 2000 - SqlCE merge replication works just fine, but in MSDE -SqlCE scenario it seems to be some trouble.
I always get the same error: 29045 - reconciler has failed. Basically it means, that SqlCE server agent cannot start Reconciler under MSDE. What can cause such a disaster? Incompatibility of components used? This isnt connectivity or access rights issue, i'm pretty sure of it.
I've tried to use different versions of MSDE: MSDE SP4 and MSDE SP3a. Searching in different newsgroups for a couple of hours makes me think that older versions of MSDE are more suitable for my task because few posts stated that merge replication works on MSDE SP3a, but this subject isnt covered in detail. Can you provide any help?|||

READ MY POST YESTERDAY

we are all waiting for Microsoft to bring this function

I will pay for it as you probably will as well

I dont understand why we are the only developers putting pressure on this matter

We need help. The other case is that we can begin referring other 3rd party non microsoft providers....

|||

You need to get onto my post and tell them you want it too

|||

If you are looking for SQL Mobile/SQL Ev to SQL Server synchronization you need to have either SQL Server 2000 or SQL Server 2005 Standard Edition and above.

Thanks

Laxmi Narsimha Rao ORUGNATI, MSFT, SQL Everywhere (SQL Ev), Microsoft Corp.

MSDE - Cluster Aware

Hi
Can anyone tell me if there are any problems associated with installing MSDE
2000 on a cluster? Or even if it is possible in the first place?
Thanks
> Can anyone tell me if there are any problems associated with installing
MSDE
> 2000 on a cluster? Or even if it is possible in the first place?
Clustering is supported with Enterprise Edition only. Check the "Choosing an
Edition of SQL Server 2000" whitepaper at
http://www.microsoft.com/sql/techinf...KChooseEd.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
|||Hi
So if I just install MSDE 2000 by itself then it is not cluster aware? I
read the white paper but it's not really clear.
Could you also tell me if merge replication will work with MSDE 2000 as all
the articles I have read so far only seem to suggest it will work for a
subscriber and not as a publisher.
Thanks
"Dejan Sarka" wrote:

> MSDE
> Clustering is supported with Enterprise Edition only. Check the "Choosing an
> Edition of SQL Server 2000" whitepaper at
> http://www.microsoft.com/sql/techinf...KChooseEd.asp.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>
|||> So if I just install MSDE 2000 by itself then it is not cluster aware? I
> read the white paper but it's not really clear.
No, it is not cluster aware.

> Could you also tell me if merge replication will work with MSDE 2000 as
all
> the articles I have read so far only seem to suggest it will work for a
> subscriber and not as a publisher.
Merge replication is supported entirely, while tansactional replication
works if MSDE is subscriber only.
Here is a better lik, with clearer info:
http://msdn.microsoft.com/library/de...r_ts_1cdv.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

MSDE - Cluster Aware

Hi
Can anyone tell me if there are any problems associated with installing MSDE
2000 on a cluster? Or even if it is possible in the first place?
Thanks> Can anyone tell me if there are any problems associated with installing
MSDE
> 2000 on a cluster? Or even if it is possible in the first place?
Clustering is supported with Enterprise Edition only. Check the "Choosing an
Edition of SQL Server 2000" whitepaper at
http://www.microsoft.com/sql/techinfo/planning/SQLResKChooseEd.asp.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||Hi
So if I just install MSDE 2000 by itself then it is not cluster aware? I
read the white paper but it's not really clear.
Could you also tell me if merge replication will work with MSDE 2000 as all
the articles I have read so far only seem to suggest it will work for a
subscriber and not as a publisher.
Thanks
"Dejan Sarka" wrote:
> > Can anyone tell me if there are any problems associated with installing
> MSDE
> > 2000 on a cluster? Or even if it is possible in the first place?
> Clustering is supported with Enterprise Edition only. Check the "Choosing an
> Edition of SQL Server 2000" whitepaper at
> http://www.microsoft.com/sql/techinfo/planning/SQLResKChooseEd.asp.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>|||> So if I just install MSDE 2000 by itself then it is not cluster aware? I
> read the white paper but it's not really clear.
No, it is not cluster aware.
> Could you also tell me if merge replication will work with MSDE 2000 as
all
> the articles I have read so far only seem to suggest it will work for a
> subscriber and not as a publisher.
Merge replication is supported entirely, while tansactional replication
works if MSDE is subscriber only.
Here is a better lik, with clearer info:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.asp.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

MSDE - Cluster Aware

Hi
Can anyone tell me if there are any problems associated with installing MSDE
2000 on a cluster? Or even if it is possible in the first place?
Thanks> Can anyone tell me if there are any problems associated with installing
MSDE
> 2000 on a cluster? Or even if it is possible in the first place?
Clustering is supported with Enterprise Edition only. Check the "Choosing an
Edition of SQL Server 2000" whitepaper at
http://www.microsoft.com/sql/techin...sKChooseEd.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||Hi
So if I just install MSDE 2000 by itself then it is not cluster aware? I
read the white paper but it's not really clear.
Could you also tell me if merge replication will work with MSDE 2000 as all
the articles I have read so far only seem to suggest it will work for a
subscriber and not as a publisher.
Thanks
"Dejan Sarka" wrote:

> MSDE
> Clustering is supported with Enterprise Edition only. Check the "Choosing
an
> Edition of SQL Server 2000" whitepaper at
> http://www.microsoft.com/sql/techin...sKChooseEd.asp.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>|||> So if I just install MSDE 2000 by itself then it is not cluster aware? I
> read the white paper but it's not really clear.
No, it is not cluster aware.

> Could you also tell me if merge replication will work with MSDE 2000 as
all
> the articles I have read so far only seem to suggest it will work for a
> subscriber and not as a publisher.
Merge replication is supported entirely, while tansactional replication
works if MSDE is subscriber only.
Here is a better lik, with clearer info:
http://msdn.microsoft.com/library/d...r />
1cdv.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

MSDE

Can some one tell me how to figure out which version MSDE I have loaded? It
is part of some non-Microsoft software, and MBSA suggests installing paths,
but I don't know what version of MSDE to select the patch for. Thank you fo
r
any help you can provide.http://www.aspfaq.com/show.asp?id=2160
Andrew J. Kelly SQL MVP
"Glen_in_Spokane" <Glen_in_Spokane@.discussions.microsoft.com> wrote in
message news:9C03AF5C-1FA3-4B90-AFCB-8CE2D7E1546D@.microsoft.com...
> Can some one tell me how to figure out which version MSDE I have loaded?
> It
> is part of some non-Microsoft software, and MBSA suggests installing
> paths,
> but I don't know what version of MSDE to select the patch for. Thank you
> for
> any help you can provide.

MSDE

Can some one tell me how to figure out which version MSDE I have loaded? It
is part of some non-Microsoft software, and MBSA suggests installing paths,
but I don't know what version of MSDE to select the patch for. Thank you for
any help you can provide.
http://www.aspfaq.com/show.asp?id=2160
Andrew J. Kelly SQL MVP
"Glen_in_Spokane" <Glen_in_Spokane@.discussions.microsoft.com> wrote in
message news:9C03AF5C-1FA3-4B90-AFCB-8CE2D7E1546D@.microsoft.com...
> Can some one tell me how to figure out which version MSDE I have loaded?
> It
> is part of some non-Microsoft software, and MBSA suggests installing
> paths,
> but I don't know what version of MSDE to select the patch for. Thank you
> for
> any help you can provide.

MSDE

I have MSDE Deployment Kit with my SQL2000 CD.
But while installing it is giving error the name alredy
exists. And also tell me the sourse where i will get
examples and information about MSDE-2000.
Hi Rahul,
The MSDE can be installed multiple times on a single system. These separate
installations are called 'instances'. Each (apart from the default initial
instance) has a name. It is possible the one you are trying to create
already exists.
For info on the MSDE, a very good place to start is
http://www.microsoft.com/sql/msde
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Rahul" <superrahul@.hotmail.com> wrote in message
news:be2001c43817$4443bdf0$a001280a@.phx.gbl...
> I have MSDE Deployment Kit with my SQL2000 CD.
> But while installing it is giving error the name alredy
> exists. And also tell me the sourse where i will get
> examples and information about MSDE-2000.
>
|||Can you explain or give a reference for what a XPE runtime image is?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nigel" <anonymous@.discussions.microsoft.com> wrote in message
news:6DEDC927-7B23-4C28-B0FA-FF3528190688@.microsoft.com...
> Does microsoft or anyone for that matter have a solution for including MSDE in a XPE runtime image?
|||Nigel,
Yes, we have working MSDE component. The component has all necessary dependencies specified and works stable with Minlogon/Winlogon
images.
Regards,
KM,
BSquare Corporation

> Does microsoft or anyone for that matter have a solution for including MSDE in a XPE runtime image?
|||KM,
I am looking at a "Courtesy Copy for Reference Purposes Only" of the "Additional Licensing Provisions for Microsoft Windows XP Embedded Runtime Licenses", Paragraph 12, which states:
"COMPANY may not distribute in any manner, nor include in the Image, (i) the Microsoft Data Engine or (ii) The 'setup.exe' file contained in the SQLMSDE folder."
How can I interepret this paragraph in ANY way that lets me use MSDE in my embedded product?
~Desi
"KM" wrote:

> Nigel,
> Yes, we have working MSDE component. The component has all necessary dependencies specified and works stable with Minlogon/Winlogon
> images.
> --
> Regards,
> KM,
> BSquare Corporation
>
>
>
|||Bump for an unanswered thread...
Microsoft? Anyone?
"Desi Richards" wrote:
[vbcol=seagreen]
> KM,
> I am looking at a "Courtesy Copy for Reference Purposes Only" of the "Additional Licensing Provisions for Microsoft Windows XP Embedded Runtime Licenses", Paragraph 12, which states:
> "COMPANY may not distribute in any manner, nor include in the Image, (i) the Microsoft Data Engine or (ii) The 'setup.exe' file contained in the SQLMSDE folder."
> How can I interepret this paragraph in ANY way that lets me use MSDE in my embedded product?
> ~Desi
>
> "KM" wrote:

MSDE

Can some one tell me how to figure out which version MSDE I have loaded? It
is part of some non-Microsoft software, and MBSA suggests installing paths,
but I don't know what version of MSDE to select the patch for. Thank you for
any help you can provide.http://www.aspfaq.com/show.asp?id=2160
Andrew J. Kelly SQL MVP
"Glen_in_Spokane" <Glen_in_Spokane@.discussions.microsoft.com> wrote in
message news:9C03AF5C-1FA3-4B90-AFCB-8CE2D7E1546D@.microsoft.com...
> Can some one tell me how to figure out which version MSDE I have loaded?
> It
> is part of some non-Microsoft software, and MBSA suggests installing
> paths,
> but I don't know what version of MSDE to select the patch for. Thank you
> for
> any help you can provide.

msdbdata.mdf missing after installing an instance of MSDE

Hi all,
msdbdata.mdf is missing after I install an instance of MSDE.
What could be causing this?
Thanks
hi Jason,
Jason Fischer wrote:
> Hi all,
> msdbdata.mdf is missing after I install an instance of MSDE.
> What could be causing this?
are you sure you correctly installed MSDE? no error has been reported? the
verbose log file shows no problems?
msdb database is a system database and is part of a proper installation...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
Yes, there was no error reported while installing.
I know that msdb is a system DB, that's what is bugging me.
I will check the log file again and see if there is anything funny reported
even though an error isn't logged.
Thanks,
Jason
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3kkk2oFuh3b0U1@.individual.net...
> hi Jason,
> Jason Fischer wrote:
> are you sure you correctly installed MSDE? no error has been reported? the
> verbose log file shows no problems?
> msdb database is a system database and is part of a proper installation...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>