(imported topic written by Marty.Amaral)
So we had to rebuild our BigFix server and database and now I can’t run certain things using my login creds. More specificly, but not limited to, BESComputerRemover. When I try and run it as myself, BESComputerRemover-3.0.1.122.exe or BESComputerRemover-3.0.1.122.exe –u “My user account” –P “My password” I get the following error
No time specified for deletion of Expired Computers, defaulting to 30 days.
No time specified for deletion of Deleted Computers, defaulting to 90 days.
DBI connect(‘bes_bfenterprise’,‘corporate_nt\marty’,…) failed:
Microsoft
[SQL
Server Native Client 10.0]
SQL Server
Login failed for user 'corporate_nt\marty
'. (SQL-28000) at /<C:\Program Files (x86)\BigFix Enterprise\Downloads\BESComput
erRemover-3.0.1.122.exe>BESTools/Databases.pm line 94
Couldn’t connect to database with DSN (bes_bfenterprise):
Microsoft
[SQL Server
Native Client 10.0]
SQL Server
Login failed for user ‘corporate_nt\marty’. (SQL
-28000)
If I run the program using the SQL “SA” user and password, it works just find.
I have sysadmin rights to the database and my SQL admin doesn’t know what more I need.
It there other rights I need to for this?