How to enable remote access to MSDE

I’m experimenting with Windows XP Embedded at the moment and the development studio it installs relies on the MSDE (assuming you don’t already have a SQL Server). I’d set it up so the MSDE based component database was on a virtual machine, and was running the Target Designer on my local “real” machine. For some reason the Target Designer on the local machine wouldn’t talk to the database on the back end.

It’s obvious why (after a little thinking!) the MSDE denies remote access by default! To change that behaviour, run the “SQL Server Network Utility” (SVRNETCN.EXE) and add TCP/IP to the enabled list. Sorted.

Enjoy Reading This Article?

Here are some more articles you might like to read next:

  • USW Pro 24 PoE Teardown
  • 3D Rendering Your In-House GPS
  • Extracting a Full Day’s Video from UniFi NVR