Welcome to our Knowledge Base

Enter your search terms below.

Categories
< All topics
Print

SQL Server Collation

Description of the problem

CreateSteadyDB does not install a new Database and fails with the error “Error installing a new Database: Invalid object name ‚information_schema.columns‘.

 

This error can be encounterd by customers that are not using

COLLATE SQL_Latin1_General _CI_AS.

Most likely this will happen to people from countries that use a different default collation than Latin1. You can see here what’s the default collation for your Operation System when installing Sql Server.

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms143508(v=sql.105)


Solution

To see what collation your SQL server is using you can use SQL Management Studio “Master -> Properties -> Options -> Collation”

Update Collation:
The easiest way is to reinstall SQL Server and choose the Latin1_General_CI_AS.

To change the collation without updating SQL Server we suggest the following Microsoft Knowledge Base https://support.microsoft.com/en-us/help/325335/how-to-transfer-a-database-from-one-collation-to-another-collation-in

It’s important to perform a backup of the Master Table before changing the collation.

Was this article helpful?
0 out Of 5 Stars
5 stars 0%
4 stars 0%
3 stars 0%
2 stars 0%
1 stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Back Requirements for the use of steadyPRINT
Next steadyPRINT Agent freezes after network change (fixed in Version 6.5.4)
btnimage