In the process of doing some routine monitoring/clean-up we've
discovered that several (many?) users are apparently set to access our
SQL Server 2000 database instances via the Named Pipes protocol. In
readings and recommendations we've decided that our WAN would be best
served if we use the less "chatty" TCP/IP.
As such we've also decided to try to enforce this decision to use
TCP/IP exclusively using the domain login script used by all of our
end-users.
Question: does anyone know what registry entries are created/used to
indicate that TCP/IP is enabled and is the default protocol for SQL
Server 2000? Our environment is: XP Pro SP2 and SQL Server 2000
(typically SP3).
TIA
Glenn - newbie DBA
5  18123 
(gl*********@gm ail.com) writes: In the process of doing some routine monitoring/clean-up we've
discovered that several (many?) users are apparently set to access our
SQL Server 2000 database instances via the Named Pipes protocol. In
readings and recommendations we've decided that our WAN would be best
served if we use the less "chatty" TCP/IP.
As such we've also decided to try to enforce this decision to use
TCP/IP exclusively using the domain login script used by all of our
end-users.
Question: does anyone know what registry entries are created/used to
indicate that TCP/IP is enabled and is the default protocol for SQL
Server 2000? Our environment is: XP Pro SP2 and SQL Server 2000
(typically SP3).
The brutal variant would be to open the Server Network Utility on
the server box, and disable Named Pipes (server restart needed, as I
recall.)
On the clients it could be a good thing to use the Client Network
Utility to disable Named Pipes, or put it lower in priority than
TCP/IP.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
Erland, I appreciate the input but we're not looking at wiping out the
use of named pipes all-together (there may be background processes and
legacy applications which use/require the protocol). We're hoping only
to disable Named Pipes for End-Users who login via the default domain.
So, the question still stands...
Question: does anyone know what registry entries are created/used to
indicate that TCP/IP is enabled and is the default protocol for SQL
Server 2000? Our environment is: XP Pro SP2 and SQL Server 2000
(typically SP3).
Erland Sommarskog wrote: (gl*********@gm ail.com) writes: In the process of doing some routine monitoring/clean-up we've
discovered that several (many?) users are apparently set to access
our SQL Server 2000 database instances via the Named Pipes protocol. In
readings and recommendations we've decided that our WAN would be
best served if we use the less "chatty" TCP/IP.
As such we've also decided to try to enforce this decision to use
TCP/IP exclusively using the domain login script used by all of our
end-users.
Question: does anyone know what registry entries are created/used
to indicate that TCP/IP is enabled and is the default protocol for SQL
Server 2000? Our environment is: XP Pro SP2 and SQL Server 2000
(typically SP3).
The brutal variant would be to open the Server Network Utility on
the server box, and disable Named Pipes (server restart needed, as I
recall.)
On the clients it could be a good thing to use the Client Network
Utility to disable Named Pipes, or put it lower in priority than
TCP/IP.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
(go****@nixonpe abody.com) writes: Erland, I appreciate the input but we're not looking at wiping out the
use of named pipes all-together (there may be background processes and
legacy applications which use/require the protocol). We're hoping only
to disable Named Pipes for End-Users who login via the default domain.
So, the question still stands...
Question: does anyone know what registry entries are created/used to
indicate that TCP/IP is enabled and is the default protocol for SQL
Server 2000? Our environment is: XP Pro SP2 and SQL Server 2000
(typically SP3).
I'm still not sure what you are asking for. Your question make it
seem like you want to do this on the server level, but this appears
to be impossible, since you want to keep Named Pipes for some clients.
Thus, your only option is to change this at the clients. The supported
way to do this, is to use the Client Network Utility.
If you want to hack the registry yourself, it appeats that the relevant
values and keys are under
HKEY_LOCAL_MACH INE\SOFTWARE\Mi crosoft\MSSQLSe rver\Client\Sup erSocketNetLib
The value Protocol Order appears to be the priority order, and should
thus have "tcp" in the beginning. Under the subkey Tcp, there should
be a REG_DWORD value DefaulPort with the value of 0x00000599 (1433.)
I recommend you to play around from the Client Network Utility a little
more, before you start any remote registry hacking or whatever you are
planning to do.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
Erland, what I'm suggesting is that we do NOT do this at the server
level but rather on a per user basis using our standard login script.
We have several hundred end-users in geographically different
locations. Virtually none of the users have access to, or have
knowledge of, the SQL Client Utility. So, the idea is that when they
logon to their PCs a scriptlet will be run which will disable Named
Pipes and/or insure that TCP/IP is the default protocol.
I was hoping that someone could suggest/provide such a script or
specify the WIN XP registry key/values that define the protocol, etc.
I hope that this clears thing up.
Thanks
Erland Sommarskog wrote: (go****@nixonpe abody.com) writes: Erland, I appreciate the input but we're not looking at wiping out
the use of named pipes all-together (there may be background processes
and legacy applications which use/require the protocol). We're hoping
only to disable Named Pipes for End-Users who login via the default
domain. So, the question still stands...
Question: does anyone know what registry entries are created/used
to indicate that TCP/IP is enabled and is the default protocol for SQL
Server 2000? Our environment is: XP Pro SP2 and SQL Server 2000
(typically SP3).
I'm still not sure what you are asking for. Your question make it
seem like you want to do this on the server level, but this appears
to be impossible, since you want to keep Named Pipes for some
clients.
Thus, your only option is to change this at the clients. The
supported way to do this, is to use the Client Network Utility.
If you want to hack the registry yourself, it appeats that the
relevant values and keys are under
HKEY_LOCAL_MACH INE\SOFTWARE\Mi crosoft\MSSQLSe rver\Client\Sup erSocketNetLib The value Protocol Order appears to be the priority order, and should
thus have "tcp" in the beginning. Under the subkey Tcp, there should
be a REG_DWORD value DefaulPort with the value of 0x00000599 (1433.)
I recommend you to play around from the Client Network Utility a
little more, before you start any remote registry hacking or whatever you
are planning to do.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
(go****@nixonpe abody.com) writes: I was hoping that someone could suggest/provide such a script or
specify the WIN XP registry key/values that define the protocol, etc.
My post contained some hints in this direction, and my hope was that
you could work from this suggestion. If you want something ready of
the shelf, I'm afraid that I don't have any thing in store.
A quick search lead me to: http://msdn.microsoft.com/library/de...bnetlib_22.asp
There you find some more information about the registrty entries.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Rudolf Bargholz |
last post by:
Hi,
DB2 7.1 FP11
Windows 2000
Earlier this evening, after dropping and recreating a trigger, DB2 locked
up. I am not entirely sure that the cause of the problem was the replacing
of the trigger, but all of a sudden no users were able to connect to our
customers database. After running db2dart I found numerous corrupted indexes
which I removed using "db2dart MYDB /IM". Finally I was able to get a
|
by: Ken Allen |
last post by:
Is there any built-in facility for handling named pipes in C#/.Net, or must
one use unsafe code to access the WIN32 API directly?
There exists some code that uses named pipes heavily and there exists a need
for that code to send some information to a new .Net service I am writing.
It is a relatively simple matter for the existing code to use a named pipe
to send the data, but I can find no references to how I can create the named
pipe...
|
by: motimh |
last post by:
I am trying to use named pipes to interprocess communication.
My concern is the cpu wait time between them.
Can someone show me the code to do this in VBNet?
Is there an event that can be associated with the existence of text in
the pipe that can fire and hence not use any cpu time?
Any help is much appreciated.
|
by: Jarrod Morrison |
last post by:
Hi All
Im looking for a way use named pipes between a service app and an app run
when a user logs on and be able to pass string based data, im hoping that
the service can contact the app that is running in the user session and tell
it a path of an app to launch as the logged on user. Does anybody know of an
easy way to do this or have any examples i could look at ? Any help is
greatly appreciated
Many thanks
|
by: Federico Caselli |
last post by:
Hi,
I need to communicate between two processes. I tryed using named pipes, but
I'm afraid it's too complex for me...
I'd like to explain what I need. The two processes must just exchange an
array of two bytes. The successive writes should overwrite the previous ones.
For example, the process A sends byte0=7, byte1=9 and then it sends byte0=8,
byte1=10. The process B reads only after the second array is sent. The read
array should be...
| | |
by: Jarrod Morrison |
last post by:
Hello all
Ive been trying to get a service app that i run to interact with the logged
on user of the machine and so far havent been very successfull and have read
that maybe named pipes is the way to go. Im hoping someone has some
information and easy to understand examples on named pipes. Basically i need
my service app to signal a user app thats running and send basic text to it.
Any help is greatly appreciated
Thanks
|
by: Prathap |
last post by:
Hi,
I am a newbie to c++ and I am looking for examples in using pipes
for IPC communication. My two processes are independent and they
cannot use a unnamed pipe, so I am looking for examples that can teach
me about named pipe. I Googled a little and nothing turned out useful.
Any pointers appreciated.
thanks
~
Prathap
|
by: fahad.usman |
last post by:
I am making an application in which if the second instance of the same
application is launched, it checks its command-line arguments and
passes them to the already running instance. I have been told by
someone that using named pipes is one of the most commonly used ways
of doing this. But I did it in a simpler way; I saved the command-line
arguments in a text file and passed a message to the previously
running instance to read the...
|
by: andrewb |
last post by:
Hi all,
Having some trouble using named pipes and Visual Basic .NET and would
appreciate and help you could offer.
Essentially I am trying to develop a simple client/server application
that exchanges text messages using named pipes. The internet resources
seem a bit scarce and the only Microsoft resource I can find is
http://support.microsoft.com/kb/871044.
|
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,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
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,...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
