MSDE 2000 changing disablenetworkprotocols after installation

Hi All
I wasn't aware of the security feature of MSDE, whereby it doesn't allow the
TCP/IP(?) network protocol to work and allow a networked PC to connect to an
SQL DB running on a MSDE installation on another PC. It only allows the
'host' PC to connect to the SQL DB.
I've sussed this in my MSDE installer so that it enables the network feature
when it installs, but I have a user who already has MSDE installed and
running with the protocol disabled and now that they are in the process of
connecting and using a 2nd PC I don't want to ask them to detach their db,
re-install MSDE with the right flag and then re-attach their db, as our
relationship is strained as it is.
Is there anyway to re-set/patch this flag on an installed version?
Thanks
Robbie
hi Robbie,
Astra wrote:
>..
> I've sussed this in my MSDE installer so that it enables the network
> feature when it installs, but I have a user who already has MSDE
> installed and running with the protocol disabled and now that they
> are in the process of connecting and using a 2nd PC I don't want to
> ask them to detach their db, re-install MSDE with the right flag and
> then re-attach their db, as our relationship is strained as it is.
> Is there anyway to re-set/patch this flag on an installed version?
please have a look at
http://support.microsoft.com/default...b;en-us;285097 in the part
regarding the Windows registry modification..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE / EM licensing

I'm aware you can install MSDE on a customers site if they dont have SQL
Server, correct? If so can you install the client setup off the SQL Server
cd so you get enterprise manager?
How do you handle backup/restore 'nicely' without EM?
LH
If so can you install the client setup off the SQL Server
> cd so you get enterprise manager?
-No, that would break the EULA.

> How do you handle backup/restore 'nicely' without EM?
-There aremany free tools outside to use:
One example: https://www.whitebearconsulting.com/Utilities.htm
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"lh" <lh@.nowhere.com> schrieb im Newsbeitrag
news:_q1xe.22580$Le2.144904@.nasal.pacific.net.au.. .
> I'm aware you can install MSDE on a customers site if they dont have SQL
> Server, correct? If so can you install the client setup off the SQL
> Server cd so you get enterprise manager?
> How do you handle backup/restore 'nicely' without EM?
>
> LH
>

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

msdb restore to standby server

Can the msdb database safely be moved to a new server by taking a backup fro
m
the source server and restoring to the target? I am aware that
sysjobs.originating_server must be updated after the restore and that
Microsoft suggests transfering the msdb by scripting jobs, dts packages, etc
.SQL Server 2000 sp3
"Brandon" wrote:

> Can the msdb database safely be moved to a new server by taking a backup f
rom
> the source server and restoring to the target? I am aware that
> sysjobs.originating_server must be updated after the restore and that
> Microsoft suggests transfering the msdb by scripting jobs, dts packages, e
tc.
>|||Ive never had good luck doing that and just would up going the MS route.
--
TIA,
ChrisR
"Brandon" wrote:

> Can the msdb database safely be moved to a new server by taking a backup f
rom
> the source server and restoring to the target? I am aware that
> sysjobs.originating_server must be updated after the restore and that
> Microsoft suggests transfering the msdb by scripting jobs, dts packages, e
tc.
>

msdb restore to standby server

Can the msdb database safely be moved to a new server by taking a backup from
the source server and restoring to the target? I am aware that
sysjobs.originating_server must be updated after the restore and that
Microsoft suggests transfering the msdb by scripting jobs, dts packages, etc.
SQL Server 2000 sp3
"Brandon" wrote:

> Can the msdb database safely be moved to a new server by taking a backup from
> the source server and restoring to the target? I am aware that
> sysjobs.originating_server must be updated after the restore and that
> Microsoft suggests transfering the msdb by scripting jobs, dts packages, etc.
>
|||Ive never had good luck doing that and just would up going the MS route.
TIA,
ChrisR
"Brandon" wrote:

> Can the msdb database safely be moved to a new server by taking a backup from
> the source server and restoring to the target? I am aware that
> sysjobs.originating_server must be updated after the restore and that
> Microsoft suggests transfering the msdb by scripting jobs, dts packages, etc.
>

msdb restore to standby server

Can the msdb database safely be moved to a new server by taking a backup from
the source server and restoring to the target? I am aware that
sysjobs.originating_server must be updated after the restore and that
Microsoft suggests transfering the msdb by scripting jobs, dts packages, etc.SQL Server 2000 sp3
"Brandon" wrote:
> Can the msdb database safely be moved to a new server by taking a backup from
> the source server and restoring to the target? I am aware that
> sysjobs.originating_server must be updated after the restore and that
> Microsoft suggests transfering the msdb by scripting jobs, dts packages, etc.
>|||Ive never had good luck doing that and just would up going the MS route.
--
TIA,
ChrisR
"Brandon" wrote:
> Can the msdb database safely be moved to a new server by taking a backup from
> the source server and restoring to the target? I am aware that
> sysjobs.originating_server must be updated after the restore and that
> Microsoft suggests transfering the msdb by scripting jobs, dts packages, etc.
>