{"id":78,"date":"2018-03-27T21:17:42","date_gmt":"2018-03-27T14:17:42","guid":{"rendered":"http:\/\/www.sqlservertutorial.net\/?page_id=78"},"modified":"2024-09-30T10:56:22","modified_gmt":"2024-09-30T03:56:22","slug":"connect-to-the-sql-server","status":"publish","type":"page","link":"https:\/\/www.sqlservertutorial.net\/getting-started\/connect-to-the-sql-server\/","title":{"rendered":"Connect to the SQL Server"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to connect to SQL Server from the SQL Server Management Studio and execute a query.<\/p>\n\n\n\n

Connect to the SQL Server using SSMS #<\/a><\/h2>\n\n\n\n

To connect to the SQL Server using the Microsoft SQL Server Management Studio, follow these steps:<\/p>\n\n\n\n

Step 1. Launch the Microsoft SQL Server Management Studio:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 2. Choose the Database Engine<\/strong>…\u00a0<\/strong> from the Connect<\/strong> menu under the Object Explorer<\/strong>:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 3. Enter the following information:<\/p>\n\n\n\n

    \n
  1. Server Type: Database Engine<\/strong><\/li>\n\n\n\n
  2. Server name: localhost<\/strong><\/li>\n\n\n\n
  3. Authentication: SQL Server Authentication<\/strong><\/li>\n\n\n\n
  4. Login: sa<\/strong><\/li>\n\n\n\n
  5. Password: (The one you entered during the installation<\/a>.)<\/li>\n\n\n\n
  6. Check the Remember Password<\/strong>. <\/li>\n\n\n\n
  7. Encryption: Optional<\/strong> <\/li>\n<\/ol>\n\n\n\n

    Click the Connect<\/strong> button to connect to the SQL Server:<\/p>\n\n\n\n

    \"Connect<\/figure>\n\n\n\n

    If the connection is successful, you will see the following Object Explorer<\/strong> panel:<\/p>\n\n\n\n

    \"Connect<\/figure>\n\n\n\n

    Execute a query #<\/a><\/h2>\n\n\n\n

    To execute a query you follow these steps:<\/p>\n\n\n\n

    First, right-click on the localhost (SQL Server …)<\/strong> node and choose the New Query<\/strong> menu item:<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    Second, enter the following query in the Editor<\/p>\n\n\n

    select<\/span> @@version<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    This query returns the version of the SQL Server.<\/p>\n\n\n\n
    Third, click the Execute<\/strong> button:<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    The Results<\/strong> window shows the version of the SQL Server as shown in the above screenshot. A quick way to execute a query is to press the F5<\/strong> keyboard shortcut.<\/p>\n\n\n\n
    Now, you should know how to connect to an SQL Server and execute a query from the SSMS.<\/p>\n
    \n\t
    \n\t\t
    Was this tutorial helpful?<\/div>\n\t\t
    \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
    \n\t\t
    \n\t\t\t
    <\/div>\n\t\t\t\n\t\t\t