Login Failed when connecting with Pervasive Monitor Utility
Login Failed when connecting with Pervasive Monitor Utility
(OP)
Hello,
We have Pervasive.SQL 8.6 installed on a Windows Server which is part of a Windows domain.
The domain administrator is able to use the Pervasive.SQL Monitor Utility from any client pc on the network to view active Pervasive.SQl users. The domain administrator simply needs connect to the Pervasive.SQL server and log in using the security credentials.
However, we want some NON administrators to be able to run the Pervasive.SQL monitor utility as well.
If we insert those users as members of the Domain Administrators group, they can log in. However, we do not want to do this.
We ran the Local Security Policy Tool on the server that Pervasive.SQL is installed on and made some changes to the "Security Settings / Local Policies / User Rights Assignment".
We adding the user accounts to "Act as part of the operating System" and "Log on Locally".
However, when those users try to connect to the Pervasive.SQL server from a client PC running the monitor utility, still get the error "Login Failed".
How can we accomplish what we want?
Regards,
Georges
We have Pervasive.SQL 8.6 installed on a Windows Server which is part of a Windows domain.
The domain administrator is able to use the Pervasive.SQL Monitor Utility from any client pc on the network to view active Pervasive.SQl users. The domain administrator simply needs connect to the Pervasive.SQL server and log in using the security credentials.
However, we want some NON administrators to be able to run the Pervasive.SQL monitor utility as well.
If we insert those users as members of the Domain Administrators group, they can log in. However, we do not want to do this.
We ran the Local Security Policy Tool on the server that Pervasive.SQL is installed on and made some changes to the "Security Settings / Local Policies / User Rights Assignment".
We adding the user accounts to "Act as part of the operating System" and "Log on Locally".
However, when those users try to connect to the Pervasive.SQL server from a client PC running the monitor utility, still get the error "Login Failed".
How can we accomplish what we want?
Regards,
Georges
RE: Login Failed when connecting with Pervasive Monitor Utility
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: Login Failed when connecting with Pervasive Monitor Utility
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: Login Failed when connecting with Pervasive Monitor Utility
This worked. Thanks a lot.
Regards,
Georges
RE: Login Failed when connecting with Pervasive Monitor Utility
One other thing. What if we have the Pervasive SQL is install on a Domain Controller. We are not able to install a local group called "Pervasive_Admin" since this is disabled on a domain controller. We tried to create a security group called "Pervasive_Admin" but it does not seem to work.
Regards,
Georges
RE: Login Failed when connecting with Pervasive Monitor Utility
Did you get our last post?
Regards,
Georges
RE: Login Failed when connecting with Pervasive Monitor Utility
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: Login Failed when connecting with Pervasive Monitor Utility
I did then did the change remotely on a DC that was also running Pervasive.SQL but could not test this myself but asked someone to do so who was on the local network and they said it was not working. Maybe I did something wrong (or they are doing something wrong). I will go over my work once more.
Thanks for the response.
Regards,
Georges