A few newbie questions on MSDE / Windows 2003 SBS

Hi!
I've installed a SBS 2K3 server, and everything seem to rock ok. If I not
misunderstood the whole concept, MSDE 2000 is shipped with the server OS, ok?
I've also installed Veritas BE ver. 9.1 Standard for SBS and the antivirus
software Panda Enerprise Secure. Both applications seem to register with SQL
ok, creating instances I can view by right-clicking the services icon to the
left of the system-time display.
But what if I need to create a database manually? I need to install a
dentist-application for my customer, and the installation-procedure doesn't
automatically register with sql. The database has to be moved to the new
server, and registered with sql FIRST.
What to do? Must my Customer by a full version of SQL server? Is it possible
to install SQL Server Standard Edition on a 2003 SBS ?
I would (as usual) be very grateful for any hints and tip's about this issue.
Regards
Tom Hagen
Tom,
I am not sure about registering the database manually with MSDE, as I am
still new to using it, but you can install SQL 2000 on SBS 2003. SBS2003
Premium comes with SQL Server anyway.
John
"Tom" wrote:

> Hi!
> I've installed a SBS 2K3 server, and everything seem to rock ok. If I not
> misunderstood the whole concept, MSDE 2000 is shipped with the server OS, ok?
> I've also installed Veritas BE ver. 9.1 Standard for SBS and the antivirus
> software Panda Enerprise Secure. Both applications seem to register with SQL
> ok, creating instances I can view by right-clicking the services icon to the
> left of the system-time display.
> But what if I need to create a database manually? I need to install a
> dentist-application for my customer, and the installation-procedure doesn't
> automatically register with sql. The database has to be moved to the new
> server, and registered with sql FIRST.
> What to do? Must my Customer by a full version of SQL server? Is it possible
> to install SQL Server Standard Edition on a 2003 SBS ?
> I would (as usual) be very grateful for any hints and tip's about this issue.
> Regards
> Tom Hagen
|||Hi, John!
I've managed to get some info on this issue (by MS themselves, actually).
You have to manually (by command-prompt), create an "instance" in MSDE. You
run MSDE setup with parameters (examples included in a htm-file in
installation folder).
Check out MSDE 2000 release A on:
http://www.microsoft.com/sql/msde/downloads/default.asp
I spoke to a swedish ms-consultant and he told me that installation of SQL
version 2000, 2003 or whatever is not possible on sbs 2k3 . MSDE 2000 is
tested by MS for one (1) default instance and fifteen (15) named instances.
So he and I and some programmers who developed the dental-application are
going
to give it a try.
Thanks, anyway!
Tom
"John Tkalcich" wrote:
[vbcol=seagreen]
> Tom,
> I am not sure about registering the database manually with MSDE, as I am
> still new to using it, but you can install SQL 2000 on SBS 2003. SBS2003
> Premium comes with SQL Server anyway.
> John
> "Tom" wrote: