How to find out the user name which is connecting to the dbase.

We have
• Windows Server 2003
• AR Server 6.03 with patch 005
• SQL Server 2000

I tried to see File --> Server information --> Database using admin tool. I saw the ARAdmin as the User name and ARSystem as the Database name.

But I don’t see any user of that name in the SQLServer 2000 database. The only user in the SQL Server is 'sa'

In ar.cfg I don’t have anything saying db-user-name.

How to find out what is the username remedy uses to connect to its respective database server.

The AR System database user (ARAdmin by default) and password
(AR#Admin# by default) are set during AR System server installation.

I have that same environment as you, if you look in Microsoft SQL Enterprise Manager, expand databases, expand AR System, select users and you can see it says DBO, Login Name ARAdmin.


User name ARAdmin
Pass AR#Adnin#

To test, register the server in SQL Enterprise Manager.

Thank you. Appreciate your help.

Use following command:

select * from dba_users;