RE: How to configure WSS to use SQL server instead of MSDE

From: shawnk (shawnk_at_discussions.microsoft.com)
Date: 02/03/05 

Date: Thu, 3 Feb 2005 05:57:12 -0800

Paul,

Thank you for directing us to KB823377.

We tryed this solution and it did not work. During the setup dialog when we
get to the 'Installation Selection' page the selection referenced in KB823377
was grayed out. That is to say the 'Upgrade, remove, or add components to an
existing instance of SQL Server' radio button was there - but it was grayed
out.

Is there a decent tool or feature for the MSDE infrastructure that does an
import/export. Oracle, SUN and MYSQL seem to have professional solutions for
import/export (OK ... its a dig but I need to vent).

Microsoft seems to be going with stsadm.exe and other command line utilites
that do not address import/export or any other kind of open architecture
interop. This is why, in this post, I wanted to focus on only WSS features.

Apparently WSS DOES NOT SUPPORT SQL Server since it has no tool (that we
have seen) to export/import/upgrade the database. You have to use SQL Server
tools as another step to get WSS to a scalable solution.

Thanks again for you input and help however as this helps our analysis of
the WSS platform usability.

"Paul" wrote:

> I thought I replied to this, but don't see the post.
>
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;823377
>
> pretty easy, took me about 30 minutes w/ two restarts.
> let me know if you have more questions.
>
> >-----Original Message-----
> >As far as we can tell WSS (Windows SharePoint Services)
> will always create
> >MSDE databases for its configuration and content
> databases.
> >
> >We have used the stsadm.exe and sca.exe utilities but
> they seem to be
> >creating all databases in MSDE format.
> >
> >Is there a simple (HA!) configuration switch or registry
> setting for WSS
> >that can simply switch it over to use SQL Server instead
> of MSDE. BTW we did
> >the 'install without MSDE' command line install process
> (serveral times) and
> >had no luck in getting WSS off of MSDE.
> >
> >We need to review Biztalk server but are being held up by
> issues our clients
> >IT group has with MS access and MS MSDE databases.
> >
> >Any help is greatly, sincerly and professionally
> appreciated :-) :-) :-)
> >.
> >
>

Loading