Missing sql server configuration manager
I'm using Windows 10 and have just installed Visual Studio 2017 community edition, as u can see, sql server express 2016 localdb is installed:
However, "SQLServerManager13.msc"(or any trace of configuration manager) is nowhere to be found on my machine.
I'm suspecting it's not installed. But SQL server configuration manager is not available to download as a stand-alone application. Please advise as to what should I do?
Thanks
sql-server visual-studio-2017 asked Nov 21 '18 at 14:54
Mr.YMr.Y
3452512
add a comment |
I'm using Windows 10 and have just installed Visual Studio 2017 community edition, as u can see, sql server express 2016 localdb is installed:
However, "SQLServerManager13.msc"(or any trace of configuration manager) is nowhere to be found on my machine.
I'm suspecting it's not installed. But SQL server configuration manager is not available to download as a stand-alone application. Please advise as to what should I do?
Thanks
sql-server visual-studio-2017 asked Nov 21 '18 at 14:54
Mr.YMr.Y
3452512
add a comment |
I'm using Windows 10 and have just installed Visual Studio 2017 community edition, as u can see, sql server express 2016 localdb is installed:
However, "SQLServerManager13.msc"(or any trace of configuration manager) is nowhere to be found on my machine.
I'm suspecting it's not installed. But SQL server configuration manager is not available to download as a stand-alone application. Please advise as to what should I do?
Thanks
sql-server visual-studio-2017 asked Nov 21 '18 at 14:54
Mr.YMr.Y
3452512
I'm using Windows 10 and have just installed Visual Studio 2017 community edition, as u can see, sql server express 2016 localdb is installed:
However, "SQLServerManager13.msc"(or any trace of configuration manager) is nowhere to be found on my machine.
I'm suspecting it's not installed. But SQL server configuration manager is not available to download as a stand-alone application. Please advise as to what should I do?
Thanks
sql-server visual-studio-2017 sql-server visual-studio-2017 asked Nov 21 '18 at 14:54
Mr.YMr.Y
3452512
asked Nov 21 '18 at 14:54
Mr.YMr.Y
3452512
asked Nov 21 '18 at 14:54
Mr.YMr.Y
3452512
asked Nov 21 '18 at 14:54
Mr.YMr.Y
3452512
asked Nov 21 '18 at 14:54
Mr.YMr.Y
3452512
3452512
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
This installed the LocalDB feature of Express which does not install config mgr, management studio etc and is managed at the command line.
It's meant to be a very easy/quick way to have a lightweight sql server and is not meant to be used except locally and has a special connection string, hence configuration manager is not necessary.
If you want more features you can install the full Express edition or SQL Developer edition which is good for dev/test (non-production) usage.
If you want to have an easier way to interface with the LocalDb you can download Management Studio on it's own and it works with LocalDb as well.
answered Nov 21 '18 at 15:02
klabrancheklabranche
19.4k24574
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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%2fstackoverflow.com%2fquestions%2f53414739%2fmissing-sql-server-configuration-manager%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
This installed the LocalDB feature of Express which does not install config mgr, management studio etc and is managed at the command line.
It's meant to be a very easy/quick way to have a lightweight sql server and is not meant to be used except locally and has a special connection string, hence configuration manager is not necessary.
If you want more features you can install the full Express edition or SQL Developer edition which is good for dev/test (non-production) usage.
If you want to have an easier way to interface with the LocalDb you can download Management Studio on it's own and it works with LocalDb as well.
answered Nov 21 '18 at 15:02
klabrancheklabranche
19.4k24574
add a comment |
This installed the LocalDB feature of Express which does not install config mgr, management studio etc and is managed at the command line.
It's meant to be a very easy/quick way to have a lightweight sql server and is not meant to be used except locally and has a special connection string, hence configuration manager is not necessary.
If you want more features you can install the full Express edition or SQL Developer edition which is good for dev/test (non-production) usage.
If you want to have an easier way to interface with the LocalDb you can download Management Studio on it's own and it works with LocalDb as well.
answered Nov 21 '18 at 15:02
klabrancheklabranche
19.4k24574
add a comment |
This installed the LocalDB feature of Express which does not install config mgr, management studio etc and is managed at the command line.
It's meant to be a very easy/quick way to have a lightweight sql server and is not meant to be used except locally and has a special connection string, hence configuration manager is not necessary.
If you want more features you can install the full Express edition or SQL Developer edition which is good for dev/test (non-production) usage.
If you want to have an easier way to interface with the LocalDb you can download Management Studio on it's own and it works with LocalDb as well.
answered Nov 21 '18 at 15:02
klabrancheklabranche
19.4k24574
This installed the LocalDB feature of Express which does not install config mgr, management studio etc and is managed at the command line.
It's meant to be a very easy/quick way to have a lightweight sql server and is not meant to be used except locally and has a special connection string, hence configuration manager is not necessary.
If you want more features you can install the full Express edition or SQL Developer edition which is good for dev/test (non-production) usage.
If you want to have an easier way to interface with the LocalDb you can download Management Studio on it's own and it works with LocalDb as well.
answered Nov 21 '18 at 15:02
klabrancheklabranche
19.4k24574
answered Nov 21 '18 at 15:02
klabrancheklabranche
19.4k24574
answered Nov 21 '18 at 15:02
klabrancheklabranche
19.4k24574
answered Nov 21 '18 at 15:02
klabrancheklabranche
19.4k24574
19.4k24574
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53414739%2fmissing-sql-server-configuration-manager%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
