How to find new server name and why the last not working

▲
0
▼

I have Microsoft SQL Server 2016. I used to go in with a server name and there was no problem.

Recently there was a problem with the boot file, also known as the 0x00000034 blue screen error.

After the patch, it does not let enter the local server name.

Before

before enter

but the result

the error in entering

I tried other names and also examined similar questions without any good results. for example- How to find server name of SQL Server Management Studio and also How to find server name of SQL Server Management Studio but without any success.

ssms
sql-server-2016
asked on Stack Overflow Dec 31, 2018 by Ela • edited Dec 31, 2018 by scsimon

3 Answers

▲
0
▼

There might be an issue with the connection to the server instance. I would try the troubleshooting steps in the question and answer from this post How do I fix the error 'Named Pipes Provider, error 40 - Could not open a connection to' SQL Server'? or from this video https://www.youtube.com/watch?v=810cv3PunkA

answered on Stack Overflow Dec 31, 2018 by Marc0
▲
0
▼

The server name, that you enter there is the name of the computer, on which the SQL Server has been installed. This is called "default instance", because you do not specify a name of the instance, which is in the format "computer_name\instance_name". If you are trying to connect to an instance (either default or named) installed on your local computer, you can substitute computer_name with . (dot), i.e. you can connect to a default instance on your computer by giving ., or to a named instance as .\SQLEXPRESS for example.

So in your case if you specify only a dot for server name, you should be able to connect. If you don't connect, then the SQL Server instance is not working. You can check is the service started, but you may have to reinstall SQL Server.

If the connection is successful, then you can keep using . (or (local)). If you want to find your computer's name, from Windows Explorer right click This PC and select Properties, then look at Computer name:.

If you still can't connect to the SQL Server using this computer name, then you have issues not related to the SQL Server engine itself. Open a command prompt and try to ping the computer name: ping desktop-7t2s4sm. If you get an error, then you have a networking issue.

answered on Stack Overflow Dec 31, 2018 by Andrey Nikolov
▲
0
▼

press win key + R or type run in start (open run)

type services.msc

look for SQL Server (MSSQLSERVER)

right click on it

click on start :)

answered on Stack Overflow May 13, 2019 by Shady

User contributions licensed under CC BY-SA 3.0