Error Installing .net database security into an existing one

Hi experts

i have a database (some tables and some store procedure), running on sql server 2000

i have had implement the .net database security (role, user) with aspnet_regsql into a new database and it works
but i have several error when i tried to implement all the .net security feature into an existing database

here is the error in aspnet_regsql :


SQL Exception:
System.Data.SqlClient.SqlException: Cannot resolve collation conflict for equal to operation.
Cannot resolve collation conflict for equal to operation.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at System.Web.Management.SqlServices.ExecuteFile(String file, String server, String database, String dbFileName, SqlConnection connection, Boolean sessionState, Boolean isInstall, SessionStateType sessionStatetype)

please help, it's urgent :(
LVL 2
Dnx_7Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

daniel_ballaCommented:
what is your database's collation?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dnx_7Author Commented:
database's collation???
what is that?
how can i check that?

regards
daniel_ballaCommented:
that it is:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_6ttf.asp
easiest way to check it: in enterprise manager, database properties.
how to specify the default collation for an sql server instance: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_0f3n.asp
However, if you installed all by default options, you shouldn't have this problem.
Did you try setting up a new database on the same SQL server instance and installing the membership in that database?
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

Dnx_7Author Commented:
d*** the collation is different!

what are the risk to change the collation?

regards
Dnx_7Author Commented:
hi create a new database on the server where i have an error
i set the collation on French_CL_AS (the same collation on the working database)

i always have that error :
Setup failed.

Exception:
An error occurred during the execution of the SQL file 'InstallRoles.sql'. The SQL error number is 446 and the SqlException message is: Cannot resolve collation conflict for equal to operation.
Cannot resolve collation conflict for equal to operation.


i don't where to look now... regards
daniel_ballaCommented:
the error is probably due to a join between 2 tables with different collation. This is either because the created membership tables have the default database collation and they are joined with some system databases (master maybe) or because (and more likely) the tables are created by aspnet_regsql with a different collation than the other tables in your database which have the default database collation. In this case, I don't think you can make aspnet_regsql create a different collation, but you might change the tables manually.
Dnx_7Author Commented:
ok i manager the database collation for installing the membership database and it works fine now

thank you veryyyyy much!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.