May 21, 2020 at 4:44 pm
Last night I went to the control panel and removed any programs that had 'SQL' in its name. That was the 2017 version of SSMS. I wanted to start fresh. I downloaded SSMS 18. I'm not sure of the server name, so I tried to find it here:
under the section titled "Find the error log location if you can't connect to SQL Server."
It says to open Configuration Manager. I don't see that CM was installed so there is nothing to open up. Last night on a previous attempt I was able to find an error log file (a Notepad file). I copied the server name shown when I tried to connect to SSMS and it didn't work.
Over a year ago I changed my computer's name, so maybe that has something to do with it.
See the attached picture. On one of the tries last night, I remembered seeing another folder below the folder 'Client SDK' but this is from my most recent try and that other folder is not there.
I am trying to start absolutely from the beginning. I tried to wipe out all previous installations of SSMS and then download and start with the latest one, but it's not working.
After running the download I see this folder: C:\Program Files\Microsoft SQL Server but to my surprise I also see these:
C:\Program Files (x86)\Microsoft SQL Server and C:\Program Files (x86)\Microsoft SQL Server Management Studio 18
I'm not sure how an installation can appear in 3 different folders.
Does anybody have any suggestions on how I can get SSMS 18 installed after I download it? I'm willing to start from scratch if necessary.
May 21, 2020 at 5:26 pm
Also, what are these folders that are numbered, such as 110, 140, etc? What do these folders represent?
Program Files\Microsoft SQL Server\110
Program Files\Microsoft SQL Server\140
Program Files\Microsoft SQL Server\150
May 21, 2020 at 5:49 pm
To answer question number 2 about the folders, those are version numbers. 110 is 2012, 140 is 2017, 150 is 2019.
If you installed SSMS 18, it does not come with a SQL instance. You uninstalled all SQL related things from your system (as indicated at the start of the post) and then installed SSMS 18 which looks like it installed successfully. SSMS does not come with configuration manager. If you uninstalled ALL SQL stuff from your machine, you likely uninstalled SQL Server as well.
You will need to install SQL Server, not just SSMS, if you want to connect to a SQL instance.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 21, 2020 at 6:06 pm
that configuration manager reference there is to be executed on the SERVER where SQL Server is installed, not where you installed the client tools.
So unless you also intend in having a local SQL Server instance you will need to get the details of the server to connect to elsewhere (from who maintains the servers)
On SSMS when you try to connect to a server the error will be shown immediately - and will not ask you to look at CM or at a log file elsewhere
May 21, 2020 at 8:16 pm
I should have mentioned that I am installing SSMS on my personal laptop. When you download SSMS I thought that SQL server is automatically installed also. I'll try downloading SQL server.
May 21, 2020 at 8:28 pm
To answer question number 2 about the folders, those are version numbers. 110 is 2012, 140 is 2017, 150 is 2019.
If you installed SSMS 18, it does not come with a SQL instance. You uninstalled all SQL related things from your system (as indicated at the start of the post) and then installed SSMS 18 which looks like it installed successfully. SSMS does not come with configuration manager. If you uninstalled ALL SQL stuff from your machine, you likely uninstalled SQL Server as well.
You will need to install SQL Server, not just SSMS, if you want to connect to a SQL instance.
I got it. I downloaded SQL Server Express and I was able to connect. Thank you very much!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply