# MS SQL Server You can create your MS SQL Server connection from either your team's dashboard or directly from a spreadsheet. From the dashboard, navigate to the **Connections** page or from a spreadsheet press / and then **Manage connections**. ## Connection details To connect to your MS SQL Server database, you'll need to enter the parameters in the **Team connections** modal:
### Connection name You can name your connection however you'd like. This is the display name for your connection across Quadratic and your team. ``` example: Sales Database ``` ### Host name This is the connection host, the direct connection to your database. It can be an IP address or URL. You might see a connection string that looks something like this: ``` mysql://default:xyz123@mysql-hostname.com:5432 ``` The hostname is the IP address or URL. From the above connection string, this would be the host, which you would add to the **Hostname** field: ``` mysql-hostname.com ``` ### Port number This is the connection port; you might see it at the end of your hostname after the colon. It is typically a four-digit number. From the above example, add this number to the **Port** field. `3306` is the default port number for MySQL. ``` 3306 ``` ### Database name This is the name of the database you want to connect to. Your database can have multiple tables - be sure to use the **database name** and not the name of a table. Example database name: ``` mysql_db ``` ### **Username** This is an authentication detail that depends on your database account username. Some common defaults include `admin` or `default`. This information is in your database's authentication details, found in your database's authentication settings, or received from your database administrator. Example: ``` admin ``` ### **Password** This is the password you use to connect to your database. This information is in your database's authentication details, found in your database's authentication settings, or received from your database administrator. Example: ``` 1234abcd ``` ## IP allow-list {% hint style="info" %} You must whitelist both Quadratic IP addresses to make connections, which are:\ **44.240.255.40** \ **54.68.134.35** *\* These IP addresses do not apply to self-hosted instances* {% endhint %} If you need help setting up your data sources, [contact us](https://quadratichq.com/contact). Some extra resources and instructions vary depending on where your database lives. [AWS](https://docs.aws.amazon.com/vpc/latest/userguide/vpc-security-groups.html), [Azure](/getting-started.md), [GCP](https://cloud.google.com/firewall/docs/firewalls) Once you've made your connection, you can use it directly in spreadsheets to read data to your spreadsheets. Learn how [here](/connections/sql-getting-started.md#step-1-use-your-connection). --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.quadratichq.com/connections/ms-sql-server.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.