cancel
Showing results for 
Search instead for 
Did you mean: 

How to create user other than 'sa' to connect database server in SAP SBO

Former Member
0 Kudos

I want to ask how the step for create user other than 'sa' to connect database server in SAP SBO? Until now I use 'sa' (default) for connect to database server in SAP SBO application.

Can I do that?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

You may create multiple SQL users to give full right to B1 database instead of using 'sa' user.

However, the preferred way would be by Use Trusted connection when you set the connection to SQL Server. In this way, you just need one more user for SQL. A group of window users could use this SQL access to connect database server.

Thanks,

Gordon