patternsqlMinor
Access SQL Server Express LocalDB from Local Area Network
Viewed 0 times
localexpresssqllocaldbareaserverfromnetworkaccess
Problem
I am developing a software which requires SQL Server. But for a 50MB application it is not a good idea to tell customers to install SQL Server. So I think it's better to use SQL Server Express LocalDB.
I want to give feature of accessing my app from Local Area Network. But I am not getting any related topics to do this.
Is it possible to access SQL Server Express LocalDB on Local Area Network?
What are the limitations of SQL Server Express LocalDB compared to SQL Server?
I want to give feature of accessing my app from Local Area Network. But I am not getting any related topics to do this.
Is it possible to access SQL Server Express LocalDB on Local Area Network?
What are the limitations of SQL Server Express LocalDB compared to SQL Server?
Solution
LocalDB cannot be accessed remotely, it's by design and documented.
Here is a description of LocalDB.
Here is a list of LocalDB features and limitations.
I don't see how installing SQL Server can be a problem. 120 MB is not that big nowadays even for small applications. You can embed the setup in your application and ship SQL Express with your setup kit. If you need a SQL Server Edition with a small footprint, consider using SQL Server Compact Edition.
Here is a description of LocalDB.
Here is a list of LocalDB features and limitations.
I don't see how installing SQL Server can be a problem. 120 MB is not that big nowadays even for small applications. You can embed the setup in your application and ship SQL Express with your setup kit. If you need a SQL Server Edition with a small footprint, consider using SQL Server Compact Edition.
Context
StackExchange Database Administrators Q#142987, answer score: 8
Revisions (0)
No revisions yet.