Need to run SQL Express within applications other than those supporting .NET?

Well, I needed to get my database schema to Visio, yet none of the connectors would work. By default, Express doesn’t talk via TCP or NP and its default listeners won’t accept older interfaces..so you need to manually enable these to get Express working via ODBC connectors:

1. Open the SQL Computer Manager
2. Navigate to “Server Network Configuration”
3. Navigate to “Protocols for “SQLEXPRESS” (or whatever your running instance is called)
4. Enable NP and TCP
5. Restart SQL Express

And, Bob is your uncle! :)

Philip is a Computer Science PhD student at Liverpool John Moores University. He's still not mastered guitar tabs, never finished Mario, and needs a haircut. He discusses life at http://www.miseldine.com/.

  • Charles

    Thank you!

Special Offer
Free course!

Git into it! Bonus course Introduction to Git is yours when you take up a free 14 day SitePoint Premium trial.