tag:blogger.com,1999:blog-7958569345934714789.post457488888764133314..comments2016-09-16T11:17:41.265-04:00Comments on Jeff Stevenson's Technology Blog: EnterpriseOne 9.0 SQL Server Collation Issuesjxs2151http://www.blogger.com/profile/13599578258965424531noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-7958569345934714789.post-30909742360546516382012-04-15T04:05:38.249-04:002012-04-15T04:05:38.249-04:00HI:
When i installed JD Edwards EnterpriseOne 9.0...HI: <br />When i installed JD Edwards EnterpriseOne 9.0 (32) Enterprise Server in windows server 2008 R2 64x EE, I don't find any things in the data base (SQL Server 2008 R2 64x). Did I load manually the database if yes HOW?Anonymoushttps://www.blogger.com/profile/01802421827441996024noreply@blogger.comtag:blogger.com,1999:blog-7958569345934714789.post-9344342599313559162011-09-19T09:48:10.978-04:002011-09-19T09:48:10.978-04:00Great post.
Last time I ran into this issue I quic...Great post.<br />Last time I ran into this issue I quickly exported the users, re-installed SQL Server with an old collation and re-attached the databases and import the users again. This was the fastest way I could find to make sure my master db has the same collation as my JDE databases. This only took me approx an hour.Johan Teekenshttps://www.blogger.com/profile/07634081747028171382noreply@blogger.comtag:blogger.com,1999:blog-7958569345934714789.post-31738910802713474342011-08-31T10:51:45.280-04:002011-08-31T10:51:45.280-04:00In response to a question:
There are two issues i...In response to a question:<br /><br />There are two issues if one does not follow the Oracle suggestion of changing the SQL Server default collation during SQL Server install:<br /><br />1- The collation of the delivered E1 databases being different than the SQL Server system databases (master, tempdb, msdb, model).<br /><br />2- If this is an upgrade, the delivered E1 databases (Central Objects)Jeff Stevensonhttps://www.blogger.com/profile/08951573035924566608noreply@blogger.com