I installed SQL Server in Win10....Without Config Manager?

  • Thread starter Thread starter WWGD
  • Start date Start date
  • Tags Tags
    Server Sql
Join the discussion
Ask a follow-up here, or get your own question answered by working scientists, mathematicians and engineers — people, not an autocomplete.
Real named experts · corrections over time · the nuance an AI answer skips
8 replies · 3K views
Messages
7,822
Reaction score
13,151
[I cannot find my SQL Server Configuration Manager]
Hi, I have installed both SQL Server Express 2017 and SQL Server Developer 2017 (Separately; not one as a Default or Otherwise Instance) , and they have both run without any major problem. Issue now is that I want to allow a remote connection ( I always ran both as local machines) which requires me to ( among other things) enable TCP/IP . But in order to do that I must use the Configuration Manager, which I cannot find my SQL Server Configuration Manager. Is it possible to download it as a stand-alone into SQL Server ( Through Management Studio, say), or do I have to uninstall the whole SQL Server? I don't know anything about Visual Studio which may be another option. I thought Config Manager would install itself automatically but it seems that is not the case.
Any ideas, suggestions, please?
EDIT: My apologies, tunnel vision .
New Question: I am wondering if it would better to install it in the MSSQL Folder in Program Files?
 
Last edited:
Physics news on Phys.org
Sorry, that wasn't very helpful. What I should have said is that the easiest way to get a SQL Server installation running is to use a cloud service such as Microsoft Azure.
 
  • Like
Likes   Reactions: WWGD
Thanks all, this seems tied down to the issue I mentioned in other post on having a 32- and 64- bit instances coexisting. Config manager is , in win10, under Computer Management, in case anyone is interested.
 
pbuk said:
Do you know how to allow remote connections through your router? How are you going to keep this secure?
Yes, thanks, I know I have to enable tcp/ip. I need to re read the instructions.
 
pbuk said:
Sorry, that wasn't very helpful. What I should have said is that the easiest way to get a SQL Server installation running is to use a cloud service such as Microsoft Azure.
Well, I am a bit weary after hearing of cases where someone was careless with their free tier in Amazon ,ended up paying a couple $100 by unknowingly using something outside the free tier.
 
WWGD said:
Well, I am a bit weary after hearing of cases where someone was careless with their free tier in Amazon ,ended up paying a couple $100 by unknowingly using something outside the free tier.
Yes, Amazon is worse for this than Azure IME - one big "gotcha" is CloudWatch - a free tier Dynamo DB instance can clock up $$$ in CloudWatch logs on the default settings.

But now I am aware that your budget is approximately £0, I know that any SQL Server cloud service is out of your reach!
 
  • Like
Likes   Reactions: WWGD