This really misses the point. SQLite is an embedded data store in a single C library. SQL server is, well... A server. It has an instillation and configuration process, can be accessed by multiple processes, has granular permissions and a whole bunch of very important stuff.

If you don't need that stuff and you can just use the embedded data store, just use SQLite and get on your way. This is worse than an apples to oranges comparison. More like apples to an apple stand.

SQLite is great for what it does, I have used it many times. But I am not really sure about the utility of comparing it to SQL Server.