SQL Server Express 2008 R2 Configuration Manager How To Find It
I run Windows 8.1. I installed SQL Express 2008 R2 over a year ago, but now need to access it from another machine. My problem is that the Configuration Manager (SQLServerManage10.msc) is not on my machine, I have scanned the entire machine, hidden folders and all, it just is not there. My problem is where to find/download/whatever. I have tried re-install/repair - still no SQLServerManage10.msc. Anyone have any ideas ?? I see this problem has been posted before, but responses concentrated on where to find it - no good for me - I know I ain't got it.
sql-server
asked May 19 '15 at 15:42
Malcolm GomersallMalcolm Gomersall
1
bumped to the homepage by Community♦ 2 hours ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I run Windows 8.1. I installed SQL Express 2008 R2 over a year ago, but now need to access it from another machine. My problem is that the Configuration Manager (SQLServerManage10.msc) is not on my machine, I have scanned the entire machine, hidden folders and all, it just is not there. My problem is where to find/download/whatever. I have tried re-install/repair - still no SQLServerManage10.msc. Anyone have any ideas ?? I see this problem has been posted before, but responses concentrated on where to find it - no good for me - I know I ain't got it.
sql-server
asked May 19 '15 at 15:42
Malcolm GomersallMalcolm Gomersall
1
bumped to the homepage by Community♦ 2 hours ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I run Windows 8.1. I installed SQL Express 2008 R2 over a year ago, but now need to access it from another machine. My problem is that the Configuration Manager (SQLServerManage10.msc) is not on my machine, I have scanned the entire machine, hidden folders and all, it just is not there. My problem is where to find/download/whatever. I have tried re-install/repair - still no SQLServerManage10.msc. Anyone have any ideas ?? I see this problem has been posted before, but responses concentrated on where to find it - no good for me - I know I ain't got it.
sql-server
asked May 19 '15 at 15:42
Malcolm GomersallMalcolm Gomersall
1
I run Windows 8.1. I installed SQL Express 2008 R2 over a year ago, but now need to access it from another machine. My problem is that the Configuration Manager (SQLServerManage10.msc) is not on my machine, I have scanned the entire machine, hidden folders and all, it just is not there. My problem is where to find/download/whatever. I have tried re-install/repair - still no SQLServerManage10.msc. Anyone have any ideas ?? I see this problem has been posted before, but responses concentrated on where to find it - no good for me - I know I ain't got it.
sql-server
sql-server
asked May 19 '15 at 15:42
Malcolm GomersallMalcolm Gomersall
1
asked May 19 '15 at 15:42
Malcolm GomersallMalcolm Gomersall
1
asked May 19 '15 at 15:42
Malcolm GomersallMalcolm Gomersall
1
asked May 19 '15 at 15:42
Malcolm GomersallMalcolm Gomersall
1
asked May 19 '15 at 15:42
Malcolm GomersallMalcolm Gomersall
1
1
bumped to the homepage by Community♦ 2 hours ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 2 hours ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
run MMC.exe
select File - Add remove snapin and find the SQL Server configuration manager and add it to the console root.
Save the MMC console for later use with the extension.msc.
If the SQL Server Configuration manager does not show up in the MMC console you have to register the DLL's and recompile the .mof for it
Open a command prompt with run as admin, type the following command, and then press ENTER:
mofcomp "%programfiles(x86)%Microsoft SQL Server100Sharedsqlmgmproviderxpsp2up.mof"
After you run the Mofcomp tool, restart the WMI service for the changes to take effect. The service name is Windows management Instrumentation.
Then you might need to register two .dll's In your case:
regsvr32.exe "C:Program FilesMicrosoft SQL Server100Sharedsqlmgmprovider.dll"
regsvr32.exe "C:Program FilesMicrosoft SQL Server100Sharedsvrenumapi.dll”
Of course the files have to exist. The value of number depends on the version of SQL Server
Microsoft SQL Server 2014 120
Microsoft SQL Server 2012 110
Microsoft SQL Server 2008 R2 100
Microsoft SQL Server 2008 100
Microsoft SQL Server 2005 90
And on SQL Server 2014 you have to register svrenumapi120.dll
answered May 19 '15 at 16:15
SpörriSpörri
3,549722
I thank you for your prompt reply. Not there yet. I have done everything you suggested with the following changes I do not have svrenumapi.dll, but do have svrenumapi100.dll. I tried to register that, but received a message saying this was not an OCX or com-dll, By the way - I am running 2008 r2 express 32bit. Still SQL Configuration Manager does not appear in the snap-in list in MMC.exe
– Malcolm Gomersall
May 19 '15 at 17:30
Re-starting WMI was fruitless, so I re-booted my machine - still nothing. Once again, TX for your help so far.
– Malcolm Gomersall
May 19 '15 at 17:35
1
Thank You for support, I resolved the issue by install Service Pack 2.
– Malcolm Gomersall
May 19 '15 at 21:37
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%2f101916%2fsql-server-express-2008-r2-configuration-manager-how-to-find-it%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
run MMC.exe
select File - Add remove snapin and find the SQL Server configuration manager and add it to the console root.
Save the MMC console for later use with the extension.msc.
If the SQL Server Configuration manager does not show up in the MMC console you have to register the DLL's and recompile the .mof for it
Open a command prompt with run as admin, type the following command, and then press ENTER:
mofcomp "%programfiles(x86)%Microsoft SQL Server100Sharedsqlmgmproviderxpsp2up.mof"
After you run the Mofcomp tool, restart the WMI service for the changes to take effect. The service name is Windows management Instrumentation.
Then you might need to register two .dll's In your case:
regsvr32.exe "C:Program FilesMicrosoft SQL Server100Sharedsqlmgmprovider.dll"
regsvr32.exe "C:Program FilesMicrosoft SQL Server100Sharedsvrenumapi.dll”
Of course the files have to exist. The value of number depends on the version of SQL Server
Microsoft SQL Server 2014 120
Microsoft SQL Server 2012 110
Microsoft SQL Server 2008 R2 100
Microsoft SQL Server 2008 100
Microsoft SQL Server 2005 90
And on SQL Server 2014 you have to register svrenumapi120.dll
answered May 19 '15 at 16:15
SpörriSpörri
3,549722
I thank you for your prompt reply. Not there yet. I have done everything you suggested with the following changes I do not have svrenumapi.dll, but do have svrenumapi100.dll. I tried to register that, but received a message saying this was not an OCX or com-dll, By the way - I am running 2008 r2 express 32bit. Still SQL Configuration Manager does not appear in the snap-in list in MMC.exe
– Malcolm Gomersall
May 19 '15 at 17:30
Re-starting WMI was fruitless, so I re-booted my machine - still nothing. Once again, TX for your help so far.
– Malcolm Gomersall
May 19 '15 at 17:35
1
Thank You for support, I resolved the issue by install Service Pack 2.
– Malcolm Gomersall
May 19 '15 at 21:37
add a comment |
run MMC.exe
select File - Add remove snapin and find the SQL Server configuration manager and add it to the console root.
Save the MMC console for later use with the extension.msc.
If the SQL Server Configuration manager does not show up in the MMC console you have to register the DLL's and recompile the .mof for it
Open a command prompt with run as admin, type the following command, and then press ENTER:
mofcomp "%programfiles(x86)%Microsoft SQL Server100Sharedsqlmgmproviderxpsp2up.mof"
After you run the Mofcomp tool, restart the WMI service for the changes to take effect. The service name is Windows management Instrumentation.
Then you might need to register two .dll's In your case:
regsvr32.exe "C:Program FilesMicrosoft SQL Server100Sharedsqlmgmprovider.dll"
regsvr32.exe "C:Program FilesMicrosoft SQL Server100Sharedsvrenumapi.dll”
Of course the files have to exist. The value of number depends on the version of SQL Server
Microsoft SQL Server 2014 120
Microsoft SQL Server 2012 110
Microsoft SQL Server 2008 R2 100
Microsoft SQL Server 2008 100
Microsoft SQL Server 2005 90
And on SQL Server 2014 you have to register svrenumapi120.dll
answered May 19 '15 at 16:15
SpörriSpörri
3,549722
I thank you for your prompt reply. Not there yet. I have done everything you suggested with the following changes I do not have svrenumapi.dll, but do have svrenumapi100.dll. I tried to register that, but received a message saying this was not an OCX or com-dll, By the way - I am running 2008 r2 express 32bit. Still SQL Configuration Manager does not appear in the snap-in list in MMC.exe
– Malcolm Gomersall
May 19 '15 at 17:30
Re-starting WMI was fruitless, so I re-booted my machine - still nothing. Once again, TX for your help so far.
– Malcolm Gomersall
May 19 '15 at 17:35
1
Thank You for support, I resolved the issue by install Service Pack 2.
– Malcolm Gomersall
May 19 '15 at 21:37
add a comment |
run MMC.exe
select File - Add remove snapin and find the SQL Server configuration manager and add it to the console root.
Save the MMC console for later use with the extension.msc.
If the SQL Server Configuration manager does not show up in the MMC console you have to register the DLL's and recompile the .mof for it
Open a command prompt with run as admin, type the following command, and then press ENTER:
mofcomp "%programfiles(x86)%Microsoft SQL Server100Sharedsqlmgmproviderxpsp2up.mof"
After you run the Mofcomp tool, restart the WMI service for the changes to take effect. The service name is Windows management Instrumentation.
Then you might need to register two .dll's In your case:
regsvr32.exe "C:Program FilesMicrosoft SQL Server100Sharedsqlmgmprovider.dll"
regsvr32.exe "C:Program FilesMicrosoft SQL Server100Sharedsvrenumapi.dll”
Of course the files have to exist. The value of number depends on the version of SQL Server
Microsoft SQL Server 2014 120
Microsoft SQL Server 2012 110
Microsoft SQL Server 2008 R2 100
Microsoft SQL Server 2008 100
Microsoft SQL Server 2005 90
And on SQL Server 2014 you have to register svrenumapi120.dll
answered May 19 '15 at 16:15
SpörriSpörri
3,549722
run MMC.exe
select File - Add remove snapin and find the SQL Server configuration manager and add it to the console root.
Save the MMC console for later use with the extension.msc.
If the SQL Server Configuration manager does not show up in the MMC console you have to register the DLL's and recompile the .mof for it
Open a command prompt with run as admin, type the following command, and then press ENTER:
mofcomp "%programfiles(x86)%Microsoft SQL Server100Sharedsqlmgmproviderxpsp2up.mof"
After you run the Mofcomp tool, restart the WMI service for the changes to take effect. The service name is Windows management Instrumentation.
Then you might need to register two .dll's In your case:
regsvr32.exe "C:Program FilesMicrosoft SQL Server100Sharedsqlmgmprovider.dll"
regsvr32.exe "C:Program FilesMicrosoft SQL Server100Sharedsvrenumapi.dll”
Of course the files have to exist. The value of number depends on the version of SQL Server
Microsoft SQL Server 2014 120
Microsoft SQL Server 2012 110
Microsoft SQL Server 2008 R2 100
Microsoft SQL Server 2008 100
Microsoft SQL Server 2005 90
And on SQL Server 2014 you have to register svrenumapi120.dll
answered May 19 '15 at 16:15
SpörriSpörri
3,549722
edited May 19 '15 at 16:24
answered May 19 '15 at 16:15
SpörriSpörri
3,549722
answered May 19 '15 at 16:15
SpörriSpörri
3,549722
answered May 19 '15 at 16:15
SpörriSpörri
3,549722
3,549722
I thank you for your prompt reply. Not there yet. I have done everything you suggested with the following changes I do not have svrenumapi.dll, but do have svrenumapi100.dll. I tried to register that, but received a message saying this was not an OCX or com-dll, By the way - I am running 2008 r2 express 32bit. Still SQL Configuration Manager does not appear in the snap-in list in MMC.exe
– Malcolm Gomersall
May 19 '15 at 17:30
Re-starting WMI was fruitless, so I re-booted my machine - still nothing. Once again, TX for your help so far.
– Malcolm Gomersall
May 19 '15 at 17:35
1
Thank You for support, I resolved the issue by install Service Pack 2.
– Malcolm Gomersall
May 19 '15 at 21:37
add a comment |
I thank you for your prompt reply. Not there yet. I have done everything you suggested with the following changes I do not have svrenumapi.dll, but do have svrenumapi100.dll. I tried to register that, but received a message saying this was not an OCX or com-dll, By the way - I am running 2008 r2 express 32bit. Still SQL Configuration Manager does not appear in the snap-in list in MMC.exe
– Malcolm Gomersall
May 19 '15 at 17:30
Re-starting WMI was fruitless, so I re-booted my machine - still nothing. Once again, TX for your help so far.
– Malcolm Gomersall
May 19 '15 at 17:35
1
Thank You for support, I resolved the issue by install Service Pack 2.
– Malcolm Gomersall
May 19 '15 at 21:37
I thank you for your prompt reply. Not there yet. I have done everything you suggested with the following changes I do not have svrenumapi.dll, but do have svrenumapi100.dll. I tried to register that, but received a message saying this was not an OCX or com-dll, By the way - I am running 2008 r2 express 32bit. Still SQL Configuration Manager does not appear in the snap-in list in MMC.exe
– Malcolm Gomersall
May 19 '15 at 17:30
I thank you for your prompt reply. Not there yet. I have done everything you suggested with the following changes I do not have svrenumapi.dll, but do have svrenumapi100.dll. I tried to register that, but received a message saying this was not an OCX or com-dll, By the way - I am running 2008 r2 express 32bit. Still SQL Configuration Manager does not appear in the snap-in list in MMC.exe
– Malcolm Gomersall
May 19 '15 at 17:30
Re-starting WMI was fruitless, so I re-booted my machine - still nothing. Once again, TX for your help so far.
– Malcolm Gomersall
May 19 '15 at 17:35
Re-starting WMI was fruitless, so I re-booted my machine - still nothing. Once again, TX for your help so far.
– Malcolm Gomersall
May 19 '15 at 17:35
1
1
Thank You for support, I resolved the issue by install Service Pack 2.
– Malcolm Gomersall
May 19 '15 at 21:37
Thank You for support, I resolved the issue by install Service Pack 2.
– Malcolm Gomersall
May 19 '15 at 21:37
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f101916%2fsql-server-express-2008-r2-configuration-manager-how-to-find-it%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
