---
title: "how to configure SQL server in google cloud?"  
description: "how to configure SQL server in google cloud?"  
author: "Nishi Tiwari"  
published: 2020-01-07  
updated: 2020-01-07  
canonical: https://www.mindstick.com/forum/155644/how-to-configure-sql-server-in-google-cloud  
category: "webhosting"  
tags: ["google cloud"]  
reading_time: 2 minutes  

---

# how to configure SQL server in google cloud?

[describe](https://www.mindstick.com/interview/12752/what-is-ddms-describe-some-of-its-capabilities) it.

## Replies

### Reply by Nishi Tiwari

## Configure the SQL Server

- In SQL Server 2014 Management Studio, click the Security folder for the library SQL Server instance.
- Right-click Logins and select New login.
- For Login name, enter “dotnetapp”.
- For the Authentication method, click SQL Server Authentication.
- For Password, enter a password of your choice. Don't enable the Enforce password policy option.
- Change the Default Database to be the “bookshelf” database you previously created.
- In the left side of the New login dialog, click User Mapping and complete the following steps:

a. For the bookshelf database, click the Map checkbox.

b. Under Database role membership for: bookshelf, click all of the roles except for the following:

• db_denydatareader

• db_denydatawriter

- To create the new database login account, click OK.
- The user you created is set to use SQL Server authentication so SQL Server needs to be configured to allow this authentication method. In SQL Server 2014 Management Studio right-click the Library SQL Server instance you created and select Properties.
- In the left-side menu of the Server Properties dialog, click Security.
- For the Server Authentication setting, select SQL Server and Windows Authentication mode, and then click OK.
- To restart the SQL Server service, right-click the Library SQL Server instance and select Restart.


---

Original Source: https://www.mindstick.com/forum/155644/how-to-configure-sql-server-in-google-cloud

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.