Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Administration & Installation

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 29th September 2004, 13:17
Jabran Jabran is offline
Member
 
Join Date: Oct 2003
Posts: 31
Jabran is on a distinguished road
Baan: 7.1c.05.148 - DB: SQL Server - OS: Windows NT 4. Server
Red face SQL Server 7.0 SP4 + BaanERP compatiblity

Hello All,

We have BaanERP 5c (SP12) installation on "Windows NT 4.0 Backoffice Server SP6a", with "SQL Server 7.0 (No service Pack installed)". We are to make a complete Baan Database restore trial on "Windows 2000 Advanced Server (SP4, with Terminal Services enabled)".

SQL Server 7.0 installation on "W2k Server with terminal services" requires, "SQL Server 7.0 SP4".

The Live SQL Server has no SQL Server service pack installed. With this configuration, we were able to restore BaanDB user database completely to "SQL Server 7.0 SP4" on "W2k SP4". But structures of SQL Server system databases (master, msdb, etc.) are not same in differnt SQL Server Sercive Packs. Thus these database could not be restored and hence DB user information and access rights information was missing on W2k. (We are using Veritas Backup Exec 8.5 SQL Server Agent to backup and restore the database.)

The above problem may be solved, if we install SQL Server 7.0 "SP4" on Live Server, take a backup, and then restore it to W2k. In this scenario, the "backup source" and "restore target" will have same SP levels of SQL Server, and system dataases will be restoreable as required.

The question Is:
If SP4 of SQL server 7.0 is installed on the Live server, Should there be any concern that it may have any side effects with BaanERP? If yes, then what it may be and are there any workyrounds to avoid those?

One other piece of information is: SQL Server 7.0 doesnot support MSDAC 2.6+ without SP4. Keeping this in mind, can the upgrade to SP4 of SQL Server raise any compatibility issues?

Please provide as many concerns as possible for this scenerio :-).

Thanks in advance.

Sincerely,
Asghar
Reply With Quote
  #2  
Old 4th October 2004, 12:49
Jabran Jabran is offline
Member
 
Join Date: Oct 2003
Posts: 31
Jabran is on a distinguished road
Baan: 7.1c.05.148 - DB: SQL Server - OS: Windows NT 4. Server
Any one there ?



Please share your experiences and thoughts for the above problem.

Thank your for your time and help.

Sincerely
Asghar
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Decision Manager & SQL Server 7.0 BisBoy Open World, Portal & Decision Manager 0 10th July 2003 14:11
BAANERP 5.0c and SQL Server 2000 installation isimeon Tools Administration & Installation 2 5th June 2003 09:18
BaaN C4, Windows 2000 Advanced Server and SQL 7.0 Server rdheeraj Operating Systems & Databases 1 30th May 2003 20:32
Upgrade Baan IV (HP-UX, SQL Server 2000) cfasini Operating Systems & Databases 3 20th May 2003 14:56
Should Baan provide a level 2 database driver for SQL server 2000 on BaanIVc4? patvdv Polls and Surveys 6 28th March 2003 14:22


All times are GMT +2. The time now is 12:22.


©2001-2017 - Baanboard.com - Baanforums.com