How to find server name of SQL Server Management Studio

Question

I had installed the Microsoft SQL Server 2008.

I tried starting the SQL Server Management Studio (SSMS), It shows the Connect to the SQL Server login window with an empty textbox for the Server name. I had tried a lot of names, but I couldn't solve it.

How can I find the SQL server name?

Answer 1

You have to select your server name and the authentication mode correctly.

The default server name is your computer name, but you can also use "." (Dot) instead of the local server name.

To select your server name, follow the steps below.

Then set the correct authentication mode: Windows or SQL Authentication based on your SQL Server Installation.

If you had given SQL Authentication during the Installation of SQL Server, then select SQL Authentication, then provide the username as "sa" and give the password whatever you had given during SQL Server installation and connect.

Want to know more about SQL ? Join this SQL Certification course by Intellipaat.

Answer 2

When you open SSMS, check the server name in the ‘Connect to Server’ dialog box or you can also run the below query.

SELECT @@SERVERNAME AS Server_Name;

Another way is to click right on the server in object explorer then choose properties. At the top of the dialog box you can find the server name.