← Reporting Services issue when installing local Domain Controller

Using a Custom Assembly to search an Analysis Services dimension →

Server and column collation conflicts in properties of a login

Posted on 30/05/2012 by Jens Vestergaard

news and informations automotive,business,crime,health,life,politics,science,technology,travel automotive,business,crime,health,life,politics,science,technology,travel

Problem:

Error: Cannot resolve the collation conflict between “Danish_Norwegian_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the UNION operation. (Microsoft SQL Server, Error: 468) when clicking “Securables” in properties of a server login.

Setup:

Server is set up with collation: SQL_Latin1_General_CP1_CI_AS
The database, or more precisely, the columns are created with collation: Danish_Norwegian_CI_AS
Login is set up with default language: English

The following steps will reproduce the error:

1. See properties for the server-login:

2. Click “User Mapping”

3. Click “Securables”

4. Observe error:

Cannot resolve the collation conflict between “Danish_Norwegian_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the UNION operation. (Microsoft SQL Server, Error: 468)

Solution/Impact:

Can anyone say anything intelligent about this issue?

2 Responses to Server and column collation conflicts in properties of a login

Marlon Ribunal says:

30/05/2012 at 22:20

You have to tell SQL Server what collation to use explicitly (add a COLLATE clause).

You can find the reasons for this particular error in a SQL Server Central post:
http://www.sqlservercentral.com/articles/T-SQL/61288/

Reply
- Jens Vestergaard says:
  
  30/05/2012 at 22:24
  
  Hi,
  Your suggestion is correct, if I was to have the problem in the context of a query.
  In my case, however, there is no way to force the collation, since it’s done behind the scene by Management Studio
  
  Best regards
  /J
  
  Reply

Leave a Reply Cancel reply

Categories
- Coffee (9)
- Family (3)
- Mixed (45)
- Music (5)
- Programming (93)
- Roleplay (6)
- The Who (3)
Archives
- June 2013 (1)
- May 2013 (3)
- April 2013 (3)
- March 2013 (4)
- February 2013 (2)
- December 2012 (1)
- November 2012 (4)
- October 2012 (1)
- August 2012 (1)
- July 2012 (1)
- June 2012 (2)
- May 2012 (7)
- April 2012 (3)
- March 2012 (1)
- February 2012 (1)
- January 2012 (2)
- December 2011 (2)
- November 2011 (1)
- September 2011 (4)
- August 2011 (4)
- June 2011 (2)
- May 2011 (3)
- April 2011 (2)
- March 2011 (4)
- February 2011 (2)
- January 2011 (5)
- October 2010 (2)
- September 2010 (1)
- August 2010 (1)
- May 2010 (2)
- January 2010 (1)
- December 2009 (1)
- October 2009 (2)
- September 2009 (1)
- April 2009 (2)
- January 2009 (1)
- December 2008 (1)
- November 2008 (2)
- August 2008 (1)
- July 2008 (4)
- March 2008 (1)
- February 2008 (1)
- January 2008 (4)
- December 2007 (5)
- November 2007 (5)
- October 2007 (13)
- April 2007 (1)
- March 2007 (1)
- February 2007 (3)
- January 2007 (13)
- December 2006 (7)
- November 2006 (2)
- October 2006 (7)
- September 2006 (5)
- August 2006 (4)
Recent Comments
Tags
.Net 3rd. ed. AMO Analysis Services BI Business Intelligence Bønner C# Certificering Coffee D&D Espresso FAIL Fejl Humor Kværn MCP MDX MSConnect NFL politik Roleplay Security SQL SQL2008 SQL2012 SQLBits SQLBits X SQLPASS SQL Server SQLServer SQL Server 2005 SQL Server 2008 SQLTip SSAS SSIS SSIS 2008 SSMS SSRS T-SQL The Who vandkøling Visual Studio VS2008 VS2010
Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.
Join 1 other subscriber
LinkedIn
If you want to see my LinkedIn profile, click on this button:
Subscription Options:
My Klout Score

