Does SQL Enterprise 7.0 require NT 4 Enterprise OS? I tried to install SQL 7 on NT 4 Server and i get an error stating that Enterprise SQL would not install on NT 4. But when i installed the SQL 7 Desktop it installed fine and when i install Baan IV C4 everything went ok until it gets to te part where its creating tables and the Dr watson comes up. I am wondering if you need a certain OS to install Baan IVc4

Yes, when looking into this we found that the enterprise versions of sql server require the enterprise edition of windows.

SQL Server 7 EE needs NT4 EE
SQL Server 2000 EE needs W2K Advanced Server.

Can BaanIVc4 work with sql 2000 standard?

yes, Baan works with the SQL Server 7 (Standard) or SQL Server 2000 (Standard)

After i install SQL 2000 and then i install baan during the baan installation it asks fhat type of database and the only options are sql 7 , ibm, oracle, and hp. I dont have the option for Sql 2k. So i select sql 7 and when it tries to create the databse i get an error and it cancels the installation. Is there something i should do to get past this? Do i create the database manually?

thanks for helping me

After viewing my event viewer i see this error:

The description for Event ID ( 1000 ) in Source ( Baan ) could not be found. It contains the following insertion string(s): Env (null) ((null))
Prog Msql7Adm.dll file S:\db\servers\MSQL\msqladm.cpp # 4254
Process 0xc4 Thread 0xc3
Lasterror 0
Errno 0
Message Microsoft SQL-DMO (ODBC SQLState: 28000) returned error 18452: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
.

My Server is NT4 Server and SQL 2000 standard. I dont understand this error.

If you wish to do a new install of Baan IVc4 directly onto MS SQL Server 2000 you will need to get an updated Baan IVc4 master CD. This should be available from Baan for free provided you have a support contract.

There is a Baan IVc4 Deployment Guide that explains how to do this, but basically the only difference is that after inserting the Baan IVc4 master CD and reaching the first screen of the installsheild wizard you will need to replace one of the DLLs unpacked into a subdirectory of your temp directory (c:\winnt\tmp\~istmp.01 or similar) with one from the master CD.

I am pretty sure that the DLL is also included in the latest porting set, so if you are in a hurry just "borrow" it from there rather than wait for the new master CD to be delivered.

I found that dll in the lastest porting set and did as you said. everything seemed fine until the spot where it creates the tables i get an error message and when i look in event viewer this is what i get.

The description for Event ID ( 1000 ) in Source ( Baan ) could not be found. It contains the following insertion string(s): Error creating tables. See Event Viewer for details.
Exiting Setup with an error.
.

The description for Event ID ( 1000 ) in Source ( Baan ) could not be found. It contains the following insertion string(s): Env (null) ((null))
Prog Msql7Adm.dll file Y:\db\servers\MSQL\msqladm.cpp # 4338
Process 0xa2 Thread 0xd8
Lasterror 2 (The system cannot find the file specified.)
Errno 0
Message Process "isql" -n -U sa -P -d baandb -i "e:\Baan\extract\schema\(local).baandb.TAB" -o "C:\TEMP\buildtab.log" could not be started.
.