GP 9.0 on SQL 2000

Someone told me that I would have to upgrade to SR 4 for SQL 2000 in 
order for the GP 9 upgrade to work.. Is this correct?
0
Brianm1 (20)
7/12/2006 3:47:11 PM
greatplains 29623 articles. 6 followers. Follow

2 Replies
495 Views

Similar Articles

[PageSpeed] 45

That configuration is what is recommended. I have not tried to install GP 9 
on SQL Server 2000 sp3 or before because sp4 has been out so long. Is there a 
reason you have not installed sp4, yet? 
-- 
Charles Allen, MVP



"Brian" wrote:

> Someone told me that I would have to upgrade to SR 4 for SQL 2000 in 
> order for the GP 9 upgrade to work.. Is this correct?
> 
0
callen (2505)
7/13/2006 1:53:02 AM
The database requirements for GP 9.0 state SQL 2000 SP4.  I have installed 
GP 9.0 on SQL server 2000 SP 3 successfully, but I think this may not be 
supported by Microsoft, so I would not recommending doing this in a 
production environment.

-- 
Victoria Yudin
Dynamics GP MVP


"Brian" <Brianm@mtewood.com> wrote in message 
news:Ol4iFpcpGHA.4208@TK2MSFTNGP04.phx.gbl...
> Someone told me that I would have to upgrade to SR 4 for SQL 2000 in order 
> for the GP 9 upgrade to work.. Is this correct? 


0
victoria (3340)
7/13/2006 9:03:18 PM
Reply:

Similar Artilces:

Security Service Dependancy on SQL Named Instance
Hi I know that after MSCRM installation you should re-register the MSCRM Security Service using a '-s' command so it has a dependancy on SQL to prevent it failing on boot up. My problem is that I have a customer who has a named instance of SQL and using this command does not put it as a dependancy in the MSCRM Security Service. Does anyone know the command that I should be using in this situation?? Thanks Peter I think the switch you mention may be correct, but insufficient; to get the MCCRMSecurityService starting, try re-registering it precisely as follows: On your crm serv...

Problem installing client on machine with SQL Server installed
We have many client machines with sql server installed. When trying to install the client from the CRM 1.2 Client CD, it fails because of MSDE and instance problems. Why is this, and what is the typical workaround? We must have SQL Server installed. Why cant microsoft CRM recognize that SQL Server is allready installed and just use that ? Hello, I am running Windows XP Professional, Outlook 2003, CRM 1.2 for Outlook, and SQL Server 2000 Development edition on my workstation. The workstation is not a member of the domain. However the username and password for the sql account and the ...

T-SQL script to update A/P account value of Vendor Card
Hello: For some reason, I just noticed that a question that I posed over an hour ago still has not posted to the newsgroups. So, I'm going to try to repost, here. I am trying to develop a simple T-SQL script in Fabrikam where I update the A/P account of the vendor card with a different account number from what is presently there. When I try each of the scripts below, SQL returns 0 results. Why? UPDATE PM00200 SET PM00200.PMAPINDX = GL00100.ACTINDX from PM00200 as PM00200 join GL00100 as GL00100 on PM00200.PMAPINDX = GL00100.ACTINDX WHERE PMAPINDX IN( select ACT...

Help creating a script in SQL or Calculated field in Crystal
How do I take this script and manipulate it to give me one long string with static text as well as SQL data in specific positions within the string. Example result: Positions / Data: 1-3 / 173 (Static text) 4-6 / spaces 7-10 / "X_UPR30300"."YEAR1", (has to show up as 2007. Showing up as 2,007) 11 / 4 (Static text) 12-22 / "UPR00100"."SOCSCNUM" 23-57 / "UPR00100"."LASTNAME" 58-92 / "UPR00100"."FRSTNAME" 93 / "UPR00100"."MIDLNAME" 94-120 / "UPR00102"."ADDRESS1" 121-148 / &q...

9.0 Table Changes
Will be updating to V9, am looking for a list of the tables that changed and the documentation says it is on V9 cd 2, under the SDK But I don't see anything on the CD so do I have to install v9, and the SDK before I can get a list of the table names? -- Doug You need to install the SDK "Doug" wrote: > Will be updating to V9, am looking for a list of the tables that changed and > the documentation says it is on V9 cd 2, under the SDK > > But I don't see anything on the CD so do I have to install v9, and the SDK > before I can get a list of the tabl...

Getting rid of #DIV/0! #2
Does anybody know a quick way of getting rid of the error message #DIV/0!. Like a way to change it into just 0 or something? Thanks Erin Here are some typical ways.... For values in A1 and B1 Different ways depending on your anticipated values.... C1: =IF(B1<>0,A1/B1,0) OR C1: =IF(N(B1)<>0,A1/B1,0) OR C1: =IF(ISERROR(A1/B1),0,A1/B1) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "erin" wrote: > Does anybody know a quick way of getting rid of the error message > #DIV/0!. Like a way to change it into just 0 or something? Than...

