3 ms·
The only issue I've ever had with MSSQL is that the Express version comes configured out-of-the-box with a set of defaults that make it nearly useless. TCP/IP
by douche 10y ago
The only issue I've ever had with MSSQL is that the Express version comes configured out-of-the-box with a set of defaults that make it nearly useless. TCP/IP connections are turned off, and you have to go through and set all the protocols to use the normal SQL port.
- wolrah 10y agoI've seen SQL Express used basically like SQLite a number of times, where it's only being accessed by a local installation of something. Also if you're installing it manually (and thus having to configure it manually) the odds are good that you're a developer in which case it'll also only be accessed locally. It's a sane default to not listen to the network. A lot of users won't need it. Those that do can enable it. The port thing is handled automatically when you have your network clients working correctly. For the record I'm a SQLite/Postgres guy, the only reason I even know about the port thing is having to help a customer troubleshoot some software that uses SQL express a few weeks ago. Definitely not a MS defender normally, but your complaints are really silly.