0

I would like to run SAGE ERP in or google cloud project using Cloud SQL Server. I have run into 2 issues.

  1. I need to change the collation to case sensitive
  2. The ERP system needs to create multiple SQL users which is not possible since the sqlserver user created by the GCP does not have permission to grant connect permissions. is it possible to increase this users permissions ?

My other option is to use a compute engine and setup SQL server on that, i would prefer to stay with Cloud SQL if it is possible.

any assistance would be greatly appreciated.

Dustin Auby
  • 21
  • 4

1 Answers1

0

Regarding the second point,to create DB users a grant permissions, you can connect to the instance using the SQL Server Management Studio if you have window as OS, if not, you can use the “sqlcmd” tool , in the document “Install sqlcmd and bcp the SQL Server command-line tools on Linux” or mac you can see the steps to install it. Then you have to follow the instructions of the document “Install the Cloud SQL Proxy client on your local machine” to set up the connection to the instance.

Once you are connected to the instance, you can add users to the database using the SQL Server Management Studio console or using this command:

  • Creates the login username with password 'password'. CREATE LOGIN user_name
    WITH PASSWORD = 'password';
    GO

-- Creates a database user for the login created above.
CREATE USER username FOR LOGIN username;
GO

You can see more detail of the previous script on the link.

Once you have created the users, you can add one of the Fixed-Database Roles listed in the link.If you are using the command line you can use the following command:

EXE SP_ADDROLEMEMBER ‘role_name’, ‘user_name’

You can see more detail about adding roles in the link.

Regarding the first point, I think that you can use the same way described in the this response

Enrique Del Valle
  • 524
  • 2
  • 6
  • Hi, this does not seem to work as the user that is created still does not have high enough privileges. Google does not seem to allow this functionality in its Cloud SQL instances. – Dustin Auby Jul 27 '20 at 13:35
  • what ERP system are you using? Do you know the users and the permissions that the ERP creates? Could you create them manually? – Enrique Del Valle Jul 28 '20 at 13:13