How do I find the Server Name for SQL Server Management Studio 2017 RC1

Navigation
0

I need to establish a connection to the SQL Server, but I can not get my Server Name . Does anyone know how to get instance for SQL Server V17.0 RC1 ?

    
asked by user20100 25.11.2016 в 04:27
source

4 answers

1

You have tried the server name with (local) or localhost or with the period. ? Look at the services that are running that you will have there the name of the instance (service sql server), the default is usually MSSQLSERVER and if you have changed the name of the instance is usually machinename \ instancename. See also that the service is up

    
answered by 25.11.2016 в 12:57
0

If you do not care about the name of the IP, opening a terminal window on the server you can execute this ipconfig command and it will return the IP address of that computer (the server). Then just put the IP in the client sql and ready.

    
answered by 25.11.2016 в 09:08
0

Verify that the SQL Browser service is running and in the configuration manager you confirm that you have active protocols on which you are going to connect to the server.

[

    
answered by 25.11.2016 в 13:30
-1

You must enter the MMC (SQL Server 2017 Configuration Manager) and in SQL Server you will see the name of the instance of your local server, there you press properties and you will see your HostName and your instance,

To open the MMC you can type mmc from windows search or press ctrl + r

You can also enter by typing:

SQLServerManager14.msc for SQL Server 2017

SQLServerManager13.msc for SQL Server 2016

SQLServerManager12.msc for SQL Server 2014

SQLServerManager11.msc for SQL Server 2012

SQLServerManager10.msc for SQL Server 2008

Greetings,

    
answered by 16.01.2019 в 19:33
How to compare elements of two arrays? Upload Form Django Error (invalid literal for int () with base 10)