473,670 Members | 2,307 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MSDE 2000 changing disablenetworkp rotocols 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


Mar 8 '06 #1
0 3356

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
3097
by: izzy | last post by:
I was wondering if any of you guys can kindly help me in finding all the different versions of MSDE 2000 that came out since it's first release. I expected to find something similar like Sun's archive (http://java.sun.com/products/archive/index.html) for MSDE 2000 too but failed to find after a few hours of browsing at the Microsoft Download Center (http://www.microsoft.com/downloads/search.aspx?displaylang=en). They seem more into...
10
3842
by: noname | last post by:
MSDE 2000 Release A installed under windows 2000 pro will not communicate with SQL Server Manager nor MS Access on peer computer. Can someone help? Have set DISABLENETWORKPROTOCOLS=0 at install time. Install log shows installation successful.. Control Panel> Admin Tools> Services section shows SQL server instance running.
1
1980
by: Markus Graf | last post by:
Hi all I'v got a Windows XP Pro SP1 Box with MSDE sql2k SP3. The installation was not the problem, but if i would connect with a client like dbamgr2k or the MS Enterprise client, the client hangs up. If i try a nonlocal server, it hangs too. What's the problem? Markus
1
1815
by: hplloyd | last post by:
I want to include MSDE 2000 as part of my setup project for a VB.NET app from withing VS.NET 2003. I am having trouble finding out how to do this in terms of changing the settings re instancename and targetname. Is there a simple guide for finding out how to do this for us mere mortals without having to go down the path of using the Windows Installer SDK. I can sucessfully install an instance of MSDE using an instance name that I
2
1664
by: John Blair | last post by:
Hi, I am struggline to make my VB.Net windows client connect remotely to a MSDE database. The database is accessed ok from the remote PC when i used web forms (aspx) to access it. Can anyone provide me with an idiots guide to make the connection work from a windows client application? I get the following error:
2
2083
by: farqua | last post by:
I've been trying to install MS SQL Server 2000 sp3 on a stand alone WinXP box. I've tried using the version that came on the Office Pro 2003 cd as well as the latest download from MS (apparently they are the same). This is a new install and I am install from an account with administrative privileges (actually it's the only account on this box). I've tried installing from a DOS box and from an explorer window. I've tried inputing...
3
1152
by: Jack | last post by:
i keep getting error when i try to connect to remote MSDE server
1
1549
by: kaushalgajjar | last post by:
I have been struggling to build a package in VS2005. I have an application made in VB.Net with SQL 2000 now i want to build it to use in a stand alone Computer so i have found MSDE from Microsoft Site (but i couldnt found merge module from any where) MSDE having a setup file with several folders the setup file need following parameters setup.exe DISABLENETWORKPROTOCOLS=0 SAPWD="sa" INSTANCENAME="myinstance" SECURITYMODE=SQL Now the...
0
8469
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8386
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
8592
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8661
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6213
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5684
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4391
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2800
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2042
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.