Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (6.1k points)
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?

1 Answer

0 votes
by (12.7k points)
edited by

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.

enter image description here

enter image description here

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.

Related questions

Browse Categories

...