[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Error Installing .net database security into an existing one

Posted on 2006-04-24
7
Medium Priority
?
493 Views
Last Modified: 2012-05-05
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 :(
0
Comment
Question by:Dnx_7
  • 4
  • 3
7 Comments
 
LVL 9

Accepted Solution

by:
daniel_balla earned 2000 total points
ID: 16526440
what is your database's collation?
0
 
LVL 2

Author Comment

by:Dnx_7
ID: 16527909
database's collation???
what is that?
how can i check that?

regards
0
 
LVL 9

Expert Comment

by:daniel_balla
ID: 16528973
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 2

Author Comment

by:Dnx_7
ID: 16529526
d*** the collation is different!

what are the risk to change the collation?

regards
0
 
LVL 2

Author Comment

by:Dnx_7
ID: 16529831
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
 
LVL 9

Expert Comment

by:daniel_balla
ID: 16532015
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
 
LVL 2

Author Comment

by:Dnx_7
ID: 16532151
ok i manager the database collation for installing the membership database and it works fine now

thank you veryyyyy much!
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
Today is the age of broadband.  More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses
Course of the Month19 days, 5 hours left to enroll

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question