Contents x
    Connect to SQL Server
      • Print
      • Dark
        Light
      • PDF
      Contents

      Connect to SQL Server

        • Print
        • Dark
          Light
        • PDF
        Article Summary

        Connect to SQL Server (on-premise)

        1. Go to the SQL Spreads tab in Excel and click the Design Mode button
          Connect to SQL Server 7.1

        2. In the SQL Spreads Designer panel on the right side, click the Edit button to open the SQL Server connection dialog.
          Open the SQL Server connection dialog.png

        3. Enter the name of your SQL Server into the SQL Server name field:
          Connect to SQL Server from Excel.png

        Typical server nameCase
        localhostWhen SQL Server is installed locally
        localhost\sqlexpressWhen SQL Server Express is installed locally
        Domain\ServernameWhen SQL Server is installed in a corporate network
        IP-addressWhen SQL Server is installed in a remote location
        Note:

        Use the same name as when you connect to SQL Server in SQL Server Management Studio.

        1. Select if you should connect using your Windows-login (Windows Authentication) or enter a user name and password (SQL Server Authentication)
          Select SQL Server authentication method.png

        2. Click OK. SQL Spreads will try to connect to the database. If the connection is successful, your databases will show up in the SQL Spreads Designer panel.
          image.png

        Connect to Azure SQL

        SQL Spreads can be used to update and manage data in tables and views in Azure SQL databases in the same way as for an on-premise SQL Server installation.

        1. To connect to an Azure SQL database, you will have to first log in to your Azure Portal and locate the name/URL of your Azure SQL Server:
          find the Azure SQL Server name.png

        2. Paste the Azure SQL name into the SQL Server name field in the SQL Spreads connection dialog:
          Enter Azure Server Name

        3. Enter the user name and password in the fields in the connection dialog.
          You can find the Azure SQL user name if you click the Server name in the first image above:
          Azure Server name.png

        4. Click OK.

        Using Azure AD Authentication

        SQL Spreads can be used in conjunction with Azure AD authentication for a more secure solution.

        1. Enter the Azure SQL name into the SQL Server name field in the SQL Spreads connection dialog:
          Azure AD Auth Server Name Display1

        2. Select the Azure AD Authentication option:
          Azure AD Auth Select Option

        3. Click OK.

        4. Sign in with your Azure AD Account credentials:
          Azure AD Auth Sign In View

        5. After your credentials have been verified, the connection window will disappear and your server name will be populated in the SQL Spreads Designer under Document's SQL Server connection. You can now see a list of your databases available through your Azure AD authentication connection and can begin building your SQL Spreads sheet.
          Azure AD Connection Successful

        Note:

        If you are not sure that your connection was successful, click on the Edit button in the Database tab in the Design Mode. Then click on the Test Connection button and you will see a window pop-up with the following confirmation message "Successfully connected to the database".

        Was this article helpful?
        What's Next

        SQL Spreads