rippernz

Hi all,

I have been trying to upgrade our current DS 6.1 up to 6.9 SP2 but i get errors when opening the console.

I thought it might be a to bigger jump from 6.1 --> 6.9 so i have also tried 6.5 but get the same error.

The error that i get is "Invalid object name 'dbo.fn_get_comparable_ip Statement(s) could not be prepared" I have followed KB number 18007 but finishes with an error "can not find 'dns_suffix', because it does not exist or you don't have permission"
Its logged in as the local admin and also the account that installed SQL. If i remove the dns_suffix it works but still doesn't resolve the problem.

Im using a copy of our production DB from 6.1

Anyone else got any on how to resolve this problem.

Sorry if it in the wrong section.

Thanks