Re: SBS 2003 and Great Plains problem - NOT SOLVED :(

At this point I would encourage you (for more reasons than solving this
issue) to consider putting Dynamics on another box. I know there is a large
up-front cost associated with doing that but I believe in keeping LOB apps
isolated to avoid exactly the problems you are having (shhhh... don't say
this too loud on an SBS group ;-)).

--
Regards,
Mark Crall
Systems Engineer
Charlotte Tech Care Team / Carolina VoIP
Microsoft Small Business Specialist
Charlotte SBS Group Leader - www.sbs-charlotte.com
Direct: (704) 248-8328 x33

If you think installing patches and security updates is expensive, try not
installing them...
"Kerry Brown" <kerry@xxxxxxxxxxxxxxxxxxx*a*m> wrote in message
news:Ophtmvg2GHA.4228@xxxxxxxxxxxxxxxxxxxxxxx
I spoke too soon. NTBackup worked until I rebooted again. Now it hangs at
the same spot. No errors in the logs. It just hangs and I have to use the
task manager to stop it. It doesn't matter if the new instance of MSDE is
running or stopped. Another oddity with the new instance is the SQLAgent
for it won't start. It did before the reboot. I think something is wrong
with the MSDE instance. I can't use osql to logon with Windows or SQL
authentication. The registry entry for the login mode was 0. Changing it to
1 or 2 makes no difference. I'm going to give up for now and try again
tomorrow. Any suggestions of things to try would be greatly appreciated.

Thanks,

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


Kerry Brown wrote:
I got it working. I don't know what the cause was or what fixed it
but I now have a new instance of MSDE working and the SBS backup also
works. I deleted all the leftover files from the other tries at
installing a new instance. I then stopped the SBSMONITORING and
SHAREPOINT instances as well as SQLAgent. The first time I tried to
install a new instance the install quit with an error. A quick Google
search didn't turn up anything that looked likely. I deleted the
leftover files from this install and tried again with the exact same
setup command. This time it installed with no errors. I set the new
instance service to automatic and rebooted. I started SQLAgent for
the new instance and set it to automatic. Both of these I had done on
previous tries. I then tried NTBackup of the System State. It paused
for a long time at the start where it says "Preparing to backup using
shadowcopy". It stalled there for about fifteen minutes but this time
the disk was being accessed continuously. Previously when it stalled
here there was no disk activity. Then it started copying files and
finished with no errors. I don't know if stopping the other MSDE
instances was the fix but it was the only thing I did different from
the previous tries.

Kerry Brown wrote:
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?




.

Relevant Pages

  • Re: NTBackup Freezing Server
    ... backup some other data. ... I've also been googling for anything related to VSS and general ... I've been backing up all the files from another server, ... I'd also install this patch. ...
    (microsoft.public.windows.server.sbs)
  • Re: hardware requirements for SBS
    ... I want to install SBS in a small office environment and wondered if anyone ... ISA server (havent understood yet the advantages of ISA of windows ... tot up how much disk space you realistically think you will ... What is probably more important than any form of raid is a good backup. ...
    (microsoft.public.windows.server.sbs)
  • Re: sbs backup / volume shadow copy problem
    ... if I do a repair install, SP2, SBSSP1... ... entire server configuration is suspect. ... Backup wizard. ... maybe it was skipping those screens, ...
    (microsoft.public.windows.server.sbs)
  • Re: NTBackup Freezing Server
    ... I wonder if you're having issues with Windows SP2 installed without SBS SP1. ... The server did hang once when I was trying to ... backup some other data. ... I'd also install this patch. ...
    (microsoft.public.windows.server.sbs)
  • Re: Transition Pack question/problem
    ... Do a thorough, complete, VERIFIED backup. ... Disconnect the server from the internet completely. ... (ie, SP1 for SP1 SBS, etc.) ... Server '03 R2 before i can even install this? ...
    (microsoft.public.windows.server.sbs)