CRM 4.0 DESKTOP client for Outlook don't load all options (?)
Today I found some problem in CRM Desktop Outlook client...when I try to create e-mail quick campaign I did't find option "e-mail via mail merge" and the same option for list. In CRM menu (in Outlook) under Otions I didn't found "synchronization" tab. After restart Outlook for few hours all was ok, but after I observed the same situation, restart and all is ok... Is some solution of this problem... ...

MS CRM 3.0 Customer Case Problem
Dear CRM Experts, I have a problem with MS CRM 3.0: I want to create a web based form in our company website that customers create their Cases (tickets) by it and we (I and my Tech. staff) response to them (Ticketing system). It seems for security reasons we shouldn’t allow CRM browsing outside of our Internal Network (Intranet). Please help me how can present solution for this problem. Best Regards, Mohsen Ahmadi You have a couple of options. There are third-party apps that will let you integrate CRM with your website, but with 3.0 you would probably need to purchase the External C...

How to stop tracking a Contact in CRM 4.0
How do I stop tracking an Outlook Contact that has been set to "Track in CRM" Hi Ken, The "Track in CRM" for contacts turns to "View in CRM" when a matching contact record is created in the CRM database. If you no longer want that contact in CRM then you can delete it, then it will say "Track in CRM" again. "Ken Florian" wrote: > How do I stop tracking an Outlook Contact that has been set to "Track in CRM" ...

List of Differences Between Outlook 2000 and Outlook 2003
I need to spend 45 minutes introducing Outlook 2003 to my Outlook 2000 users. Can anyone provide a site with a succinct list (screenshots would help) of differences between Outlook 2000 and Outlook 2003? Many thanks. Tom Are you looking for screenshots of Outlook 2003 or ones comparing OL2000 and 2003? Wouldn't you be a more convincing teacher if used both and took the screenshots yourself? This would help you learn and understand the products better. (Vmware or virtual pc make this really easy and you could show them the differences live. :)) -- Diane Poremsky [MVP - Outlook] ...

Error while import BCM Database into CRM 3.0
I am trying to import BCM Database into CRM 3.0 When I run " Data Migration for Microsoft Outlook Business Contact Manager" wizard I get an unexpected error. Can someone help ? thanks Here is the Log: 8/21/2007 5:15:38 PM------>Transitioning to next screen. From: Welcome screen. To: PreconditionCheck screen. 8/21/2007 5:15:38 PM------>Connecting to Microsoft CRM Shamir_Systems_MSCRM 8/21/2007 5:15:39 PM------>Checking that Microsoft CRM Data Migration Pack is installed: Success 8/21/2007 5:15:39 PM------>Establishing connection to CDF database: Success 8/21/2007 5:1...

Stem-and-leaf display\Excel 2000
Create a stem-and-leaf display using Excel 2000, using either character or numeric data. Any help or information is appreciated. Thank you. This Google search yields 46,500 results http://www.google.ca/search?hl=en&safe=off&as_qdr=all&q=excel+chart+stem+leaf&btnG=Search -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "fjm" <fjm@discussions.microsoft.com> wrote in message news:336E0EC1-A433-4112-A268-A30BFA44CFC6@microsoft.com... > Create a stem-and-leaf display using Excel 2000, using either character or > numeric data. Any...

Outlook vs. webaccess crm 4.0
Hi 1) Could someone specify the pros and cons (especially the difference in the "functionality" options) for the end users - if they use the Outlook client or if they use a Webbrowser? 2) What are most common ? thanks for any feedback... It's true you can do everything on the web version or the Outlook version. The biggest feature of CRM is the fact you can everything inside of Outlook and not have to go a different application. Outlook: 1 - Easier concept for end users (especially Sales folk) to grasp. "you don't need to learn a new application - it's ju...

