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

  • Thread starter Thread starter WWGD
  • Start date Start date
  • Tags Tags
    Server Sql
Click For Summary
The discussion centers around the difficulty in locating SQL Server Configuration Manager after installing SQL Server Express 2017 and SQL Server Developer 2017. Users need Configuration Manager to enable TCP/IP for remote connections but are unsure if it can be downloaded separately or if a complete uninstallation of SQL Server is necessary. It is noted that Configuration Manager can be found under Computer Management in Windows 10. There are also considerations about installing SQL Server in the Program Files MSSQL folder. The conversation touches on the security of remote connections and the potential costs associated with cloud services like Microsoft Azure and Amazon, with a cautionary note about unexpected charges from free tiers. Overall, the easiest solution for running SQL Server installations may be through cloud services, although budget constraints are a concern for some users.
WWGD
Science Advisor
Homework Helper
Messages
7,772
Reaction score
12,994
[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:
Computer science news on Phys.org
Do you know how to allow remote connections through your router? How are you going to keep this secure?
 
  • Like
Likes WWGD
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 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 WWGD
Well, not quite £0, but not enough for high-end either.
 

Similar threads

  • · Replies 1 ·
Replies
1
Views
2K
Replies
11
Views
2K
  • · Replies 18 ·
Replies
18
Views
4K
  • · Replies 4 ·
Replies
4
Views
2K
Replies
1
Views
4K
Replies
2
Views
2K
  • · Replies 1 ·
Replies
1
Views
4K
  • · Replies 10 ·
Replies
10
Views
3K
Replies
2
Views
3K
Replies
2
Views
3K