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

Discussion Overview

The discussion revolves around the challenges faced by a user in locating the SQL Server Configuration Manager after installing SQL Server Express and Developer editions on Windows 10. The user seeks assistance in enabling remote connections, specifically TCP/IP, without the Configuration Manager, and explores various options for installation and configuration.

Discussion Character

  • Technical explanation
  • Debate/contested
  • Exploratory

Main Points Raised

  • One participant expresses difficulty in finding the SQL Server Configuration Manager and questions whether it can be downloaded separately or if a reinstallation is necessary.
  • Another participant shares a link to Microsoft documentation on SQL Server Configuration Manager, possibly to assist with the user's query.
  • There are inquiries about allowing remote connections through a router and concerns regarding security implications.
  • Some participants suggest that using a cloud service like Microsoft Azure might simplify the installation process, although this is met with skepticism regarding potential costs associated with cloud services.
  • A participant mentions the coexistence of 32- and 64-bit instances as a related issue and provides information about accessing the Configuration Manager through Computer Management in Windows 10.
  • Concerns are raised about the costs associated with cloud services, particularly referencing experiences with Amazon's free tier and the potential for unexpected charges.

Areas of Agreement / Disagreement

Participants express varying opinions on the best approach to resolve the user's issue, with some advocating for cloud services while others highlight concerns about costs and security. There is no consensus on the best solution or approach to the problem presented.

Contextual Notes

Participants discuss the implications of using different SQL Server instances and the potential for confusion regarding Configuration Manager's availability. There are also references to security and budgeting concerns related to cloud services.

WWGD
Science Advisor
Homework Helper
Messages
7,797
Reaction score
13,095
[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   Reactions: 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   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
Well, not quite £0, but not enough for high-end either.
 

Similar threads

Installing SQL Server Dev Config Manager (Snap in)
  • · Replies 1 ·
Replies
1
Views
2K
Trouble Connecting to Default Instance in SQL Server 2017 (Win10)
  • · Replies 11 ·
Replies
11
Views
2K
Amateur Dev Q: Creating Front End for SQL Server DB
  • · Replies 18 ·
Replies
18
Views
4K
How Can I Script Windows for a New Server Installation?
  • · Replies 4 ·
Replies
4
Views
2K
How Can I SSH into My Mac Mini Server from Outside My Network?
  • · Replies 1 ·
Replies
1
Views
5K
How can I set up remote assistance software without configuring firewall rules?
  • · Replies 2 ·
Replies
2
Views
2K
Networking Problems? LLDP Didn't work
  • · Replies 1 ·
Replies
1
Views
5K
Using MS stuff since I bought my PC
  • · Replies 10 ·
Replies
10
Views
3K
How Can I Design a Secure Configuration for Linux Servers and Web Applications?
  • · Replies 2 ·
Replies
2
Views
3K
I could really use some help picking my optional module [GameDev]
  • · Replies 2 ·
Replies
2
Views
3K