Dynamics Community Forum Thread Details

NAV 2013 Upgradation SQL Server error dependent on database collation

Hi,

I am upgrading from NAV2009 SP1 to NAV 2013. In this process I executed Upgrade Toolkit 1st FOB in NAV 2009 SP1 It executed Successfully. after that deleted all the objects except Tables. and tried to Upgrade in NAV 2013 Application. while upgrading I am getting following SQL error. Please help on how to overcome this.

---------------------------

Microsoft Dynamics NAV Development Environment

---------------------------

The following SQL Server error or errors occurred:

5075,"42000",[Microsoft][SQL Server Native Client 10.0][SQL Server]The object 'Goa Carbon Limited - ALL$Item Ledger Entry$VSIFT$22' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.

5075,"42000",[Microsoft][SQL Server Native Client 10.0][SQL Server]The object 'Goa Carbon Limited - ALL$Item Ledger Entry$VSIFT$25' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.

5075,"42000",[Microsoft][SQL Server Native Client 10.0][SQL Server]The object 'Goa Carbon Limited - ALL$Item Ledger Entry$VSIFT$30' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.

5075,"42000",[Microsoft][SQL Server Native Client 10.0][SQL Server]The object 'Goa Carbon Limited - BILASPUR$Item Ledger Entry$VSIFT$22' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.

5075,"42000",[Microsoft][SQL Server Native Client 10.0][SQL Server]The object 'Goa Carbon Limited - BILASPUR$Item Ledger Entry$VSIFT$25' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.

5075,"42000",[Microsoft][SQL Server Native Client 10.0][SQL Server]The object 'Goa Carbon Limited - BILASPUR$Item Ledger Entry$VSIFT$30' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.

5075,"42000",[Microsoft][SQL Server Native Client 10.0][SQL

---------------------------