# AddSqlServer

- Module: [Aspire.Hosting.SqlServer](/reference/api/go/aspire.hosting.sqlserver.md)
- Version: `17.0.0`
- Kind: `method`
- Defined on: `DistributedApplicationBuilder`
- Source: [GitHub](https://github.com/microsoft/aspire/tree/bcfa151cdca6d0a573f22d5d9c23f9c727cb3b2f)

Adds a SQL Server resource to the application model. A container is used for local development.

## Remarks

This version of the package defaults to the tag of the / container image.

## Definition

```go
func (DistributedApplicationBuilder) AddSqlServer(
    name string,
    options ...*AddSqlServerOptions,
) SqlServerServerResource
```

## Parameters

- `name` (`string`) -- The name of the resource. This name will be used as the connection string name when referenced in a dependency.
- `options` (`...*AddSqlServerOptions`) -- optional settings, see [Options](#options)

## Options

Optional parameters are passed in a trailing `options ...*AddSqlServerOptions` argument.

- `Password` (`*ParameterResource`) -- The parameter used to provide the administrator password for the SQL Server resource. If `null` a random password will be generated.
- `Port` (`*float64`) -- The host port for the SQL Server.

## Returns

[`SqlServerServerResource`](/reference/api/go/aspire.hosting.sqlserver/sqlserverserverresource.md) -- The resource builder.

Returns a handle; failures surface later via `Err()`.

## Applies to

- `DistributedApplicationBuilder`
