I am having problems with installing the PKS

Oct 1, 2008 at 1:29 AM
I have installed the program itself but i cannot get it to work.
I also need to know if there is support for SQL server 2000
as that is what we use at my job.
Thank you any help would be greatly appreciated.
Coordinator
Oct 1, 2008 at 4:36 PM
Hi, PKS hasn't been tested on SQL Server 2000... this could be the reason why your deployment isn't working.
We would need more information to be able to help debug further.
Regards.
Oct 10, 2008 at 8:18 PM

These are the errors that SQL Server 2000 Query Analyzer returns:
Can you help?

The CREATE DATABASE process is allocating 0.63 MB on disk 'RatingStore'.
The CREATE DATABASE process is allocating 0.49 MB on disk 'RatingStore_log'.
Server: Msg 15416, Level 16, State 1, Procedure sp_dbcmptlevel, Line 92
Usage: sp_dbcmptlevel [dbname [, compatibilitylevel]]
 
Valid values of database compatibility level are 60, 65, 70, or 80.

(1 row(s) affected)

(0 row(s) affected)

Server: Msg 102, Level 15, State 6, Line 1
Incorrect syntax near 'ENABLE_BROKER'.
Server: Msg 102, Level 15, State 6, Line 1
Incorrect syntax near 'AUTO_UPDATE_STATISTICS_ASYNC'.
Server: Msg 102, Level 15, State 6, Line 1
Incorrect syntax near 'DATE_CORRELATION_OPTIMIZATION'.
Server: Msg 102, Level 15, State 6, Line 1
Incorrect syntax near 'TRUSTWORTHY'.
Server: Msg 102, Level 15, State 6, Line 1
Incorrect syntax near 'ALLOW_SNAPSHOT_ISOLATION'.
Server: Msg 102, Level 15, State 6, Line 1
Incorrect syntax near 'PARAMETERIZATION'.
Server: Msg 102, Level 15, State 6, Line 1
Incorrect syntax near 'CHECKSUM'.
Server: Msg 102, Level 15, State 6, Line 1
Incorrect syntax near 'DB_CHAINING'.
Server: Msg 170, Level 15, State 1, Line 10
Line 10: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Server: Msg 2714, Level 16, State 5, Procedure RatedItem_Get, Line 13
There is already an object named 'RatedItem_Get' in the database.
Server: Msg 2714, Level 16, State 5, Procedure RatedItems_Get, Line 14
There is already an object named 'RatedItems_Get' in the database.
Server: Msg 2714, Level 16, State 5, Procedure RatingComment_Delete, Line 76
There is already an object named 'RatingComment_Delete' in the database.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Server: Msg 2714, Level 16, State 5, Procedure ReturnPage, Line 49
There is already an object named 'ReturnPage' in the database.
Server: Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Downloads' in the database.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 18
Line 18: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 10
Line 10: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 2714, Level 16, State 6, Line 1
There is already an object named 'AccountProperties' in the database.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 13
Line 13: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 11
Line 11: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 11
Line 11: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 17
Line 17: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near '('.
Server: Msg 2714, Level 16, State 5, Procedure Ratings_GetByItemIdList, Line 15
There is already an object named 'Ratings_GetByItemIdList' in the database.
Server: Msg 2714, Level 16, State 6, Procedure RatingsStats, Line 37
There is already an object named 'RatingsStats' in the database.
Server: Msg 170, Level 15, State 1, Procedure RatingComment_Add, Line 21
Line 21: Incorrect syntax near 'try'.
Server: Msg 170, Level 15, State 1, Procedure RatingComment_Add, Line 44
Line 44: Incorrect syntax near 'try'.
Server: Msg 195, Level 15, State 1, Procedure RatingComment_Add, Line 47
'xact_state' is not a recognized function name.
Server: Msg 170, Level 15, State 1, Procedure RatingComment_Add, Line 55
Line 55: Incorrect syntax near 'max'.
Server: Msg 195, Level 15, State 1, Procedure RatingComment_Add, Line 57
'ERROR_NUMBER' is not a recognized function name.
Server: Msg 137, Level 15, State 1, Procedure RatingComment_Add, Line 63
Must declare the variable '@ErrorMessage'.
Server: Msg 137, Level 15, State 1, Procedure RatingComment_Add, Line 65
Must declare the variable '@ErrorMessage'.
Server: Msg 170, Level 15, State 1, Procedure AddTerms, Line 13
Line 13: Incorrect syntax near '('.
Server: Msg 2714, Level 16, State 5, Procedure RatedItem_Add, Line 54
There is already an object named 'RatedItem_Add' in the database.
Server: Msg 2714, Level 16, State 5, Procedure RatedItem_Update, Line 24
There is already an object named 'RatedItem_Update' in the database.
Server: Msg 2714, Level 16, State 5, Procedure RatingComments_Get, Line 15
There is already an object named 'RatingComments_Get' in the database.
Server: Msg 2714, Level 16, State 5, Procedure UserAccount_Get, Line 15
There is already an object named 'UserAccount_Get' in the database.
Server: Msg 2714, Level 16, State 5, Procedure Rating_Get, Line 15
There is already an object named 'Rating_Get' in the database.
Server: Msg 2714, Level 16, State 5, Procedure Ratings_Get, Line 13
There is already an object named 'Ratings_Get' in the database.
Server: Msg 2714, Level 16, State 5, Procedure Rating_GetByLobUserId, Line 14
There is already an object named 'Rating_GetByLobUserId' in the database.
Server: Msg 2714, Level 16, State 6, Procedure RatingCommentStats, Line 30
There is already an object named 'RatingCommentStats' in the database.
Server: Msg 170, Level 15, State 1, Procedure RatingComment_Update, Line 16
Line 16: Incorrect syntax near 'try'.
Server: Msg 170, Level 15, State 1, Procedure RatingComment_Update, Line 26
Line 26: Incorrect syntax near 'try'.
Server: Msg 195, Level 15, State 1, Procedure RatingComment_Update, Line 29
'xact_state' is not a recognized function name.
Server: Msg 170, Level 15, State 1, Procedure RatingComment_Update, Line 37
Line 37: Incorrect syntax near 'max'.
Server: Msg 195, Level 15, State 1, Procedure RatingComment_Update, Line 39
'ERROR_NUMBER' is not a recognized function name.
Server: Msg 137, Level 15, State 1, Procedure RatingComment_Update, Line 45
Must declare the variable '@ErrorMessage'.
Server: Msg 137, Level 15, State 1, Procedure RatingComment_Update, Line 47
Must declare the variable '@ErrorMessage'.
Server: Msg 2714, Level 16, State 5, Procedure UserAccounts_Get, Line 14
There is already an object named 'UserAccounts_Get' in the database.
Server: Msg 170, Level 15, State 1, Procedure Rating_Update, Line 20
Line 20: Incorrect syntax near 'try'.
Server: Msg 170, Level 15, State 1, Procedure Rating_Update, Line 53
Line 53: Incorrect syntax near 'try'.
Server: Msg 195, Level 15, State 1, Procedure Rating_Update, Line 56
'xact_state' is not a recognized function name.
Server: Msg 170, Level 15, State 1, Procedure Rating_Update, Line 64
Line 64: Incorrect syntax near 'max'.
Server: Msg 195, Level 15, State 1, Procedure Rating_Update, Line 66
'ERROR_NUMBER' is not a recognized function name.
Server: Msg 137, Level 15, State 1, Procedure Rating_Update, Line 72
Must declare the variable '@ErrorMessage'.
Server: Msg 137, Level 15, State 1, Procedure Rating_Update, Line 74
Must declare the variable '@ErrorMessage'.
Server: Msg 170, Level 15, State 1, Procedure Rating_Delete, Line 12
Line 12: Incorrect syntax near 'try'.
Server: Msg 170, Level 15, State 1, Procedure Rating_Delete, Line 36
Line 36: Incorrect syntax near 'try'.
Server: Msg 195, Level 15, State 1, Procedure Rating_Delete, Line 39
'xact_state' is not a recognized function name.
Server: Msg 170, Level 15, State 1, Procedure Rating_Delete, Line 47
Line 47: Incorrect syntax near 'max'.
Server: Msg 195, Level 15, State 1, Procedure Rating_Delete, Line 49
'ERROR_NUMBER' is not a recognized function name.
Server: Msg 137, Level 15, State 1, Procedure Rating_Delete, Line 55
Must declare the variable '@ErrorMessage'.
Server: Msg 137, Level 15, State 1, Procedure Rating_Delete, Line 57
Must declare the variable '@ErrorMessage'.
Server: Msg 170, Level 15, State 1, Procedure Rating_Add, Line 21
Line 21: Incorrect syntax near 'try'.
Server: Msg 170, Level 15, State 1, Procedure Rating_Add, Line 55
Line 55: Incorrect syntax near 'try'.
Server: Msg 195, Level 15, State 1, Procedure Rating_Add, Line 58
'xact_state' is not a recognized function name.
Server: Msg 170, Level 15, State 1, Procedure Rating_Add, Line 66
Line 66: Incorrect syntax near 'max'.
Server: Msg 195, Level 15, State 1, Procedure Rating_Add, Line 68
'ERROR_NUMBER' is not a recognized function name.
Server: Msg 137, Level 15, State 1, Procedure Rating_Add, Line 74
Must declare the variable '@ErrorMessage'.
Server: Msg 137, Level 15, State 1, Procedure Rating_Add, Line 78
Must declare the variable '@ErrorMessage'.
Server: Msg 170, Level 15, State 1, Procedure RatingEval_Add, Line 10
Line 10: Incorrect syntax near 'try'.
Server: Msg 170, Level 15, State 1, Procedure RatingEval_Add, Line 55
Line 55: Incorrect syntax near 'try'.
Server: Msg 195, Level 15, State 1, Procedure RatingEval_Add, Line 58
'xact_state' is not a recognized function name.
Server: Msg 170, Level 15, State 1, Procedure RatingEval_Add, Line 66
Line 66: Incorrect syntax near 'max'.
Server: Msg 195, Level 15, State 1, Procedure RatingEval_Add, Line 68
'ERROR_NUMBER' is not a recognized function name.
Server: Msg 137, Level 15, State 1, Procedure RatingEval_Add, Line 74
Must declare the variable '@ErrorMessage'.
Server: Msg 137, Level 15, State 1, Procedure RatingEval_Add, Line 76
Must declare the variable '@ErrorMessage'.
Server: Msg 2714, Level 16, State 5, Procedure UserAccount_Add, Line 20
There is already an object named 'UserAccount_Add' in the database.
Server: Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'dbo.ItemTerm' because this table does not exist in database 'master'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.ItemTerm' because this table does not exist in database 'master'.
Server: Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'dbo.Rating' because this table does not exist in database 'master'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.Rating' because this table does not exist in database 'master'.
Server: Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'dbo.Rating' because this table does not exist in database 'master'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.Rating' because this table does not exist in database 'master'.
Server: Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'dbo.RatingComment' because this table does not exist in database 'master'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.RatingComment' because this table does not exist in database 'master'.
Server: Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'dbo.RatingComment' because this table does not exist in database 'master'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.RatingComment' because this table does not exist in database 'master'.
Server: Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'dbo.RatingEval' because this table does not exist in database 'master'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.RatingEval' because this table does not exist in database 'master'.
Server: Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'dbo.RatingEval' because this table does not exist in database 'master'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.RatingEval' because this table does not exist in database 'master'.
Server: Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'dbo.RatingTerm' because this table does not exist in database 'master'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.RatingTerm' because this table does not exist in database 'master'.
Server: Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'dbo.Site' because this table does not exist in database 'master'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.Site' because this table does not exist in database 'master'.
Server: Msg 170, Level 15, State 1, Line 15
Line 15: Incorrect syntax near 'FULLTEXT'.
Server: Msg 170, Level 15, State 1, Line 18
Line 18: Incorrect syntax near 'FULLTEXT'.
Server: Msg 170, Level 15, State 1, Line 27
Line 27: Incorrect syntax near 'FULLTEXT'.
Server: Msg 170, Level 15, State 1, Line 31
Line 31: Incorrect syntax near 'FULLTEXT'.
Server: Msg 170, Level 15, State 1, Procedure Ratings_GetPage, Line 13
Line 13: Incorrect syntax near 'max'.
Server: Msg 137, Level 15, State 1, Procedure Ratings_GetPage, Line 29
Must declare the variable '@Select'.
Server: Msg 137, Level 15, State 1, Procedure Ratings_GetPage, Line 29
Must declare the variable '@Select'.
Server: Msg 170, Level 15, State 1, Procedure RatingComment_Add, Line 21
Line 21: Incorrect syntax near 'try'.
Server: Msg 170, Level 15, State 1, Procedure RatingComment_Add, Line 44
Line 44: Incorrect syntax near 'try'.
Server: Msg 195, Level 15, State 1, Procedure RatingComment_Add, Line 47
'xact_state' is not a recognized function name.
Server: Msg 170, Level 15, State 1, Procedure RatingComment_Add, Line 55
Line 55: Incorrect syntax near 'max'.
Server: Msg 195, Level 15, State 1, Procedure RatingComment_Add, Line 57
'ERROR_NUMBER' is not a recognized function name.
Server: Msg 137, Level 15, State 1, Procedure RatingComment_Add, Line 63
Must declare the variable '@ErrorMessage'.
Server: Msg 137, Level 15, State 1, Procedure RatingComment_Add, Line 65
Must declare the variable '@ErrorMessage'.
Server: Msg 170, Level 15, State 1, Procedure RatingComment_Update, Line 16
Line 16: Incorrect syntax near 'try'.
Server: Msg 170, Level 15, State 1, Procedure RatingComment_Update, Line 26
Line 26: Incorrect syntax near 'try'.
Server: Msg 195, Level 15, State 1, Procedure RatingComment_Update, Line 29
'xact_state' is not a recognized function name.
Server: Msg 170, Level 15, State 1, Procedure RatingComment_Update, Line 37
Line 37: Incorrect syntax near 'max'.
Server: Msg 195, Level 15, State 1, Procedure RatingComment_Update, Line 39
'ERROR_NUMBER' is not a recognized function name.
Server: Msg 137, Level 15, State 1, Procedure RatingComment_Update, Line 45
Must declare the variable '@ErrorMessage'.
Server: Msg 137, Level 15, State 1, Procedure RatingComment_Update, Line 47
Must declare the variable '@ErrorMessage'.
Server: Msg 170, Level 15, State 1, Procedure Rating_Update, Line 20
Line 20: Incorrect syntax near 'try'.
Server: Msg 170, Level 15, State 1, Procedure Rating_Update, Line 56
Line 56: Incorrect syntax near 'try'.
Server: Msg 195, Level 15, State 1, Procedure Rating_Update, Line 59
'xact_state' is not a recognized function name.
Server: Msg 170, Level 15, State 1, Procedure Rating_Update, Line 67
Line 67: Incorrect syntax near 'max'.
Server: Msg 195, Level 15, State 1, Procedure Rating_Update, Line 69
'ERROR_NUMBER' is not a recognized function name.
Server: Msg 137, Level 15, State 1, Procedure Rating_Update, Line 75
Must declare the variable '@ErrorMessage'.
Server: Msg 137, Level 15, State 1, Procedure Rating_Update, Line 77
Must declare the variable '@ErrorMessage'.
Server: Msg 170, Level 15, State 1, Procedure Rating_Add, Line 21
Line 21: Incorrect syntax near 'try'.
Server: Msg 170, Level 15, State 1, Procedure Rating_Add, Line 67
Line 67: Incorrect syntax near 'try'.
Server: Msg 195, Level 15, State 1, Procedure Rating_Add, Line 70
'xact_state' is not a recognized function name.
Server: Msg 170, Level 15, State 1, Procedure Rating_Add, Line 78
Line 78: Incorrect syntax near 'max'.
Server: Msg 195, Level 15, State 1, Procedure Rating_Add, Line 80
'ERROR_NUMBER' is not a recognized function name.
Server: Msg 137, Level 15, State 1, Procedure Rating_Add, Line 86
Must declare the variable '@ErrorMessage'.
Server: Msg 137, Level 15, State 1, Procedure Rating_Add, Line 90
Must declare the variable '@ErrorMessage'.
Server: Msg 170, Level 15, State 1, Procedure Rating_Delete, Line 13
Line 13: Incorrect syntax near 'try'.
Server: Msg 170, Level 15, State 1, Procedure Rating_Delete, Line 49
Line 49: Incorrect syntax near 'try'.
Server: Msg 195, Level 15, State 1, Procedure Rating_Delete, Line 52
'xact_state' is not a recognized function name.
Server: Msg 170, Level 15, State 1, Procedure Rating_Delete, Line 60
Line 60: Incorrect syntax near 'max'.
Server: Msg 195, Level 15, State 1, Procedure Rating_Delete, Line 62
'ERROR_NUMBER' is not a recognized function name.
Server: Msg 137, Level 15, State 1, Procedure Rating_Delete, Line 68
Must declare the variable '@ErrorMessage'.
Server: Msg 137, Level 15, State 1, Procedure Rating_Delete, Line 70
Must declare the variable '@ErrorMessage'.
Server: Msg 170, Level 15, State 1, Procedure RatingEval_Add, Line 11
Line 11: Incorrect syntax near 'try'.
Server: Msg 170, Level 15, State 1, Procedure RatingEval_Add, Line 56
Line 56: Incorrect syntax near 'try'.
Server: Msg 195, Level 15, State 1, Procedure RatingEval_Add, Line 59
'xact_state' is not a recognized function name.
Server: Msg 170, Level 15, State 1, Procedure RatingEval_Add, Line 67
Line 67: Incorrect syntax near 'max'.
Server: Msg 195, Level 15, State 1, Procedure RatingEval_Add, Line 69
'ERROR_NUMBER' is not a recognized function name.
Server: Msg 137, Level 15, State 1, Procedure RatingEval_Add, Line 75
Must declare the variable '@ErrorMessage'.
Server: Msg 137, Level 15, State 1, Procedure RatingEval_Add, Line 77
Must declare the variable '@ErrorMessage'.
Server: Msg 15043, Level 16, State 1, Procedure sp_addmessage, Line 127
You must specify 'REPLACE' to overwrite an existing message.
Server: Msg 15043, Level 16, State 1, Procedure sp_addmessage, Line 127
You must specify 'REPLACE' to overwrite an existing message.
Server: Msg 15043, Level 16, State 1, Procedure sp_addmessage, Line 127
You must specify 'REPLACE' to overwrite an existing message.
Server: Msg 15043, Level 16, State 1, Procedure sp_addmessage, Line 127
You must specify 'REPLACE' to overwrite an existing message.
Server: Msg 15043, Level 16, State 1, Procedure sp_addmessage, Line 127
You must specify 'REPLACE' to overwrite an existing message.
Server: Msg 15043, Level 16, State 1, Procedure sp_addmessage, Line 127
You must specify 'REPLACE' to overwrite an existing message.
Server: Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 11
Line 11: Incorrect syntax near '('.
Server: Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'dbo.Downloads' because this table does not exist in database 'RatingStore'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.Downloads' because this table does not exist in database 'RatingStore'.
Server: Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 11
Line 11: Incorrect syntax near '('.
Server: Msg 2714, Level 16, State 5, Procedure Downloads_GetAll, Line 65535
There is already an object named 'Downloads_GetAll' in the database.
Server: Msg 2714, Level 16, State 5, Procedure RegisterDownload, Line 19
There is already an object named 'RegisterDownload' in the database.
Server: Msg 2714, Level 16, State 5, Procedure Downloads_GetUnique, Line 65535
There is already an object named 'Downloads_GetUnique' in the database.
Server: Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'dbo.Downloads' because this table does not exist in database 'RatingStore'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.Downloads' because this table does not exist in database 'RatingStore'.

Coordinator
Oct 13, 2008 at 4:30 AM
It appears from your log that PKS won't work on SQL Server 2000 and needs SQL Server 2005. 
Sorry for the bad news...since we're in the pre-requisite domain, you should also know that PKS will only work on top of Microsoft Office SharePoint Portal Server 2007, and no other version.