I am in the process of moving over copies of some applications that reside on a SQL Server 2005 box. I am wanting to upgrade the db to 2008 R2 and wanted to know if the version of Sales Logix I'm using is supported by SQL Server 2008 R2.

All of the documentation that I have do not have any information about SQL Server 2008 since it's an older version.

Thanks,

MG

No offense , but a bigger question would be why only 6.2.1 ?   You should at least get the latest service pack of 6.2



With SQL Server 2008 you can make the database compatiable with 2005.   I've never done this but I don't see why it would not work.  In theory it could also work with 2012.

Sorry, the version is 6.2.6.1007

I've tried to have it connect, but it's giving me errors:

Test Connect failed

Invalid object name 'plugin'

The sysdba is disconnected. Fix this via the fixsysdba script.

Thanks Mike. I have inherited this system without much concerning with the original CD that may contain that script. Do you happen to have that?

Thank you,

Marty

This is the script you need (logged in as sa against the database)

sp_change_users_login 'Update_One', 'sysdba', 'sysdba'

You should execute:

select * from userinfo 

When logged into SQL Studio as sysdba. NB: Do not use the sysdba qualifier. The SQL should run as above and return rows. If it doesn't - then the database is not restored correctly.

Thanks Mike. That worked like a charm.

Thanks for your help.

Marty

No probs!