---
title: "A SQLServer on Azure PaaS"
description: "An example of a SQLServer on Azure PaaS"
url: "https://www.pulumi.com/dev/examples/azure-cs-sqlserver/"
image: "https://www.pulumi.com/assets/og/dev/examples/azure-cs-sqlserver.png"
---

# A SQLServer on Azure PaaS

An example of a SQLServer on Azure PaaS

- Source on GitHub: https://github.com/pulumi/examples/tree/master/azure-cs-sqlserver
- Deploy with Pulumi: https://app.pulumi.com/new?template=https%3A%2F%2Fgithub.com%2Fpulumi%2Fexamples%2Ftree%2Fmaster%2Fazure-cs-sqlserver

## Get started with this example

This example lives in the [pulumi/examples](https://github.com/pulumi/examples/tree/master/azure-cs-sqlserver) repo. Pull down just this directory to follow along:

```bash
git clone --filter=blob:none --sparse https://github.com/pulumi/examples pulumi-examples
git -C pulumi-examples sparse-checkout set azure-cs-sqlserver
cd pulumi-examples/azure-cs-sqlserver
```

This example configures a [SQLServer on Azure PaaS](https://docs.microsoft.com/en-us/azure/azure-sql/database/logical-servers).

In addition to the server itself, a database is configured.

## Prerequisites

1. [Install Pulumi](https://www.pulumi.com/docs/get-started/install/)
2. [Configure Azure credentials](https://www.pulumi.com/docs/intro/cloud-providers/azure/setup/)
3. [Install .NET](https://www.pulumi.com/docs/intro/languages/dotnet/)

## Deploying the example

1.  Create a new stack:

    ```bash
    pulumi stack init dev
    ```

1.  Log in to the Azure CLI (you will be prompted to do this during deployment if you forget this step):

    ```bash
    az login
    ```

1.  Set the Azure region location to use:

    ```bash
    pulumi config set azure-native:location westus
    ```

1.  Run `pulumi up` to preview and deploy changes:

    ```bash
    pulumi up
    ```

    ```
    Previewing changes:
    ...

    Performing changes:
    ...
    Resources:
        + 5 created
    Duration: 3m16s
    ```

1.  Check the deployed SQL server and database.

## Cleaning up

Once you are done, you can destroy all of the resources, and the stack:

```bash
pulumi destroy
pulumi stack rm
```
