Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nishi57
Starting Member
20 Posts |
 Posted - 2008-02-27 : 09:46:18
|
| Here is my problem. I am setting up a new server with Great Plains v8.0 (I have migrated all the databases from the other server, which has a working version of Great Plains v8.0 at the present moment). We are planning on getting rid of that server as it causing a lot of problems at the moment. I start the install of Great Plains v8.0 on the new server, install the components. After Great Plains v8.0 installs I go into Great Plains Utilities, and get the following message (I have installed SQL Server 2005 on the new server, and SQL Server 2000 is being used on the old server). After I run Great Plains Utilities, I get the following error message - "The stored procedure verifyServerVersion() of form duSQLinstall: 111Pass Through SQL returned the following results: DBMS: 0, Great Plains: 0."and when I click OK, it gives me another notification message - "Your current SQL SERVER is not a support versionReq: Microsoft SQL Server 7.0Act: Microsoft Server 2005You need to upgrade to SQL Server 7.0 before continuing".Why am I get that error message when I have SQL Server 2005 installed?Can someone point me in the right direction.Thanks |
|
|
tprupsis
Yak Posting Veteran
88 Posts |
Posted - 2008-02-27 : 10:28:26
|
| The error message states that SQL 2005 is not supported. I believe GP 8.0 was released in 2004 so this is not terribly surprising. Can you install SQL 2000 on your new box? |
 |
|
|
nishi57
Starting Member
20 Posts |
Posted - 2008-02-27 : 10:53:46
|
| The main goal here is to install Great Plains v9.0 (If possible I do not want to install SQL Server 2000). |
|
|
|
tprupsis
Yak Posting Veteran
88 Posts |
Posted - 2008-02-27 : 11:51:37
|
| I'd recommend finding a GP support forum (or contacting MS support) to find out how to do the upgrade/migration. If you really don't want to install SQL 2000 on the new box, I would think the approach would be to upgrade GP to 9.0, then upgrade to SQL 2005, then migrate to the new server. But if you need to get off the old box quickly, then you could install SQL 2000, migrate to the new server, and then work through the upgrades. |
|
|
|
nishi57
Starting Member
20 Posts |
Posted - 2008-02-27 : 12:48:48
|
| Thanks for your reply, I will do some more research on this over the next few days and will perform the install accordingly. |
|
|
|
|
|
|
|
|
Installing Great Plains v8.0