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! :)
Related posts:
- Learn SQL — The EASY Way! We’re very pleased to announce the latest addition to...
- Who Needs Graphics? Create Charts in SQL Who needs GIFs, JPGs, PNGs, SVGs or canvas when you...
- Build Your Own Dev Server with VirtualBox What's the best way to test your web site on...
- How to Install Apache Web Server on Windows Professional web developers need a web server and Apache is...
- Will Server-Side JavaScript ever catch on? Server-side JavaScript appears to be a logical choice for web...






Thank you!
April 3rd, 2006 at 10:53 pm