| GM 7.51 and SQL server | |
Posted: Mon Apr 30, 2012 5:41 am |
Points: 0 |
|
stoessner |
GoldMine Journeyman |
|
|
Joined: 25 Feb 2009 |
Posts: 46 |
Location: Ohio |
|
|
|
|
|
|
|
I'm trying to install GM 7.51 on a laptop (remote install) where SQL2008 r2 express is installed and it tells me that I need SQL 2005.
Anyone have any ideas how I can bypass that or any other suggestions....(other than upgrading to PE as that is not an option)
I will also say that I have 3 other machines that are working with the above.
**as a side note, the reason we need 2008 is for the space for our 9GB mailbox.
Thanks! |
|
_________________ Sally Stoessner |
|
|
|
Posted: Mon Apr 30, 2012 6:13 am |
Points: 0 |
|
DJ |
GoldMine Guru |
|
|
Joined: 29 Jun 2006 |
Posts: 2055 |
Location: Fitchburg, MA, USA |
|
|
|
|
|
|
|
Try setting your Database Compatibility back to SQL Server 2005. No guarantees, but that may resolve your issue. |
|
_________________ DJ Hunt
Phone: (978)342-3333
Email: DJ@DJHunt.US
GoldMine Premium - The Defintive Guide
One-on-One GoldMine Technical Support ( Fee Based )
www.DJHunt.US |
|
|
|
Posted: Mon Apr 30, 2012 7:16 am |
Points: 0 |
|
bgannett |
GoldMine Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1820 |
Location: Pacific NorthWest |
|
|
|
|
|
|
|
I agree with DJ. Go into SQL Server Management Studio, highlight that database and go to its properties, and change the compatibility level to SQL 2005. I have been able to do this with GM 6.7 where I had to change the compatibility level to SQL 2000. |
|
|
|
|
Posted: Tue May 01, 2012 4:38 am |
Points: 0 |
|
stoessner |
GoldMine Journeyman |
|
|
Joined: 25 Feb 2009 |
Posts: 46 |
Location: Ohio |
|
|
|
|
|
|
|
When I go into the compatiblily tab....the only options are Windows 95, Windows NT, 2000, etc.
I don't get options for SQL at all. I went to Properties of SQL Mgmt Studio 2008 R2.....Am I looking in the wrong place? Not sure why I get these options. any thoughts? |
|
_________________ Sally Stoessner |
|
|
|
| | |
Posted: Tue May 01, 2012 6:15 am |
Points: 0 |
|
ronanc |
GoldMine Veteran |
|
|
Joined: 10 Sep 2007 |
Posts: 723 |
|
|
|
|
|
|
|
|
Maybe try stick an instance of SQL 2005 express on the machine and then take it off again when you are done? Dont know if that will help (Ive not come across that issue when installing 7.5 onto SQL 2008) but if it is anything like trying to install 6.7 onto anything above SQL 2000 then it should work as all it is checking is that the version it wants to find is actually on the machine. Once it finds it you can select to install to whichever instance you like, as I dont think GoldMine is able to check what version you are actually installing to at that stage. |
|
|
|
|
| | |
Posted: Tue May 01, 2012 6:16 am |
Points: 0 |
|
DJ |
GoldMine Guru |
|
|
Joined: 29 Jun 2006 |
Posts: 2055 |
Location: Fitchburg, MA, USA |
|
|
|
|
|
|
|
Highlight the Database when in the a SQL Management Tools. Right-click and select Properties, I believe. |
|
_________________ DJ Hunt
Phone: (978)342-3333
Email: DJ@DJHunt.US
GoldMine Premium - The Defintive Guide
One-on-One GoldMine Technical Support ( Fee Based )
www.DJHunt.US |
|
|
|
Posted: Tue May 01, 2012 7:03 am |
Points: 0 |
|
ronanc |
GoldMine Veteran |
|
|
Joined: 10 Sep 2007 |
Posts: 723 |
|
|
|
|
|
|
|
|
If its the problem that I am thinking of then it is doing the check on the actual version of SQL installed, and will not get as far as to check database compatibility mode.
Worth a try though. |
|
|
|
|
Posted: Tue May 01, 2012 7:37 am |
Points: 0 |
|
bgannett |
GoldMine Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1820 |
Location: Pacific NorthWest |
|
|
|
|
|
|
|
It appears that he did not check "compatibility mode" in the proper way. As DJ suggested, go to SQL Server Management Studio, highling the database, right mouse button, click on "Properties", then click of "Options". In my SQL 2008, I see 3 options: SQL 2000 (80), 2005 (90), and 2008 (100). |
|
|
|
|
Posted: Fri May 04, 2012 12:45 pm |
Points: 0 |
|
stoessner |
GoldMine Journeyman |
|
|
Joined: 25 Feb 2009 |
Posts: 46 |
Location: Ohio |
|
|
|
|
|
|
|
Thank you all very much!
Changing compatibility did not fix my issue, but I was able to finish my installation by installing SQL 2005 MGMT studio.
couldn't have done it without you!!! You have no idea how much I appreciate your help !!! |
|
_________________ Sally Stoessner |
|
|
|
Posted: Fri May 04, 2012 1:24 pm |
Points: 0 |
|
bgannett |
GoldMine Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1820 |
Location: Pacific NorthWest |
|
|
|
|
|
|
|
Sally - Thanks for the update. Glad we could help. This forum is great and has helped all of us very much. |
|
|
|
|
ContactReview Forum Index » GoldMine 7 (Corporate Edition)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
All times are GMT - 7 Hours
Page 1 of 1
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|