Connect to SQL Server

Connect to SQL Server
Connect to Azure SQL

Connect to SQL Server from the SQL Spreads Excel Add-In

You connect to your SQL Server databases in the same way as you connect to SQL Server when using SQL Server Management Studio. 
  1. Go to the SQL Spreads tab in Excel and click the Design Mode button

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

    Note: You connect to your SQL Server databases in the same way as you connect to your databases in SQL Server Management Studio.

  3. Enter the name of your SQL Server into the SQL Server name field:

      Typical SQL Server names are:
    localhost              When SQL Server is installed locally              
    localhost\sqlexpress   When SQL Server Express is installed locally      
    Domain\Servername      When SQL Server is installed in a corporate network
    IP-address             When SQL Server is installed in a remote location    

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

  5. 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. 

Connect to Azure SQL from the SQL Spreads Excel Add-In

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:
      
  2. Paste the Azure SQL name into the SQL Server name field in the SQL Spreads connection dialog:  
  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:

Feedback and Knowledge Base