Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / how to configure sql server in google cloud?
Ask Question
Nishi Tiwari
Nishi Tiwari

Student

I am a currently pursuing Bca from United Institute of Management. Want to become software developer.

Message

1 Answers

Nishi Tiwari
Nishi Tiwari 07 Jan 2020
Report Abuse

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.
advertising