Any Error on SQL Scripts?

Topics: Developer Discussion, Help, Request
Mar 11, 2007 at 11:34 AM
Hi,
I try to install csk on Windows Server 2003 SP1 and Sql2005 Ent. However, i get error messages when i run the sql script.

The Error Message;

Msg 137, Level 15, State 2, Procedure PagedAlbumList, Line 24
Must declare the scalar variable "@ownerid".
Msg 137, Level 15, State 2, Procedure PagedAlbumList, Line 28
Must declare the scalar variable "@ownerid".
Msg 137, Level 15, State 2, Procedure PagedAlbumList, Line 33
Must declare the scalar variable "@ownerid".
Msg 468, Level 16, State 9, Procedure aspnetUsersInRolesAddUsersToRoles, Line 45
Cannot resolve the collation conflict between "SQLLatin1GeneralCP1CIAS" and "TurkishCI_AI" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnetUsersInRolesAddUsersToRoles, Line 52
Cannot resolve the collation conflict between "SQLLatin1GeneralCP1CIAS" and "TurkishCI_AI" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnetUsersInRolesAddUsersToRoles, Line 76
Cannot resolve the collation conflict between "SQLLatin1GeneralCP1CIAS" and "TurkishCI_AI" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnetUsersInRolesAddUsersToRoles, Line 83
Cannot resolve the collation conflict between "SQLLatin1GeneralCP1CIAS" and "TurkishCI_AI" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnetUsersInRolesAddUsersToRoles, Line 90
Cannot resolve the collation conflict between "SQLLatin1GeneralCP1CIAS" and "TurkishCI_AI" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnetUsersInRolesRemoveUsersFromRoles, Line 50
Cannot resolve the collation conflict between "SQLLatin1GeneralCP1CIAS" and "TurkishCI_AI" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnetUsersInRolesRemoveUsersFromRoles, Line 58
Cannot resolve the collation conflict between "SQLLatin1GeneralCP1CIAS" and "TurkishCI_AI" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnetUsersInRolesRemoveUsersFromRoles, Line 84
Cannot resolve the collation conflict between "SQLLatin1GeneralCP1CIAS" and "TurkishCI_AI" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnetUsersInRolesRemoveUsersFromRoles, Line 92
Cannot resolve the collation conflict between "SQLLatin1GeneralCP1CIAS" and "TurkishCI_AI" in the equal to operation.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'aspnetUsersInRolesAddUsersToRoles', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'aspnetUsersInRolesRemoveUsersFromRoles', because it does not exist or you do not have permission.

Is it something wrong with the script.. or..?

Btw, i downloaded the Sql2005 script.

Thanks,
Coordinator
Mar 11, 2007 at 4:16 PM
It has always worked for me... is it an empty database?
Mar 12, 2007 at 8:29 AM
yes, a brand new system and totally empty database.
Mar 12, 2007 at 10:02 AM
ok i resolved it manually addin gthe line

DECLARE @ownerid UNIQUEIDENTIFIER

after line 2566. and then i replaced the collation definitions to TurkishCIAS. now it's ok.