Saturday, December 14, 2013

MSDE enable TCP/IP or Named Pipes in SQL Server 2000

When you inherit a new server sometimes you find that you can't connect to the server, to fix that you may need to simply enable the protocol via Sql Server Network Utility (svrnetcn) that is listening For MSDE.
  1. In Windows, click Start and Run.
  2. Enter svrnetcn and click OK.
  3. Under the General tab, verify that the correct instance for the server is displayed in the Instance(s) on this server box.
  4. Highlight your desired protocol and click Enable (double clicking the name also moves the protocol to the enabled protocols box).
  5. Click OK.
  6. Restart the Sql Server Instance
  7. In Windows, click Start and Run.
  8. enter services.msc
  9. Locate the MSSQLSERVER instance you modified in the Sql Server Network Utility and Restart the service.
You may wish to ensure that your users are not logged on or at least notified of this change as it will kick them out of the application
Thanks to sqlthis blog for the content.
http://sqlthis.blogspot.com/2009/04/msde-enable-tcpip-or-named-pipes.html
 
Posted by at
Labels:

1 comment:

  1. Anurag ChoudharyWed Feb 05, 05:52:00 PM GMT+5:30

    मेरा नाम Anurag Choudhary है और Fatehpur-Shekhawati में रहता हूं ।अंगरेजी में ब्लाग लिखता हूं । अंगरेजी में लिखना विविवशता है एक तो मेरा विषय ही ऐसा है और असल में मुझे Universal Key Board पर हिन्दी लिखनी आती ही नहीं है । हमारे क्षेत्र में ब्लागरों की संख्या नगण्य है । जो हैं वो भी SEO and Page Rank backlinks के प्रति उदसीन हैं । इस लिये मैं आप सभी महानु्भावों से निवेदन करता हूं कि सब आपस में जुडें आपस में Posts पर comment करें यही सब backlinks के आधार है । मेरा निवेदन सभी ब्लोग्गेर मित्रों को भेजें । मुझे कोई आदेश मेरे ब्लाग http://compualchemist.blogspot.in Via post comment या मेरी email-anuragchoudharyj@gmail.com पर भेजें ।

    ReplyDelete

Subscribe to: Post Comments (Atom)