Link to home
Start Free TrialLog in
Avatar of jjmartineziii
jjmartineziiiFlag for United States of America

asked on

Test Server Error after restore

After putting sql on a test server installing GP and patching to the way our production installation is, I recevie and error when trying to log in.

Anyone know how to fix this?

The stored procedure verifyVersioninformatin() of form duSQLInstall Pass Through SQL retruned the follwoing results: DBMS:468, Microsfot Dynamics GP: 0.
SOLUTION
Avatar of Jim P.
Jim P.
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jjmartineziii

ASKER

jimpen, how would i go about doing that?

Thanks PenguinMod.
From the server,

Launch the GP utilities and then from there it should check the companies. If it says they are up to date then go for the Synchronize options.

Avatar of hulitk
hulitk

This problem occurs if the collations and the sort orders of the DYNAMICS database and of the company database do not match the collations and the sort orders of the Microsoft SQL Server system databases.

RESOLUTION
To resolve this problem, correct the collations and the sort orders so that they are the same for the DYNAMICS database, for the company database, and for the SQL Server system databases.

Method 2
Change the collations and the sort orders of the DYNAMICS database and of the company database by using the Bulk Copy Process (BCP) feature of SQL Server.

MORE INFORMATION
The SQL Server system databases can be the following databases:
" master  
" model  
" msdb  
" tempdb  
To compare the collations and the sort orders of the databases, follow these steps:1. Run the sp_helpdb command in a query tool. To do this, use one of the following methods.

If you use SQL Server Management Studio.  Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.

b.  In the "Connect to Server" window, follow these steps:

1. In the Server name box, type the name of the server that is running SQL Server.  
2. In the Authentication box, click SQL Authentication.
3. In the Login box, type sa.  
4. In the Password box, type the password for the sa user, and then click Connect.  
 
c.  Click File, point to New, and then click Query with Current Connection.  

d.  In the blank query window, type the following script.

sp_helpdb
 
e.  On the Query menu, click Execute.

2. To view the data, expand the Status column in the results.

3. Compare the values after the following statements:
Collation=
SQLSortOrder=
For example, you may see a statement that resembles the following statement.
Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52
Note The following SQL Server sort orders are supported by Microsoft Dynamics GP: " Binary Sort Order: 0 and 50  
" Dictionary Order Case-Insensitive (DOCI) Sort Order: 52  
 
Ok so this is how it goes. in our production setting, we are using GP 9.00.0293.

Our test seting has version 9.00.0281. When I try to login I get, "A product installed on your computer is on a different version than the database version. You will not be able to use the application until this issue is resolved. Use the GP_LoginErrors.log file in your temp directory to assist in resolving this issue."

I can't find that file.

Once I apply a patch to update GP to version 9.00.0293, I get the error metioned above.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial