Thursday, April 09, 2009

MSDE enable TCP/IP or Named Pipes

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