Access SQL Server Express LocalDB from local area network
I am developing a software which requires sql server. But for 50 MB application it is not good idea to tell customers to install SQL Server. So I think it is 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?
sql-server sql-server-localdb
edited Jul 5 '16 at 18:54
Solomon Rutzky
48.1k579174
asked Jul 5 '16 at 11:23
IT researcherIT researcher
1,415133866
add a comment |
I am developing a software which requires sql server. But for 50 MB application it is not good idea to tell customers to install SQL Server. So I think it is 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?
sql-server sql-server-localdb
edited Jul 5 '16 at 18:54
Solomon Rutzky
48.1k579174
asked Jul 5 '16 at 11:23
IT researcherIT researcher
1,415133866
Have you considered SQL Server Express? (Rather than express local db).
– Sir Swears-a-lot
Jul 6 '16 at 10:13
Can you confirm you specifically require a version of Microsoft SQL Server rather than your application needs a database that use Structured Query Language.
– Sir Swears-a-lot
Jul 6 '16 at 10:18
@Peter Currently I am implementing application in SQL Server Express. I am searching for other alternatives only because of its size.
– IT researcher
Jul 6 '16 at 10:34
1
If you want the features of SQL Server then I think Express is as low as you want to go. Anything less than than like embedded edition is so limited its a pain to work with. If you don't need the security or scalability of SQL Server you could consider MS Access? But if its truly going to be a lan based multi user system express is far superior.
– Sir Swears-a-lot
Jul 6 '16 at 10:45
add a comment |
I am developing a software which requires sql server. But for 50 MB application it is not good idea to tell customers to install SQL Server. So I think it is 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?
sql-server sql-server-localdb
edited Jul 5 '16 at 18:54
Solomon Rutzky
48.1k579174
asked Jul 5 '16 at 11:23
IT researcherIT researcher
1,415133866
I am developing a software which requires sql server. But for 50 MB application it is not good idea to tell customers to install SQL Server. So I think it is 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?
sql-server sql-server-localdb
sql-server sql-server-localdb
edited Jul 5 '16 at 18:54
Solomon Rutzky
48.1k579174
asked Jul 5 '16 at 11:23
IT researcherIT researcher
1,415133866
edited Jul 5 '16 at 18:54
Solomon Rutzky
48.1k579174
asked Jul 5 '16 at 11:23
IT researcherIT researcher
1,415133866
edited Jul 5 '16 at 18:54
Solomon Rutzky
48.1k579174
edited Jul 5 '16 at 18:54
Solomon Rutzky
48.1k579174
edited Jul 5 '16 at 18:54
Solomon Rutzky
48.1k579174
48.1k579174
asked Jul 5 '16 at 11:23
IT researcherIT researcher
1,415133866
asked Jul 5 '16 at 11:23
IT researcherIT researcher
1,415133866
asked Jul 5 '16 at 11:23
IT researcherIT researcher
1,415133866
1,415133866
Have you considered SQL Server Express? (Rather than express local db).
– Sir Swears-a-lot
Jul 6 '16 at 10:13
Can you confirm you specifically require a version of Microsoft SQL Server rather than your application needs a database that use Structured Query Language.
– Sir Swears-a-lot
Jul 6 '16 at 10:18
@Peter Currently I am implementing application in SQL Server Express. I am searching for other alternatives only because of its size.
– IT researcher
Jul 6 '16 at 10:34
1
If you want the features of SQL Server then I think Express is as low as you want to go. Anything less than than like embedded edition is so limited its a pain to work with. If you don't need the security or scalability of SQL Server you could consider MS Access? But if its truly going to be a lan based multi user system express is far superior.
– Sir Swears-a-lot
Jul 6 '16 at 10:45
add a comment |
Have you considered SQL Server Express? (Rather than express local db).
– Sir Swears-a-lot
Jul 6 '16 at 10:13
Can you confirm you specifically require a version of Microsoft SQL Server rather than your application needs a database that use Structured Query Language.
– Sir Swears-a-lot
Jul 6 '16 at 10:18
@Peter Currently I am implementing application in SQL Server Express. I am searching for other alternatives only because of its size.
– IT researcher
Jul 6 '16 at 10:34
1
If you want the features of SQL Server then I think Express is as low as you want to go. Anything less than than like embedded edition is so limited its a pain to work with. If you don't need the security or scalability of SQL Server you could consider MS Access? But if its truly going to be a lan based multi user system express is far superior.
– Sir Swears-a-lot
Jul 6 '16 at 10:45
Have you considered SQL Server Express? (Rather than express local db).
– Sir Swears-a-lot
Jul 6 '16 at 10:13
Have you considered SQL Server Express? (Rather than express local db).
– Sir Swears-a-lot
Jul 6 '16 at 10:13
Can you confirm you specifically require a version of Microsoft SQL Server rather than your application needs a database that use Structured Query Language.
– Sir Swears-a-lot
Jul 6 '16 at 10:18
Can you confirm you specifically require a version of Microsoft SQL Server rather than your application needs a database that use Structured Query Language.
– Sir Swears-a-lot
Jul 6 '16 at 10:18
@Peter Currently I am implementing application in SQL Server Express. I am searching for other alternatives only because of its size.
– IT researcher
Jul 6 '16 at 10:34
@Peter Currently I am implementing application in SQL Server Express. I am searching for other alternatives only because of its size.
– IT researcher
Jul 6 '16 at 10:34
1
1
If you want the features of SQL Server then I think Express is as low as you want to go. Anything less than than like embedded edition is so limited its a pain to work with. If you don't need the security or scalability of SQL Server you could consider MS Access? But if its truly going to be a lan based multi user system express is far superior.
– Sir Swears-a-lot
Jul 6 '16 at 10:45
If you want the features of SQL Server then I think Express is as low as you want to go. Anything less than than like embedded edition is so limited its a pain to work with. If you don't need the security or scalability of SQL Server you could consider MS Access? But if its truly going to be a lan based multi user system express is far superior.
– Sir Swears-a-lot
Jul 6 '16 at 10:45
add a comment |
2 Answers
2
active
oldest
votes
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 nodays, even for small applications. You can embed the setup in your application and ship SQL Express with your setup kit. If you need a small footprint SQL Server Edition, consider using SQL Server Compact Edition.
answered Jul 5 '16 at 13:05
spaghettidbaspaghettidba
9,8671835
Is there any ways to me other than installing SQL server ?
– IT researcher
Jul 5 '16 at 13:21
@ITresearcher Updated my answer
– spaghettidba
Jul 5 '16 at 13:29
add a comment |
The mdf/ldf files can reside on a server share but I believe only one PC can access the files/database at a time (i.e. no concurrent access from multiple clients running their own LocalDB instance). That's dissimilar to MS Access where multiple PCs can connect to a shared mdb file residing on a server share.
From the documentation:
The LocalDB files can only be opened by one instance of LocalDB at a
time.
answered 6 mins ago
Mike LoweryMike Lowery
1012
New contributor
Mike Lowery is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f142987%2faccess-sql-server-express-localdb-from-local-area-network%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
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 nodays, even for small applications. You can embed the setup in your application and ship SQL Express with your setup kit. If you need a small footprint SQL Server Edition, consider using SQL Server Compact Edition.
answered Jul 5 '16 at 13:05
spaghettidbaspaghettidba
9,8671835
Is there any ways to me other than installing SQL server ?
– IT researcher
Jul 5 '16 at 13:21
@ITresearcher Updated my answer
– spaghettidba
Jul 5 '16 at 13:29
add a comment |
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 nodays, even for small applications. You can embed the setup in your application and ship SQL Express with your setup kit. If you need a small footprint SQL Server Edition, consider using SQL Server Compact Edition.
answered Jul 5 '16 at 13:05
spaghettidbaspaghettidba
9,8671835
Is there any ways to me other than installing SQL server ?
– IT researcher
Jul 5 '16 at 13:21
@ITresearcher Updated my answer
– spaghettidba
Jul 5 '16 at 13:29
add a comment |
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 nodays, even for small applications. You can embed the setup in your application and ship SQL Express with your setup kit. If you need a small footprint SQL Server Edition, consider using SQL Server Compact Edition.
answered Jul 5 '16 at 13:05
spaghettidbaspaghettidba
9,8671835
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 nodays, even for small applications. You can embed the setup in your application and ship SQL Express with your setup kit. If you need a small footprint SQL Server Edition, consider using SQL Server Compact Edition.
answered Jul 5 '16 at 13:05
spaghettidbaspaghettidba
9,8671835
edited Jul 5 '16 at 13:29
answered Jul 5 '16 at 13:05
spaghettidbaspaghettidba
9,8671835
answered Jul 5 '16 at 13:05
spaghettidbaspaghettidba
9,8671835
answered Jul 5 '16 at 13:05
spaghettidbaspaghettidba
9,8671835
9,8671835
Is there any ways to me other than installing SQL server ?
– IT researcher
Jul 5 '16 at 13:21
@ITresearcher Updated my answer
– spaghettidba
Jul 5 '16 at 13:29
add a comment |
Is there any ways to me other than installing SQL server ?
– IT researcher
Jul 5 '16 at 13:21
@ITresearcher Updated my answer
– spaghettidba
Jul 5 '16 at 13:29
Is there any ways to me other than installing SQL server ?
– IT researcher
Jul 5 '16 at 13:21
Is there any ways to me other than installing SQL server ?
– IT researcher
Jul 5 '16 at 13:21
@ITresearcher Updated my answer
– spaghettidba
Jul 5 '16 at 13:29
@ITresearcher Updated my answer
– spaghettidba
Jul 5 '16 at 13:29
add a comment |
The mdf/ldf files can reside on a server share but I believe only one PC can access the files/database at a time (i.e. no concurrent access from multiple clients running their own LocalDB instance). That's dissimilar to MS Access where multiple PCs can connect to a shared mdb file residing on a server share.
From the documentation:
The LocalDB files can only be opened by one instance of LocalDB at a
time.
answered 6 mins ago
Mike LoweryMike Lowery
1012
New contributor
Mike Lowery is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
The mdf/ldf files can reside on a server share but I believe only one PC can access the files/database at a time (i.e. no concurrent access from multiple clients running their own LocalDB instance). That's dissimilar to MS Access where multiple PCs can connect to a shared mdb file residing on a server share.
From the documentation:
The LocalDB files can only be opened by one instance of LocalDB at a
time.
answered 6 mins ago
Mike LoweryMike Lowery
1012
New contributor
Mike Lowery is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
The mdf/ldf files can reside on a server share but I believe only one PC can access the files/database at a time (i.e. no concurrent access from multiple clients running their own LocalDB instance). That's dissimilar to MS Access where multiple PCs can connect to a shared mdb file residing on a server share.
From the documentation:
The LocalDB files can only be opened by one instance of LocalDB at a
time.
answered 6 mins ago
Mike LoweryMike Lowery
1012
New contributor
Mike Lowery is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
The mdf/ldf files can reside on a server share but I believe only one PC can access the files/database at a time (i.e. no concurrent access from multiple clients running their own LocalDB instance). That's dissimilar to MS Access where multiple PCs can connect to a shared mdb file residing on a server share.
From the documentation:
The LocalDB files can only be opened by one instance of LocalDB at a
time.
answered 6 mins ago
Mike LoweryMike Lowery
1012
New contributor
Mike Lowery is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 6 mins ago
Mike LoweryMike Lowery
1012
New contributor
Mike Lowery is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 6 mins ago
Mike LoweryMike Lowery
1012
answered 6 mins ago
Mike LoweryMike Lowery
1012
1012
New contributor
Mike Lowery is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Mike Lowery is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Mike Lowery is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f142987%2faccess-sql-server-express-localdb-from-local-area-network%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Have you considered SQL Server Express? (Rather than express local db).
– Sir Swears-a-lot
Jul 6 '16 at 10:13
Can you confirm you specifically require a version of Microsoft SQL Server rather than your application needs a database that use Structured Query Language.
– Sir Swears-a-lot
Jul 6 '16 at 10:18
@Peter Currently I am implementing application in SQL Server Express. I am searching for other alternatives only because of its size.
– IT researcher
Jul 6 '16 at 10:34
1
If you want the features of SQL Server then I think Express is as low as you want to go. Anything less than than like embedded edition is so limited its a pain to work with. If you don't need the security or scalability of SQL Server you could consider MS Access? But if its truly going to be a lan based multi user system express is far superior.
– Sir Swears-a-lot
Jul 6 '16 at 10:45