Connect to Azure SQL
You connect to your SQL Server databases in the same way as you connect to SQL Server when using SQL Server Management Studio.
- Go to the SQL Spreads tab in Excel and click the Design Mode button
- 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.
- 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
- Select if you should connect using your Windows-login (Windows Authentication) or enter a user name and password (SQL Server Authentication)
- 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.
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.
- 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:
- Paste the Azure SQL name into the SQL Server name field in the SQL Spreads connection dialog:
- 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: