Collation error message crating a new database in Management Studi -
05-08-2008
, 03:26 AM
When I press OK button in new database window of management studio the
following error message appears:
"Collation '<predefinite del server>' is not valid (Microsoft-SqlServer.Smo)"
the server seems not to have a default collation set.
if i manually select "SQL_Latin1_General_CP1_CI_AS" the database is created.
this happened after a SP2 installation.
any help?
my environment:
Windows server 2003 R2 SP2 english version
MS SQL 2005 enterprise in cluster with 2 nodes (italian version)
SP2 installed.
--
Marco Rotondi, Roma, IT |