Can i use microsoft sql server offline?

Certainly, if you have direct access to the server that SQL Server resides on. For that matter, it can be used as a dedicated database application on a single workstation and not networked at all (albeit perhaps a bit of overkill if you're running the Enterprise edition.)