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?
 
daniel_ballaCommented:
what is your database's collation?
0
 
Dnx_7Author Commented:
database's collation???
what is that?
how can i check that?

regards
0
 
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?
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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

what are the risk to change the collation?

regards
0
 
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
0
 
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.
0
 
Dnx_7Author Commented:
ok i manager the database collation for installing the membership database and it works fine now

thank you veryyyyy much!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.