Reply to thread

Message

<blockquote data-quote="arion_p" data-source="post: 422377" data-attributes="member: 45945">Your SQL Server collation should be set to Greek_CI_AS.To check the server collation open SQL Server Management Studio Express (SSMSE) and&nbsp; connect to you local SQL Server. In &quot;Object Explorer&quot; right click your server and select &quot;Properties&quot;. In page &quot;General&quot; look at the value of &quot;Server Collation&quot;, it should be Greek_CI_AS. Also expand the &quot;Databases&quot; node, right click the tvserver database (MpTvDb) and select &quot;Properties&quot;. In page &quot;General&quot; look at the value of &quot;Collation&quot;, it should be Greek_CI_AS. If this is correct, you don't need to change SQL server collation and your problem is elsewhere.If you do want to change the server collation you can use the following command, but it will delete all SQL Server databases, so you will have to run SetupTV to recreate it and reconfigure TVServer (I am assuming you do not have any other databases):[CODE]start /wait setup.exe /qb INSTANCENAME=SQLEXPRESS REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=[I]&lt;your new sa password&gt;[/I] SQLCOLLATION=Greek_CI_AS[/CODE]The command should be run in a command prompt after changing to the directory &quot;C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap&quot;. Replace &lt;your new sa password&gt; with your new SA password.Arion</blockquote>

[QUOTE="arion_p, post: 422377, member: 45945"] Your SQL Server collation should be set to Greek_CI_AS. To check the server collation open SQL Server Management Studio Express (SSMSE) and connect to you local SQL Server. In "Object Explorer" right click your server and select "Properties". In page "General" look at the value of "Server Collation", it should be Greek_CI_AS. Also expand the "Databases" node, right click the tvserver database (MpTvDb) and select "Properties". In page "General" look at the value of "Collation", it should be Greek_CI_AS. If this is correct, you don't need to change SQL server collation and your problem is elsewhere. If you do want to change the server collation you can use the following command, but it will delete all SQL Server databases, so you will have to run SetupTV to recreate it and reconfigure TVServer (I am assuming you do not have any other databases): [CODE] start /wait setup.exe /qb INSTANCENAME=SQLEXPRESS REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=[I]<your new sa password>[/I] SQLCOLLATION=Greek_CI_AS [/CODE] The command should be run in a command prompt after changing to the directory "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap". Replace [I]<your new sa password>[/I] with your new SA password. Arion [/QUOTE]

Verification