Re: Administering MSDE



Hi Thomas,

Thanks for posting in our newsgroup and also for Costas's input.

I fully agree Costas's suggestion. Installing WSUS 3.0 won't affect the
SharePoint database, they are two different instances.

I am sorry that's a pure SQL problem, please open a new post in
microsoft.public.sql newsgroup. Thanks for your understanding.

I'd like to provide you the following information for your reference:

Administering SQL Server 2000 Desktop Engine (MSDE 2000)
http://msdn2.microsoft.com/en-us/library/aa175268(SQL.80).aspx

osql Utility
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp
_osql_1wxl.asp

In addition, you may try the following tool to manage msde from Web:

SQL Server Web Data Administrator
http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en

Deploying Microsoft Windows Server Update Services 3.0
http://technet2.microsoft.com/windowsserver/en/library/3a8c83c3-4eac-4cc3-86
fc-a54e67de9c121033.mspx?mfr=true

WSUS 3.0 on top of SBS 2003 sp1 (not R2)
http://msmvps.com/blogs/bradley/archive/2007/05/01/wsus-3-0-on-top-of-sbs-20
03-sp1-not-r2.aspx

Installing Microsoft Windows Server Update Services 3.0 on Windows Small
Business Server 2003
http://www.microsoft.com/downloads/details.aspx?FamilyId=4F8813EE-DEE5-4B9F-
A127-55042F34BA43&displaylang=en

Hope the information helps.

If you need further assistance, please don't hesitate to let me know.

Best regards,

Robert Li(MSFT)

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security

=====================================================

This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
<Thread-Topic: Administering MSDE
<thread-index: AceRNvOSyuGkbPTLRZKogWucSicbmQ==
<X-WBNR-Posting-Host: 207.46.19.197
<From: =?Utf-8?B?YmFzc19wbGF5ZXI=?= <bassplayer@xxxxxxxxxxxxxxxxxxxxxxxxx>
<References: <1178556521.162683.16380@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
<1BE41630-E0B9-46A2-AC0A-D35CAAE42425@xxxxxxxxxxxxx>
<Subject: Re: Administering MSDE
<Date: Mon, 7 May 2007 23:06:00 -0700
<Lines: 36
<Message-ID: <37BD1F9D-4122-4ACC-867F-15B3D7814B4C@xxxxxxxxxxxxx>
<MIME-Version: 1.0
<Content-Type: text/plain;
< charset="Utf-8"
<Content-Transfer-Encoding: 7bit
<X-Newsreader: Microsoft CDO for Windows 2000
<Content-Class: urn:content-classes:message
<Importance: normal
<Priority: normal
<X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2826
<Newsgroups: microsoft.public.windows.server.sbs
<Path: TK2MSFTNGHUB02.phx.gbl
<Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:35272
<NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
<X-Tomcat-NG: microsoft.public.windows.server.sbs
<
<You can also use osql.exe to administer the MSDE databases on your SBS
<machine from a DBA's point of view although this is not recommended in the
<SBS environment. With WSUS 3.0, you have the option to use the Windows
<Internal Database (the SQL Server 2005 Embedded Edition) which does not
have
<any user interface or tools that you can use to administer it. You can
also
<use SQL Server 2005 Express Edition which is a free download. You can
<administer this using the SQL Server Management Studio Express
<--
<MCP MCDBA MCAD MCSD MCT MCTS MCITP:DBA
<"Helping people grow and develop their full potential as God has plan for
<them"
<
<
<"Costas" wrote:
<
<> Installing WSUS 3.0 won't affect the SharePoint database. Each one
installs
<> its own instance. It's up to you whether you want to install SQL Server
and
<> migrate these databases to the sever. You don't have to though.
<>
<> Costas
<>
<>
<> "Thomas" <CookiesMonster@xxxxxxxxx> wrote in message
<> news:1178556521.162683.16380@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
<> > Hi,
<> >
<> > I know that MSDE is installed on my SBS2003 server. Now i want to add
<> > the WSUS 3.0 database but the sharepoint database is also running on
<> > this machine. Is there a way to administrate those databases or should
<> > i install SQL?
<> >
<> > With kind regards,
<> >
<> > Thomas
<> >
<>
<

.



Relevant Pages

  • Re: cant move sharepoint by the instructions. AGAIN
    ... Monitoring database to another location. ... If you installed the SQL Server or the SQL Server Management Tools, ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: WSS 3.0 Sites DOWN ( again by Microsoft update??)
    ... Please only post one particular question to ONE newsgroup to avoid ... database 'WSS_AdminContent' is full. ... Wanna to manage the DB thru Microsoft SQL server mamagement stuio. ... An error has occurred while establishing a connection to the server. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: ? re. Legal Apps? & ODBC?
    ... based connections (SQL Server & Sybase SQL Anywhere) ... Universal Data Access & Virtual Database Technology Providers ... > All responses should be made to this newsgroup within the same thread. ... >> MVP Entourage ...
    (microsoft.public.mac.office.entourage)
  • RE: Sharepoint issue
    ... do you mean Microsoft SQL Server ... 833183 You receive a "Cannot connect to the configuration database" error ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Database for C#
    ... If I needed absolute top performance without installing something like MSDE ... too slow when accessing file based systems while, with SQL Server, ADO, etc. ... that, at the time, I built upon to create a complete database system. ...
    (microsoft.public.dotnet.languages.csharp)