How to find server name of SQL Server Management Studio

Question

Microsoft SQL Server 2008 is now installed. I get the Connect to Server login window with a blank textbox for the Server name when I launch SQL Server Management Studio (SSMS). I tried numerous names, but I was unable to figure it out.

How do I locate or obtain the server name?

Answer 1

SQL Server Configuration Manager should be launched (search for it in the Start menu). Select SQL Server Services by clicking. Alongside the SQL Server service, in parenthesis, is the name of the SQL Server instance. When it says MSSQLSERVER, the default instance is being used. Simply type. (dot) OR (local) in Management Studio and click Connect to it. If the instance name differs, connect to it using.[instance name] (for instance, if the instance name is SQL2008, do so using.SQL2008).

In order to connect, make sure the SQL Server and SQL Server Browser services are both active.

I hope this helps you.