Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BigMeat
Yak Posting Veteran
56 Posts |
 Posted - 2006-01-04 : 17:24:49
|
| HiI have a Web Application which I am developing in Asp.Net 2.0 with a SQL Server 2000 DB. I am trying to configure my existing SQL Server DB for Forms authenication by using the aspnet_regsql.exe wizard. When I try to configure my existing DB i get a 446 SQL error saying that there was Collation problem and that my DB could not be configured. I look at my DB and the colation setting is blank? The databse is about 2 years old and has always been a SLQ 2000 DB.However if I create a new DB from scratch and use the aspnet_regsql tool everything works fine. Teh collation on the new DB is SQL_Latin1_General_Cp1_CI_AS does this mean that my DB needs this colation?I dont understand why the tool does not work under different colations? Also why does my existing DB has no colation? Has anybody had any similar problems? Any ideas??Many thanks in advance |
|
|
|
|
|
Forms Authentication Collation Problem