RE: MSDE, Access, SharePoint... I am not sure where to ask this qu

Hi SailFL,

Thank you for your kind update.

1. >> What is the difference between MSDE and WMSDE?

Microsoft Desktop Engine (Windows) (WMSDE), WMSDE is a special edition of
MSDE that is targeted for use by Windows components only. It is installed
by default in a single server installation of Windows SharePoint Services.?

- The MSI of WMSDE that SharePoint installs is Sqlrun16.msi with the
instancename of SharePoint.
- A single server installation will have two databases created: a
configuration database, STS_CONFIG, and a content database,
STS_servername_instance.
- WMSDE is configured for Windows Authentication only.
- The 2 GB database size and performance throttles on total number of
concurrent connections are removed.

2. >> So in reality, isn't SQL Server Express replacing MSDE and WMSDE?
So I can use Access to have database files on a SharePoint site. Will that
Access also than be able to connect to SQL express and can it do it now?

As for SQL problem, I would like to suggest that post a new thread to SQL
newsgroup. The reason why I recommend this is that you will get the most
qualified pool of respondents, and other partners who the newsgroups
regularly can share their knowledge. Please also understand that our SQL
team are specialists and they will help you get this issue to be resolved
in an accurate and timely manner. Thank you for your understanding.

For your convenience, I have listed the Internet Explorer newsgroup below:
Microsoft.public.sqlserver.msde

Have a nice day!

Best regards,

Nathan Liu (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: MSDE, Access, SharePoint... I am not sure where to ask this
qu
>thread-index: AcX/4BmR0pCbM/7bQWyH4VZ9hfO3UQ==
>X-WBNR-Posting-Host: 71.52.219.10
>From: =?Utf-8?B?U2FpbEZM?= <SailFL@xxxxxxxxxxxxxxxxxxxxxxxxx>
>References: <92708308-690C-4F4F-8057-2AF073017A18@xxxxxxxxxxxxx>
<#3bUVP6$FHA.832@xxxxxxxxxxxxxxxxxxxxx>
>Subject: RE: MSDE, Access, SharePoint... I am not sure where to ask this qu
>Date: Tue, 13 Dec 2005 04:24:01 -0800
>Lines: 135
>Message-ID: <14B71D03-04E9-45DF-894B-01D0AA6DEA17@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.0
>Newsgroups: microsoft.public.windows.server.sbs
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.windows.server.sbs:229795
>X-Tomcat-NG: microsoft.public.windows.server.sbs
>
>Nathan,
>
>I appreciate your response but I am a bit confussed.
>
>What is the difference between MSDE and WMSDE?
>
>I has been announced that MSDE is being replaced by SQL Server 2005
Express
>and MSDE will not longer be supported after 2007.
>
>Also I found a document that talks about Migrating from WMSDE to SQL
Server
>but in reality what you are using with SharePoint is SQL Server 2000
Desktop
>Engine.
>
>It is my understanding with the release of SQL Server 2005, Small Business
>Server 2003 currently uses SQL Server 2000 but in the next releases
Premium
>will use SQL Server 2005 and standard will use SQL Server Express.
>
>So in reality, isn't SQL Server Express replacing MSDE and WMSDE?
>
>So I can use Access to have database files on a share pointe site. Will
>that Access also than be able to connect to SQL express and can it do it
now?
>
>You can see I am confussed. There are some many products it is hard to
keep
>up and to be able to tell a client which to use.
>
>Thanks
>
>
>--
>SailFL
>
>
>""Nathan Liu [MSFT]"" wrote:
>
>> Hello SailFL,
>>
>> Thank you for posting in the SBS newsgroup.
>>
>> >> 1) While we be able to access these databases using SharePoint? >> 2)
>> What does access use? Is it compatable to MSDE - SQL Server Express?
>>
>> Please kindly note the SharePoint is using WMSDE instance on SBS 2003
>> Standard Server, it is using SQL instance on SBS 2003 Premium SP1 Server
if
>> we upgrade it to SQL Server 2000.
>>
>> We can upload an Access database (.MDB) into WSS (SharePoint). It is
>> possible to directly upload the file into WSS document library by
removing
>> the file type block. The steps are as below:
>>
>> a. Go to Adminsitrative Tools->SharePoint Central Administration.
>> b. Under "Security Configuration", click "Manage blocked file types"
>> c. Remove "mdb" from the file extension list.
>> d. Click OK.
>>
>>
>> I appreciate your time and cooperation. If anything is unclear, please
feel
>> free to let me know. I am looking forward to hearing from you.
>>
>> Best regards,
>>
>> Nathan Liu (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: MSDE, Access, SharePoint... I am not sure where to ask
this
>> questi
>> >thread-index: AcX/OgIUVzgubT+RSGywg6TaqcZXDA==
>> >X-WBNR-Posting-Host: 71.52.219.10
>> >From: =?Utf-8?B?U2FpbEZM?= <SailFL@xxxxxxxxxxxxxxxxxxxxxxxxx>
>> >Subject: MSDE, Access, SharePoint... I am not sure where to ask this
questi
>> >Date: Mon, 12 Dec 2005 08:35:05 -0800
>> >Lines: 15
>> >Message-ID: <92708308-690C-4F4F-8057-2AF073017A18@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.0
>> >Newsgroups: microsoft.public.windows.server.sbs
>> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>> >Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>> >Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.windows.server.sbs:229557
>> >X-Tomcat-NG: microsoft.public.windows.server.sbs
>> >
>> >As I mentioned, I am not sure where to ask this question because I
don't
>> >completely understand the relationship.
>> >
>> >We are developing a number of databases in Access. We don't see the
need
>> to
>> >move to SQL Server 2005. We are moving to SBS soon. I understand that
>> MSDE
>> >is being replaced by SQL 2005 Express.
>> >
>> >1) While we be able to access these databases using SharePoint?
>> >2) What does access use? Is it compatable to MSDE - SQL Server Express?
>> >
>> >Point me in the right direction, Pleases.
>> >Thanks
>> >
>> >--
>> >SailFL
>> >
>>
>>
>

.

Relevant Pages

  • Re: Database Connectivity
    ... But, MSDE has been know to work very reliably in small user LANS, ... > just a simple step to attach the tables from MSDE to SQL Server. ... database, or pay for an "industrial-strength" version of it when there ... Don't like Microsoft?, sounds like a personal problem to me. ...
    (comp.lang.python)
  • Re: Help with cost and additional software
    ... WMSDE is MSDE 2.0 with most of the restrictions removed (2GB size limit; ... Would SQL Server 2005 Express work for that? ... You still need to pay licenses for the Operating System. ... You can use the built-in WMSDE for the database for nothing. ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: MSDE, Access, SharePoint... I am not sure where to ask this qu
    ... I has been announced that MSDE is being replaced by SQL Server 2005 Express ... Also I found a document that talks about Migrating from WMSDE to SQL Server ... > Thank you for posting in the SBS newsgroup. ...
    (microsoft.public.windows.server.sbs)
  • Re: about MSDE
    ... > We need to have a clarification and a full technical explanation about the ... > A Year ago Microsoft had announced and released MSDE, ... > difference if we use MSDE or the complete SQL server package from a client ...
    (microsoft.public.sqlserver.clients)
  • Re: Can not start tcp port 1433 on MSDE
    ... You might also need to check to see if it is truly MSDE or is it WMSDE.. ... If it isn't, move it over, hit apply, and restart> SQL Server. ...
    (microsoft.public.sqlserver.msde)