Stay organized with collections Save and categorize content based on your preferences.
Cloud SQL supports SQL Server Reporting Services (SSRS) which helps you create, deploy, and manage paginated reports.
This page provides the prerequisites, setup procedure, and limitations for using SSRS in Cloud SQL.
Before you beginBefore using SSRS on Cloud SQL, you must have the following:
A Cloud DNS record to assign a hostname for your Cloud SQL instance. You can create a hostname by using one of the following options:
hosts file to create a custom alias for your instance.Two existing Cloud SQL logins, a setup login and a service login. To create a login, see gcloud sql users create.
If you want to use Windows authentication, then you must use Managed Active Directory to join the SQL Server instance and the host running SSRS. For more information, see Use Managed Microsoft AD with Cloud SQL.
To set up SSRS in Cloud SQL, perform the following steps:
Acquire an SSRS leaseSSRS requires elevated permissions during setup. To acquire an SSRS lease for your instance, use the following command:
gcloudUse the following command to acquire a lease:
gcloud sql instances acquire-ssrs-lease INSTANCE_NAME \ --project=PROJECT_NAME \ --setup-login=SETUP_LOGIN \ --service-login=SERVICE_LOGIN \ --report-database=REPORT_DATABASE \ --duration=DURATION \
The following table describes this operation's gcloud parameters:
--setup-login Required. The login used to connect to the instance during SSRS setup. This is the first login that is requested in Report Server Configuration Manager when setting a report server database. This must be a existing SQL Server login, such as sqlserver None --service-login Required. The SQL Server login used by report server to connect to the report server database during SSRS setup. This is the second login that is requested in Report Server Configuration Manager when setting a report server database. This must be an existing SQL Server login and must be different from the setup login. None. --report-database Required. An existing or a new report database name on the instance. Certain special characters are not allowed in the report database name, such as spaces, brackets, non-English characters. None --duration Optional. The number of hours that the SSRS lease is active during which you can perform the SSRS setup. Between 1 and 12 hours. For example, 4h 5 hours REST v1 Using the REST API, you can acquire an SSRS lease on an instance. To acquire an SSRS lease, specify the following:
Only the DURATION field is optional. For more information, see AcquireSsrsLeaseContext:
4h.HTTP method and URL:
POST https://sqladmin.googleapis.com/sql/v1/projects/PROJECT_ID/instances/INSTANCE_NAME/acquireSsrsLease
Request JSON body:
{
"acquireSsrsLeaseContext": {
"setupLogin": SETUP_LOGIN,
"serviceLogin": SERVICE_LOGIN,
"reportDatabase": REPORT_DATABASE,
"duration": DURATION,
}
} REST v1beta4 Using the REST API, you can acquire an SSRS lease on an instance. To acquire an SSRS lease, specify the following:
Only the DURATION field is optional. For more information, see AcquireSsrsLeaseContext:
4h.HTTP method and URL:
POST https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID/instances/INSTANCE_NAME/acquireSsrsLease
Request JSON body:
{
"acquireSsrsLeaseContext": {
"setupLogin": SETUP_LOGIN,
"serviceLogin": SERVICE_LOGIN,
"reportDatabase": REPORT_DATABASE,
"duration": DURATION,
}
} Set up SSRS Note: To automate the setup process described in this section, you can use any scripting solution, such as PowerShell.
To perform the SSRS setup, follow these steps:
You can release a lease manually, or you can wait until the lease automatically expires. Releasing the lease is required to revert any elevated permissions needed for setup and to allow the service login to connect to the report database. The service login can't access the report database until the lease expires or is released manually. The following command releases an SSRS lease.
gcloudUse the following command to release a lease:
gcloud sql instances release-ssrs-lease INSTANCE_NAME \ --project=PROJECT_NAMEREST v1
Using the REST API, you can release an SSRS lease for an instance. As shown in the following request example, you only need to provide the instance name and project ID.
HTTP method and URL:
POST https://sqladmin.googleapis.com/v1/projects/PROJECT_ID/instances/INSTANCE_NAME/releaseSsrsLeaseREST v1beta4
Using the REST API, you can release an SSRS lease for an instance. As shown in the following request example, you only need to provide the instance name and project ID.
HTTP method and URL:
POST https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID/instances/INSTANCE_NAME/releaseSsrsLeaseLimitations
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-08-14 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-14 UTC."],[],[]]
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4