SQL Error: SQL Error : Invalid object name 'sys.syscolumns

[Proware]

I have set up Sugar Pro 4.5 on a new server and converted the MySQL database to MS SQL using a commercial conversion tool.

I have sugar running now but the menu options do not exist (obnly displays Home and TeamSync).

So I opened up the Admin . Repair and started going through them. When I tried Expand Column Width I get:
SQL Error : Invalid object name 'sys.syscolumns'.

When I try Repair Database I get
SQL Error : ALTER TABLE ALTER COLUMN id failed because one or more objects access this column.

Any ideas?

[kuske]

What about the database settings ins config.php?
Sounds as if your instalaltion uses mysql syntax to access mssql.

[Proware]

I am using the following:

'dbconfig' =>
array (
'db_host_name' => 'localhost',
'db_user_name' => 'sa',
'db_password' => 'sapassword',
'db_name' => 'sugarcrmpro',
'db_type' => 'mssql',
),
'dbconfigoption' =>


Should I do anything else?

[kuske]

looks good, anybody else any idea?

[Proware]

I just realised that I am using MS SQL Server 2000 and I see from the supported platform that only MS SQL Server 2005 is supported.

Could this be the problem?

[kuske]

I cannot imagine, I never used a mssql server greater than 2000 till now.

But I suppose your sugar db user has no right to read the sys tables.
Perhaps this is the real problem?