Thanks, ive gone though that first link already, Running though the checks
1) only server we have in the environment and the registry indicates roll up is not enabled.
2) The db user was/is the SA user which has full blown rights to the whole server itself, i created a landesk user and assigned it to the database and then ran the landesk configurator to change the settings in the registry. trying again still fails.
3) The value for isNTLM is already "False".
Checks on the dbusers:
"exec sp_helpsrvrolemember 'sysadmin';"
returns the db user along with every test user ive added to the sys_admin group.
this returns 1 from all of the users running the command indicating the user is a sysadmin
since i have spare time to kill i threw LANDesk.Install.Common.Actions.dll into dotPeek to see what exactly is being done.
the error being thrown is:
" ERROR: Execution of CheckIsDatabaseReadyForUpgrade completed. Return code: -1, State: Failure (SetupController.ExecuteNextCommand()) "
I pulled the query used to verify the user is an admin
SELECT COUNT(sid) FROM sys.syslogins WHERE sysadmin = 1 and name = 'lddbuser' (<-- and every single admin users i have in sql works so its not this, even my user id which is running the installer and the installer is running as admin)
Im guessing its some unhandled exception in the installer that is throwing up when its checking the database here:
I found and deleted one stream in my ldlogon folder, reran the installer and it still dies with -1 at "Checking database upgrade prerequisites",
No .net 4.6 or anything other then 4.5
The install is running as an admin user on the box, domain and as admin.
Is there a list of upgrade prerequisites.
So i came in this morning, having done nothing but wait, i noticed last night my unitrends appliance stated the database was in simple recovery mode. I walked into my server room and hit try again and boom, it continued.
now its blowing up on something else, so looks like i just didn't wait long enough.......