Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Infor / Lawson Platforms
S3 Systems Administration
Sql Server 2005 and Lawson 9.0.1.4
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
TomV
Past 24 Hours:
1
Prev. 24 Hours:
2
Overall:
5186
People Online:
Visitors:
230
Members:
0
Total:
230
Online Now:
New Topics
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Infor ION
ION vs IPA
2/29/2024 1:24 AM
We had a person new to Lawson and Infor go to Info
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
S3 Systems Administration
Sql Server 2005 and Lawson 9.0.1.4
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Ward Mitchell
Veteran Member
Posts: 81
4/30/2010 7:07 PM
Hey folks. A newbie to the Lawson world myself, I am working with a company that has implemented Lawson 8.0 on Sql Server 2000 and now want to go to Sql Server 2005 and Lawson 9.0.1.4 and have experienced issues. Read my blog for more on the issue and feel free to respond here or on my blog (which is ligitimate) with any assistance! Thanks much friends!
http://countrypointe.com/...-on-sql-server-2005/
Joe O'Toole
Veteran Member
Posts: 314
4/30/2010 7:20 PM
Was your decision to move to SQL 2005 because of LSF 9.01 requirements? It appears Lawson has removed all traces of SQL 2000 from their supported lists. We're still on 8.03 apps and running LSF 9.004 but looking to upgrade to 9.008 without upgrading SQL which we will do when moving to 9.01. Is anyone out there running 9.008 with SQL 2000?
John Henley
Senior Member
Posts: 3348
4/30/2010 7:30 PM
Ward, see this post for some additional insight:
https://www.lawsonguru.co...ft/6139/Default.aspx
Not having the proper (i.e. Lawson-mandated latin_general_bin) collation is definitely going to cause major pain when migrating to 9.0, particularly for the GEN database.
The tier issues are rooted in Lawson's COBOL legacy past (and apparently will carry forward into Landmark, but that is another story for another day). Without going into detail, suffice it to say that Lawson will always perform best when the database is on the app server.
Ward Mitchell
Veteran Member
Posts: 81
4/30/2010 8:04 PM
[quote]
Posted By John Henley on 04/30/2010 03:30 PM
Ward, see this post for some additional insight:
https://www.lawsonguru.co...ft/6139/Default.aspx
Not having the proper (i.e. Lawson-mandated latin_general_bin) collation is definitely going to cause major pain when migrating to 9.0, particularly for the GEN database.
The tier issues are rooted in Lawson's COBOL legacy past (and apparently will carry forward into Landmark, but that is another story for another day). Without going into detail, suffice it to say that Lawson will always perform best when the database is on the app server.
[/quote]
John, I was starting to wonder about this and glad you pointed me in the right direction. I will let my folks know that this is probably just the way it will be. We finally got here actually in our testing, but we were just going to trial run it. But maybe now we will just make it official and host Lawson and DB together. It's an executve decision at this point ;) Thanks much for the assistance!
John Henley
Senior Member
Posts: 3348
4/30/2010 8:31 PM
There are some things you can do to make it better depending on your load, size, apps, etc. but it will still never be as good. =
Ward Mitchell
Veteran Member
Posts: 81
4/30/2010 8:52 PM
[quote]
Posted By John Henley on 04/30/2010 04:31 PM
There are some things you can do to make it better depending on your load, size, apps, etc. but it will still never be as good. =
[/quote]
Yeah that's what we fought for the last few weeks. But knowing what we know now, we are in better shape and it looks at thought the 1-tier is what we will shoot for. You will probably see me on here more often, so I'll look for you. Thanks for the help John!
John Henley
Senior Member
Posts: 3348
4/30/2010 9:00 PM
Moving topic to sys admin forum...
You are not authorized to post a reply.