Posted by Astra on 03/08/06 12:38

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

• Next in forum: Re: Appending tables
• Prev in forum: Re: sum with increment
• Thread view: MSDE 2000 changing disablenetworkprotocols after installation

[Reply to this message]