Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Windows Collation vs. SQL Collation Expand / Collapse
Posted Wednesday, April 16, 2008 4:52 PM


Group: General Forum Members
Last Login: Thursday, February 18, 2016 5:15 AM
Points: 129, Visits: 213
I have 4 servers that have 4 servers that are mirrored backups. DBMS is SQL 2005 and Windows Version is 2003 SP2. The particular application is quite new and is having some issues with accounts that I believe are tied to collation. I have verified that the SQL Collation is the same on all the serves. I didn't set these up--just recently inherited them and have been tasked with straightening out an account issue.

The application requires a case sensitive account for reporting named CPD\PanReports. It was created in AD as CPD\PANReports. It works fine on some servers and won't work at all on others. This is a business critical app. We tried renaming and pulling the account back down and it still works fine on some machines but not others.

Has anyone run into this? I'm exploring 2 theories: (1) Could there be 2 accounts in different AD Containers since these are remote servers? (2) Could this be an issue with the Windows Collation on the servers where this doesn't work? If so how do you validate. I'm not sure how to check the Windows Collation? Is this in the area where the regional settings are? Can it be changed?


Post #486024
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse