Re: Administering MSDE
- From: v-robeli@xxxxxxxxxxxxxxxxxxxx (Robert Li [MSFT])
- Date: Tue, 08 May 2007 06:43:21 GMT
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
<> >
<>
<
.
- References:
- Administering MSDE
- From: Thomas
- Administering MSDE
- Prev by Date: Re: VPN over L2TP/IPsec
- Next by Date: RE: Group Policy update causes short term lockup
- Previous by thread: Administering MSDE
- Next by thread: which wsus version
- Index(es):
Relevant Pages
|