cancel
Showing results for 
Search instead for 
Did you mean: 

How to enable Query Data from Other Databases on other Server using SAP B1 10 Query Manager

0 Kudos

Hello,
I have tested SAP-Note 2907995 on local Server with SAP 10 using different Databases on the same Server

I just edit the B1-User (SLD Database-User) in SQL as DBO-Schema and activated "db_reader"
for the other Database.... Works fine.

Now my questions is regarding two Databases on different SQL-Servers:
I can setup the Database-user on the other SQL, but I do not have the password.


query-server-to-server.jpg
Does anyone have an Idea, how to set in SQL-Mgmt-Studio
if we want to query via SAP Query Manager to another Server-Database ?

Thanks

Markus

Accepted Solutions (0)

Answers (0)