View the source of a message (Outlook 2000)
Hi to all! Since some months I search for a possibility to view the entire source of a message in Outlook 2000 SP-3 (background: by some means or other there is sometimes a message slipping through my filters - and then I DO NOT want to see it in Outlook's state-of-the-art multimedia viewer). In case you have questions: Yes, I know that I can view the header of the message by right-clicking on it in the overview and selecting "Options". Yes, I know that I can view the source of just the body by right-clicking on it in the message view and selecting "View source". B...

Excel 2000 running on Windows XP SP2 does not properly open CSV fi
The same file opened in using Excel 2000 running in Windows 2000 Pro open properly. The rows and columns are formatted properly. The same Excel 2000 opening the same CSV file but on Windows XP SP2 will not properly format the rows and columns. Hi check your regionals ettings in Windows ('Start - Control Panel') I'd suspect you have different column delimiters specified (comas versus semicolons for example) -- Regards Frank Kabel Frankfurt, Germany "Oscar" <Oscar@discussions.microsoft.com> schrieb im Newsbeitrag news:4985F8F5-5D33-425E-989C-65529CE63D05@mic...

Excel 2000 Unicode
Hi I am traing to run database query from Excel 2000 against database SQL Anywhere. Everything is fine but tre return data is not in Unicode(Greek). On some other databases the conversion works fine - they are convertet to Unicode in greek. Any ideia how this conversion work in Excel 2000 and why is working only in selected databases? It is probably the ODBC driver - check sybase's web site or call their support people to see if you need a different one. On Wed, 14 Jan 2004 13:14:53 +0200, "Greg" <gcholakidis@hotmail.com> wrote: >Hi I am traing to run database query...

SQL select statement question
My dataset has 3 columns: customer id, store location, charges I'd like to write a single select statment that will show each customer id once, with the store location where they have the most charges, and the sum of the charges for that store location. This gives the max charges for each customer, but doesn't give the location: select a.custID, max(new.amt) from smallchg a inner join; (select custID, location, sum(charges) as amt from smallchg group by custID, location) as new ; on a.custID= new.CustID group by a.CustID thanks. joel Try this -- SELECT TOP 1 ...

Database using Access 2.0
Our church purchased Church Windows software. When we asked if we could import our members from our existing database Greentree CDMS they said we couldn't because CW is an Access 2.0 database and we don't have that software. What would be the benefit of still using Access 2.0 for software development? Thanks, Linda Hi Linda I doubt there are many new programs being written in Access 2. It was a great piece of software, and many databases were writing using it. I don't know Church Windows, but I am guessing that it was written back in the Access 2 days (around 1994), ...

CRM 1.2
I am going to move the CRM SQL databases to a new server. We will also be moving Great Plains off the CRM server and on to the new SQL server. We are bouncing around the idea of naming the new SQL server to the name that the current CRM server uses and renaming the current CRM server. The thinking here is that we won't have to touch the Great Plains clients. What kinds of issues can I expect in this scenario? I believe that CRM "might" make us of the SID in which case I would need to use SysPrep to create the new one? I wouldn't think that this is that unusal of a proje...

Looking for GP specialist
We are looking for a GP specialist, expert in Greatplains, Business Portal, SharePoint, MS SQL server database development. This opportunity will be located in Ottawa, Ontario. Please email your resume to: bnemaniAThotmail.com (replace AT with @) ...

customizations import from 3.0 to 4.0
Is is possible to import customizations into a 4.0 system that were exported from a 3.0 install? You will need to upgrade 3.0 implementation to 4.0 by running MS CRM 4.0 setup. Please go through Microsoft Dynamics CRM 4.0 Installing Guide. You can download this guide from folowing URL http://www.microsoft.com/downloads/details.aspx?FamilyId=1CEB5E01-DE9F-48C0-8CE2-51633EBF4714&displaylang=en I don't think that there is any supported way through which you can import 3.0 Customization file to 4.0 implementation. Cheers, Rohit "Leo_B" wrote: > Is is possible to im...

CRM 3.0 Mobile for Cingular 8525 (HTC Hermes)
I was just looking at the minimum requirements for CRM 3.0 Mobile and I see only the Texas Instruments and Intel processors listed. The 8525 uses a Samsung 400MHz processor. Is there a plan in place to test and release on this platform? The Intel processors usually mean Xscale processors or ARM processors. The Samsung chip is almost certainly a repacked ARM processor so should work. ============================== John O'Donnell Microsoft CRM MVP http://www.crowecrm.com "captbackfire" <captbackfire@discussions.microsoft.com> wrote in message news:A818737C-44F3-4...

outlook 2000 #13
I am helping someone set up multiple email accounts in Outlook 2000. When I am sending mail ... how do i specify which account the mail is being sent from ? Do I have to change the default account in some way ? No matter what I do the mail appears to have been sent from his local ISP account. in newer versions there is an account button next to send, and in outlook express I have a pull down From field to select. Any help would be great, Thanks, Jesse What mode have you configured Outlook 2000 in? If you're not sure, open Help | About Microsoft Outlook and look at the second line -...

Crystal Reports 9.2.3 and CRM
Hi, I'd like to know if CRM does work fine with the Crystal Reports Pro Version 9.2.3. I know the recommanded version is 9.2.2 but was just wondering if somebody successfully worked with 9.2.3/CRM Thanks Eric I have used a version line 9.2.4 so I would assume yes it will work. Only way to be sure is to try it. -- John O'Donnell Microsoft CRM MVP http://www.mscrmfaq.us "Eric" <NOSPAMerich742001@yahoo.fr> wrote in message news:%23GB4wV9SFHA.1040@TK2MSFTNGP10.phx.gbl... > Hi, > > I'd like to know if CRM does work fine with the Crystal Reports Pro Ve...

Slow acces CRM 3.0
Hi, We have a problem, our CRM goes slow. There are 10 active users using CRM with web browse, and sometimes Outlook client. Our server is a Compaq Proliant with 2 processor Xeon and 2 Gb of RAM. We installed CRM SBS, exchange, sql server in the same server. We accomplish all recommended requierements says by Microsoft but when I go to open an account it's delay about 10 seconds. Why?? thanks in advance I have recently come accross a client that forgot to turn of the tracing in CRM, and this was causing a lot of delays, and the type of wait time's that you describe. Could it...