< /iframe > </div> </ul> </div> </div> <div id="footer" role="contentinfo"> <div id="colophon"> <div id="site-info"> <a href="http://t-sql.dk/" title="T-SQL.dk" rel="home"> T-SQL.dk </a> </div> <div id="site-generator"> <a href="http://www.paomedia.com/"> Web design by paomedia. </a> </div> </div> </div> </div> <div id="contentalinkfix" style="display:none;"><a href="http://www.facebook.com/sharer.php" rel="nofollow">Share</a><a href="http://www.google.com/buzz/post" rel="nofollow"></a><a href="http://twitter.com/share" rel="nofollow">Tweet</a><a href="http://www.news365live.com" rel="nofollow">news and informations</a><a href="http://news365online.com" rel="nofollow">automotive,business,crime,health,life,politics,science,technology,travel</a><a href="http://worldnews365online.com" rel="nofollow">automotive,business,crime,health,life,politics,science,technology,travel</a></div> <div style="display:none"> <div class="grofile-hash-map-67cd419881bc02623fb62e3c50be47d2"> </div> <div class="grofile-hash-map-2100331a22be6d4ba9bec2a4febf1265"> </div> </div> <script type="text/javascript"> WPCOM_sharing_counts = {"http:\/\/t-sql.dk\/?p=568":568} </script> <script type='text/javascript' src='http://t-sql.dk/wp-content/plugins/jetpack/modules/sharedaddy/sharing.js?ver=20121205'></script> <div id="sharing_email" style="display: none;"> <form action="/?p=568" method="post"> <label for="target_email">Send to Email Address</label> <input type="text" name="target_email" id="target_email" value="" /> <label for="source_name">Your Name</label> <input type="text" name="source_name" id="source_name" value="" /> <label for="source_email">Your Email Address</label> <input type="text" name="source_email" id="source_email" value="" /> <img style="float: right; display: none" class="loading" src="http://t-sql.dk/wp-content/plugins/jetpack/modules/sharedaddy/images/loading.gif" alt="loading" width="16" height="16" /> <input type="submit" value="Send Email" class="sharing_send" /> <a href="#cancel" class="sharing_cancel">Cancel</a> <div class="errors errors-1" style="display: none;"> Post was not sent - check your email addresses! </div> <div class="errors errors-2" style="display: none;"> Email check failed, please try again </div> <div class="errors errors-3" style="display: none;"> Sorry, your blog cannot share posts by email. </div> </form> </div> <script type="text/javascript"> jQuery(document).on( 'ready post-load', function(){ jQuery( 'a.share-twitter' ).on( 'click', function() { window.open( jQuery(this).attr( 'href' ), 'wpcomtwitter', 'menubar=1,resizable=1,width=600,height=350' ); return false; }); }); </script> <script type="text/javascript"> jQuery(document).on( 'ready post-load', function(){ jQuery( 'a.share-linkedin' ).on( 'click', function() { window.open( jQuery(this).attr( 'href' ), 'wpcomlinkedin', 'menubar=1,resizable=1,width=580,height=450' ); return false; }); }); </script> <script type="text/javascript"> jQuery(document).on( 'ready post-load', function(){ jQuery( 'a.share-facebook' ).on( 'click', function() { window.open( jQuery(this).attr( 'href' ), 'wpcomfacebook', 'menubar=1,resizable=1,width=600,height=400' ); return false; }); }); </script> <script type="text/javascript"> jQuery(document).on( 'ready post-load', function(){ jQuery( 'a.share-google-plus-1' ).on( 'click', function() { window.open( jQuery(this).attr( 'href' ), 'wpcomgoogle-plus-1', 'menubar=1,resizable=1,width=600,height=600' ); return false; }); }); </script> <script type="text/javascript"> jQuery(document).on( 'ready post-load', function(){ jQuery( 'a.share-tumblr' ).on( 'click', function() { window.open( jQuery(this).attr( 'href' ), 'wpcomtumblr', 'menubar=1,resizable=1,width=450,height=450' ); return false; }); }); </script> <script type="text/javascript"> jQuery(document).on('ready', function(){ jQuery('body').on('click', 'a.share-pinterest', function(e){ e.preventDefault(); // Load Pinterest Bookmarklet code var s = document.createElement("script"); s.type = "text/javascript"; s.src = window.location.protocol + "//assets.pinterest.com/js/pinmarklet.js?r=" + ( Math.random() * 99999999 ); var x = document.getElementsByTagName("script")[0]; x.parentNode.insertBefore(s, x); // Trigger Stats var s = document.createElement("script"); s.type = "text/javascript"; s.src = this + ( this.toString().indexOf( '?' ) ? '&' : '?' ) + 'js_only=1'; var x = document.getElementsByTagName("script")[0]; x.parentNode.insertBefore(s, x); }); }); </script> <script type='text/javascript' src='http://s0.wp.com/wp-content/js/devicepx-jetpack.js?ver=201325'></script> <script type='text/javascript' src='http://s.gravatar.com/js/gprofiles.js?ver=2013Junaa'></script> <script type='text/javascript'> /* <![CDATA[ */ var WPGroHo = {"my_hash":""}; /* ]]> */ </script> <script type='text/javascript' src='http://t-sql.dk/wp-content/plugins/jetpack/modules/wpgroho.js?ver=3.5.1'></script>  <script type="text/javascript"> var comm_par_el = document.getElementById( 'comment_parent' ), comm_par = (comm_par_el && comm_par_el.value) ? comm_par_el.value : '', frame = document.getElementById( 'jetpack_remote_comment' ), tellFrameNewParent; tellFrameNewParent = function() { if ( comm_par ) { frame.src = "http:\/\/jetpack.wordpress.com\/jetpack-comment\/?blogid=25769179&postid=568&comment_registration=0&require_name_email=1&stc_enabled=1&stb_enabled=1&show_avatars=1&avatar_default=wavatar&greeting=Leave+a+Reply&color_scheme=light&lang=en-US&jetpack_version=2.2.5&sig=12abb74db343f0bec521ab9839f55b1eaab15538#parent=http%3A%2F%2Ft-sql.dk%2F%3Fp%3D568" + '&replytocom=' + parseInt( comm_par, 10 ).toString(); } else { frame.src = "http:\/\/jetpack.wordpress.com\/jetpack-comment\/?blogid=25769179&postid=568&comment_registration=0&require_name_email=1&stc_enabled=1&stb_enabled=1&show_avatars=1&avatar_default=wavatar&greeting=Leave+a+Reply&color_scheme=light&lang=en-US&jetpack_version=2.2.5&sig=12abb74db343f0bec521ab9839f55b1eaab15538#parent=http%3A%2F%2Ft-sql.dk%2F%3Fp%3D568"; } }; if ( 'undefined' !== typeof addComment ) { addComment._Jetpack_moveForm = addComment.moveForm; addComment.moveForm = function( commId, parentId, respondId, postId ) { var returnValue = addComment._Jetpack_moveForm( commId, parentId, respondId, postId ), cancelClick, cancel; if ( false === returnValue ) { cancel = document.getElementById( 'cancel-comment-reply-link' ); cancelClick = cancel.onclick; cancel.onclick = function() { var cancelReturn = cancelClick.call( this ); if ( false !== cancelReturn ) { return cancelReturn; } if ( !comm_par ) { return cancelReturn; } comm_par = 0; tellFrameNewParent(); return cancelReturn; }; } if ( comm_par == parentId ) { return returnValue; } comm_par = parentId; tellFrameNewParent(); return returnValue; }; } if ( window.postMessage ) { if ( document.addEventListener ) { window.addEventListener( 'message', function( event ) { if ( "http:\/\/jetpack.wordpress.com" !== event.origin ) { return; } jQuery( frame ).height( event.data ); } ); } else if ( document.attachEvent ) { window.attachEvent( 'message', function( event ) { if ( "http:\/\/jetpack.wordpress.com" !== event.origin ) { return; } jQuery( frame ).height( event.data ); } ); } } </script> <script src="http://stats.wordpress.com/e-201325.js" type="text/javascript"></script> <script type="text/javascript"> st_go({v:'ext',j:'1:2.2.5',blog:'25769179',post:'568',tz:'2'}); var load_cmc = function(){linktracker_init(25769179,568,2);}; if ( typeof addLoadEvent != 'undefined' ) addLoadEvent(load_cmc); else load_cmc(); </script></body> </html>

Server and column collation conflicts in properties of a login

Problem:

Setup:

Solution/Impact:

Share this:

2 Responses to Server and column collation conflicts in properties of a login

Leave a Reply Cancel reply

Categories

Archives

Recent Comments

Tags

Subscribe to Blog via Email

LinkedIn

Subscription Options:

My Klout Score