Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Changing network Protocol in SQL Server

Author  Topic 

holymac
Starting Member

13 Posts

Posted - 2004-09-13 : 00:12:04
The system that i developed is running on a client based system but it is running under the Named Pipes network protocol. The same system running from my laptop is runnign under the TCP\IP. How do i change the protocols so that even the clients application uses TCP\IP protocol.

Is it advisable to disable Named Pipes protocol.


Thank you
Have a nice day
Kalyana Kumar

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-09-13 : 00:56:44
On their computer, you should be able to click on Start/Run and type 'cliconfg'. Disable the Net Bios protocol.

It is advisable to disable all network protocols you don't need. I would also use a non-standard TCP/IP port (not 1433) and choose the Hide Server option.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-09-13 : 01:07:53
Hi Derrick, is there a way to do this programmatically?
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-09-13 : 01:30:03
I'm sure there is :)

http://www.microsoft.com/downloads/details.aspx?familyid=5067faf8-0db4-429a-b502-de4329c8c850&displaylang=en

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-09-13 : 01:57:02
that was good,lolz, redirecting me to MS.

it's actually nice to configure your client machine straight from the setup. There are smart clients and not so smart clients, I usually end up doing the configuration on their machines
Go to Top of Page
   

- Advertisement -