Hi,

Essentially the collation of your server and your database are different. In our environment our ASPNETDB is set to SQL_Latin1_General_CP1_CI_AS so i therefore assume that your server is Latin1_General_CI_AS. The collation is basically the character set that your server uses.

The error you're getting is saying that it can't compare strings from one with the other. Therefore you need to either change the collation of your database (easy), or change the collation of the server (not so easy).

If you want to change the collation of the server you need to rebuild the master database with the collation you want, probably SQL_Latin1_General_CP1_CI_AS. If you just want to change the collation of the database, you can right-click the DB in SSMS and then go to the options page and select Latin1_General_CI_AS from the drop down list. However if the default collation of the ASPNETDB is SQL_Latin1_General_CP1_CI_AS then the more correct solution is to change the collaiton of the server.

Changing the collation of the server will affect any other databases that currently reside on it though so don't undertake this lightly.

Thanks,

Simon