SBS 2003 and Great Plains problem

I have a customer who wants to run Great Plains 9.0 on their SBS 2003 SP1
server. The MS partner that sold them Great Plains doesn't seem to know much
about setting it up on SBS so I am testing it on a test server for the
customer before they install it on their server. They will be using MSDE
with Great Plains as they have SBS 2003 Standard. According to the GP
documentation this is a supported configuration. When I installed the MSDN
version of Great Plains 9.0 on my test server everything installed, I
created a new MSDE instance, Great Plains found it and was happy. The
problem occurred when I tried to backup the server. I couldn't use the SBS
Backup or do manual backups with NTBackup. It failed when trying to create a
shadow copy. The error was:

Error returned while creating the volume shadow copy:0xffffffff.

Searching the Internet and the MS KB gave me quite a few things to try to
fix it but none of them worked. Uninstalling GP 9.0 and the MSDE instance
then rebooting the server fixed it. I'm thinking it is the MSDE instance
causing the problem. This is the command line I used to install MSDE

setup SAPWD=password SECURITYMODE=SQL INSTANCENAME=GreatPlains

This created a new instance called GreatPlains with the correct password. GP
9.0 could connect to it OK.

Have I setup MSDE wrong? Is there something I have to do other than this to
get the backup working with the new instance of MSDE?

--
Kerry
MS-MVP Windows - Shell/User
http://www.vistahelp.ca


.

Relevant Pages

  • Re: Cannot save document. Form Validation Error..Web Server is busy
    ... installed as a MSDE instance in the first place. ... on reconfigure SP to point to the right database server. ... > would be to stop MSDE copy the databases and log files. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: SBS 2003 and Great Plains problem - ALMOST WORKING
    ... The MSDE instance is installed and working. ... Plains 9.0 is installed and working on the server. ... are still recovering from the SBS install six months ago. ...
    (microsoft.public.windows.server.sbs)
  • MSDE connection working with IP address but not instance name
    ... I can't access to my MSDE instance from external clients if I select the ... sql server authentication). ... Both MSDE server and clients are on XP SP2. ...
    (microsoft.public.sqlserver.msde)
  • Re: Problem with regional settings I think
    ... Columnist, SQL Server Professional ... MSDE instance and then we have another "LIVE" server which also has an MSDE ... We are using Crystal Reports to get Reports out of the Databases and the ...
    (microsoft.public.sqlserver.programming)
  • Re: connection failed when using IP address
    ... Execute "srvnetcn.exe" from command prompt from the server running MSDE. ... verify that tcp/ip and named pipes are enabled for the MSDE instance. ... check and open the ports on my router pointing it to my server (1433 & ...
    (microsoft.public.sqlserver.connect)