1493:
33:
193:
application instead of requiring direct access to the file system which the Jet database resided on. Microsoft Access, the company's most popular database tool at the time, was expanded for its Office 2000 release to incorporate using
Microsoft Desktop Engine as its back-end data store. This design
375:
194:
was promoted by
Microsoft as a solution for small workgroups that may eventually grow to require the full SQL Server product. This initial release of MSDE also included the Data Transformation Services Wizard, which provided the ability to use
177:
MSDE was initially designed by (then) Microsoft
Program Manager Jeff Alger and later implemented by Peter Byrne (core), Ronald Martinsen (core/setup), and Mike Maringas (setup). Alger and Martinsen are the co-inventors who hold the patent.
247:
MSDE could be distributed with commercial products by registering with
Microsoft — in most cases this distribution is also free of charge. SQL Server's server licence includes right to distribute MSDE.
156:
7.0 or 2000 which is free for non-commercial use as well as certain limited commercial use. It was introduced at
Microsoft TechEd in May 1999, and was included as part of
518:
629:
496:
576:
279:
181:
The initial release of MSDE is called the "Microsoft
Desktop Engine", which is based on SQL Server 7.0 and was positioned as an alternative to using the
597:
507:
319:
1515:
541:
530:
485:
622:
1525:
1282:
254:
MSDE 2000 is also found in various products, such as
Microsoft Office XP (Professional, Developer), Visual Studio .NET 2002-2003.
1029:
202:
data sources to transfer data between SQL Server 7.0 and MSDE. Supported operating systems at the time of its release included
21:
463:
1024:
145:
1520:
1496:
676:
615:
754:
270:
workloads are running. Microsoft has also stated that MSDE is not supported in
Windows NT 6.0 operating systems such as
116:
1318:
1173:
925:
97:
1313:
1188:
666:
580:
69:
930:
910:
681:
54:
1308:
878:
866:
764:
262:
Compared with the full server editions of SQL Server 7.0 and 2000, MSDE has some restrictions: a limit of 2
76:
1277:
1221:
898:
283:
251:
MSDE 2000 includes following resource kits: MSDE 2000 Deployment
Resource Kit, MSDE 2000 Web Resource Kit.
1369:
1303:
1193:
1178:
945:
1226:
1081:
370:
83:
1407:
1349:
1216:
1183:
935:
722:
1233:
994:
702:
414:
275:
1475:
653:
552:
65:
43:
1458:
1344:
989:
883:
856:
811:
300:
1374:
1402:
1059:
1019:
843:
796:
776:
602:
519:
END-USER LICENSE AGREEMENT SERVER LICENSE FOR MICROSOFT SQL SERVER PRODUCTS (SQL Server 2000)
474:
357:
50:
373:, Ronald R. Martinsen, Jeffrey Alger, "Dynamic SKU management", issued 2002-8-27
1259:
1238:
1129:
1086:
267:
153:
225:
Microsoft Data Engine can be found in
Microsoft Access 2000 and other Microsoft products.
8:
781:
769:
182:
563:
389:
1272:
1267:
1211:
999:
791:
717:
661:
344:
295:
161:
440:"PRB: MSDE unattended installation needs full path name of the .iss file (MSKB238232)"
1463:
1168:
1144:
1091:
861:
759:
190:
1339:
1156:
732:
186:
157:
266:
databases, and has a workload governor which reduces its speed when eight or more
90:
1480:
1074:
848:
786:
697:
1443:
1009:
955:
211:
607:
244:
It is based on SQL Server 2000. System requirement was changed to Windows 98.
164:
was released in November 2005. Vendor support of MSDE ended on April 8, 2008.
1509:
1334:
1203:
1139:
1064:
940:
671:
320:"Microsoft Announces Availability of MSDE For Developers Using Visual Studio"
271:
1433:
1124:
1119:
950:
801:
439:
1134:
1054:
903:
228:
MSDE toolkit for Visual Studio 6.0 can be found in October 2000 MSDN DVD
1004:
979:
967:
962:
737:
207:
203:
1438:
1417:
1163:
893:
236:(English Pack, European Pack I, Japanese Pack, Latin American pack).
219:
149:
32:
1392:
984:
888:
871:
712:
263:
17:
464:
Product Information -> Pricing & Licensing (SQL Server 7.0)
1397:
1151:
1114:
1069:
1014:
972:
821:
816:
727:
1412:
749:
742:
278:
management tools were released for MSDE, but SQL Server 2000's
195:
1453:
1448:
1096:
920:
806:
707:
1106:
915:
199:
1468:
215:
230:
Office Test Platform and Development Tools, English Pack
232:
as MSDE for Visual Studio., or in October 2000 MSDN CD
508:
Microsoft SQL Server 2000 Enterprise Edition datasheet
419:
Microsoft Office 2000/Visual Basic Programmer's Guide
394:
Microsoft Office 2000/Visual Basic Programmer's Guide
239:
57:. Unsourced material may be challenged and removed.
1507:
475:Table of Contents for October 2000 Monthly (DVD)
637:
486:Table of Contents for August 2000 Monthly (CD)
623:
189:with a focus on its ability to operate as a
214:Service Pack 4, and was available for both
172:
630:
616:
234:Office Test Platform and Development Tools
542:Microsoft Products that include MSDE 2000
117:Learn how and when to remove this message
1283:Business Intelligence Development Studio
1516:Proprietary database management systems
160:2000 Developer Edition. Its successor,
1508:
351:
22:Maryland State Department of Education
20:'s state department of education, see
611:
557:
553:The SQL Server 2000 Workload Governor
146:relational database management system
55:adding citations to reliable sources
26:
497:SQL Server 2000 System Requirements
282:(as well as later versions such as
13:
14:
1537:
590:
521:1.c. Use of Redistributable Code.
301:SQL Server Express § LocalDB
152:. It is a scaled-down version of
1492:
1491:
286:) can be used to connect to it.
240:Microsoft SQL Server Data Engine
130:Microsoft SQL Server Data Engine
31:
1526:Discontinued Microsoft software
1375:Team Foundation Version Control
569:
546:
535:
524:
512:
501:
490:
479:
42:needs additional citations for
468:
457:
432:
407:
382:
363:
337:
312:
1:
390:"Using Microsoft Data Engine"
345:"MS SQL Server 2005 Released"
306:
284:SQL Server Management Studio
7:
1521:Microsoft server technology
638:Microsoft development tools
531:Resource Kits for MSDE 2000
289:
257:
167:
10:
1542:
603:SQL Server Express Edition
15:
1489:
1426:
1383:
1362:
1350:Extensible Storage Engine
1327:
1296:
1258:
1251:
1202:
1105:
1047:
1038:
836:
755:Robotics Developer Studio
690:
652:
643:
369:
1174:Communication Foundation
276:graphical user interface
173:Microsoft Desktop Engine
142:Microsoft Desktop Engine
1476:Windows Package Manager
1189:Presentation Foundation
577:"SQL Server & MSDE"
1459:Web Platform Installer
1345:Access Database Engine
812:Native Image Generator
677:Tools for Applications
564:MS SQL Server on Vista
371:US patent 6442559
138:Microsoft Data Engine
1087:Xbox Development Kit
672:Team System Profiler
154:Microsoft SQL Server
51:improve this article
1194:Workflow Foundation
1179:Identity Foundation
765:SharePoint Designer
183:Jet Database Engine
792:Windows App Studio
415:"When to Use MSDE"
347:. databasedir.com.
324:news.microsoft.com
296:SQL Server Compact
280:Enterprise Manager
162:SQL Server Express
1503:
1502:
1464:Windows Installer
1370:Visual SourceSafe
1358:
1357:
1278:Management Studio
1247:
1246:
1092:Windows Installer
832:
831:
127:
126:
119:
101:
1533:
1495:
1494:
1340:Microsoft Access
1256:
1255:
1157:Entity Framework
1045:
1044:
682:Tools for Office
650:
649:
632:
625:
618:
609:
608:
596:Microsoft page:
585:
584:
579:. Archived from
573:
567:
561:
555:
550:
544:
539:
533:
528:
522:
516:
510:
505:
499:
494:
488:
483:
477:
472:
466:
461:
455:
454:
452:
451:
436:
430:
429:
427:
426:
411:
405:
404:
402:
401:
386:
380:
379:
378:
374:
367:
361:
355:
349:
348:
341:
335:
334:
332:
331:
316:
187:Microsoft Access
158:Microsoft Office
122:
115:
111:
108:
102:
100:
59:
35:
27:
1541:
1540:
1536:
1535:
1534:
1532:
1531:
1530:
1506:
1505:
1504:
1499:
1485:
1481:Microsoft Store
1422:
1408:Script Debugger
1385:
1379:
1354:
1323:
1292:
1243:
1198:
1101:
1075:Managed DirectX
1040:
1034:
828:
787:Windows App SDK
723:Macro Assembler
686:
645:
639:
636:
593:
588:
575:
574:
570:
562:
558:
551:
547:
540:
536:
529:
525:
517:
513:
506:
502:
495:
491:
484:
480:
473:
469:
462:
458:
449:
447:
438:
437:
433:
424:
422:
413:
412:
408:
399:
397:
388:
387:
383:
376:
368:
364:
356:
352:
343:
342:
338:
329:
327:
318:
317:
313:
309:
292:
260:
242:
222:architectures.
175:
170:
123:
112:
106:
103:
60:
58:
48:
36:
25:
12:
11:
5:
1539:
1529:
1528:
1523:
1518:
1501:
1500:
1490:
1487:
1486:
1484:
1483:
1478:
1473:
1472:
1471:
1461:
1456:
1451:
1446:
1441:
1436:
1430:
1428:
1424:
1423:
1421:
1420:
1415:
1410:
1405:
1400:
1395:
1389:
1387:
1381:
1380:
1378:
1377:
1372:
1366:
1364:
1363:Source control
1360:
1359:
1356:
1355:
1353:
1352:
1347:
1342:
1337:
1331:
1329:
1325:
1324:
1322:
1321:
1316:
1311:
1306:
1300:
1298:
1294:
1293:
1291:
1290:
1285:
1280:
1275:
1270:
1264:
1262:
1253:
1249:
1248:
1245:
1244:
1242:
1241:
1236:
1231:
1230:
1229:
1224:
1214:
1208:
1206:
1204:Device drivers
1200:
1199:
1197:
1196:
1191:
1186:
1181:
1176:
1171:
1166:
1161:
1160:
1159:
1149:
1148:
1147:
1142:
1137:
1132:
1127:
1122:
1111:
1109:
1103:
1102:
1100:
1099:
1094:
1089:
1084:
1079:
1078:
1077:
1067:
1062:
1057:
1051:
1049:
1042:
1036:
1035:
1033:
1032:
1027:
1022:
1017:
1012:
1010:Project Verona
1007:
1002:
997:
992:
987:
982:
977:
976:
975:
970:
960:
959:
958:
953:
943:
938:
933:
928:
923:
918:
913:
908:
907:
906:
901:
896:
891:
881:
876:
875:
874:
869:
864:
859:
851:
846:
840:
838:
834:
833:
830:
829:
827:
826:
825:
824:
819:
814:
809:
804:
794:
789:
784:
779:
774:
773:
772:
762:
757:
752:
747:
746:
745:
735:
730:
725:
720:
715:
710:
705:
703:Expression Web
700:
694:
692:
688:
687:
685:
684:
679:
674:
669:
664:
658:
656:
647:
641:
640:
635:
634:
627:
620:
612:
606:
605:
600:
592:
591:External links
589:
587:
586:
583:on 2010-07-24.
568:
556:
545:
534:
523:
511:
500:
489:
478:
467:
456:
444:Knowledge Base
431:
406:
381:
362:
350:
336:
310:
308:
305:
304:
303:
298:
291:
288:
259:
256:
241:
238:
212:Windows NT 4.0
174:
171:
169:
166:
125:
124:
39:
37:
30:
9:
6:
4:
3:
2:
1538:
1527:
1524:
1522:
1519:
1517:
1514:
1513:
1511:
1498:
1488:
1482:
1479:
1477:
1474:
1470:
1467:
1466:
1465:
1462:
1460:
1457:
1455:
1452:
1450:
1447:
1445:
1442:
1440:
1437:
1435:
1432:
1431:
1429:
1425:
1419:
1416:
1414:
1411:
1409:
1406:
1404:
1401:
1399:
1396:
1394:
1391:
1390:
1388:
1382:
1376:
1373:
1371:
1368:
1367:
1365:
1361:
1351:
1348:
1346:
1343:
1341:
1338:
1336:
1335:Visual FoxPro
1333:
1332:
1330:
1326:
1320:
1317:
1315:
1312:
1310:
1307:
1305:
1302:
1301:
1299:
1295:
1289:
1286:
1284:
1281:
1279:
1276:
1274:
1271:
1269:
1266:
1265:
1263:
1261:
1257:
1254:
1250:
1240:
1237:
1235:
1232:
1228:
1225:
1223:
1220:
1219:
1218:
1215:
1213:
1210:
1209:
1207:
1205:
1201:
1195:
1192:
1190:
1187:
1185:
1182:
1180:
1177:
1175:
1172:
1170:
1167:
1165:
1162:
1158:
1155:
1154:
1153:
1150:
1146:
1143:
1141:
1138:
1136:
1133:
1131:
1128:
1126:
1123:
1121:
1118:
1117:
1116:
1113:
1112:
1110:
1108:
1104:
1098:
1095:
1093:
1090:
1088:
1085:
1083:
1080:
1076:
1073:
1072:
1071:
1068:
1066:
1063:
1061:
1058:
1056:
1053:
1052:
1050:
1046:
1043:
1037:
1031:
1028:
1026:
1023:
1021:
1018:
1016:
1013:
1011:
1008:
1006:
1003:
1001:
998:
996:
993:
991:
988:
986:
983:
981:
978:
974:
971:
969:
966:
965:
964:
961:
957:
954:
952:
949:
948:
947:
944:
942:
941:Visual FoxPro
939:
937:
934:
932:
929:
927:
924:
922:
919:
917:
914:
912:
909:
905:
902:
900:
897:
895:
892:
890:
887:
886:
885:
882:
880:
877:
873:
870:
868:
865:
863:
860:
858:
855:
854:
853:Visual Basic
852:
850:
847:
845:
842:
841:
839:
835:
823:
820:
818:
815:
813:
810:
808:
805:
803:
800:
799:
798:
795:
793:
790:
788:
785:
783:
780:
778:
775:
771:
768:
767:
766:
763:
761:
758:
756:
753:
751:
748:
744:
741:
740:
739:
736:
734:
731:
729:
726:
724:
721:
719:
716:
714:
711:
709:
706:
704:
701:
699:
696:
695:
693:
689:
683:
680:
678:
675:
673:
670:
668:
665:
663:
660:
659:
657:
655:
654:Visual Studio
651:
648:
642:
633:
628:
626:
621:
619:
614:
613:
610:
604:
601:
599:
595:
594:
582:
578:
572:
565:
560:
554:
549:
543:
538:
532:
527:
520:
515:
509:
504:
498:
493:
487:
482:
476:
471:
465:
460:
445:
441:
435:
420:
416:
410:
395:
391:
385:
372:
366:
359:
354:
346:
340:
326:. 24 May 1999
325:
321:
315:
311:
302:
299:
297:
294:
293:
287:
285:
281:
277:
273:
272:Windows Vista
269:
265:
255:
252:
249:
245:
237:
235:
231:
226:
223:
221:
217:
213:
209:
205:
201:
197:
192:
191:client–server
188:
184:
179:
165:
163:
159:
155:
151:
148:developed by
147:
143:
139:
135:
131:
121:
118:
110:
99:
96:
92:
89:
85:
82:
78:
75:
71:
68: –
67:
63:
62:Find sources:
56:
52:
46:
45:
40:This article
38:
34:
29:
28:
23:
19:
1434:Active Setup
1319:Notification
1297:SQL services
1287:
1130:Dynamic Data
802:CLR Profiler
646:environments
581:the original
571:
559:
548:
537:
526:
514:
503:
492:
481:
470:
459:
448:. Retrieved
443:
434:
423:. Retrieved
418:
409:
398:. Retrieved
393:
384:
365:
358:MSDE Upgrade
353:
339:
328:. Retrieved
323:
314:
261:
253:
250:
246:
243:
233:
229:
227:
224:
180:
176:
141:
137:
133:
129:
128:
113:
104:
94:
87:
80:
73:
61:
49:Please help
44:verification
41:
1384:Testing and
1314:Integration
1234:Windows HLK
1060:Silverlight
1055:Windows API
1020:Small Basic
899:Managed C++
844:Dynamics AX
797:Windows SDK
777:Small Basic
644:Development
446:. Microsoft
421:. Microsoft
396:. Microsoft
1510:Categories
1403:Playwright
1260:SQL Server
1041:frameworks
1005:PowerShell
980:IronPython
968:TypeScript
963:JavaScript
884:Visual C++
738:QuickBASIC
450:2008-11-19
425:2008-11-29
400:2008-11-29
330:2022-04-16
307:References
268:concurrent
208:Windows 98
204:Windows 95
107:March 2009
77:newspapers
1439:ClickOnce
1418:xUnit.net
1386:debugging
1309:Reporting
1169:CardSpace
1145:Web Forms
926:Dexterity
904:C++/WinRT
837:Languages
782:WebMatrix
770:FrontPage
598:MSDE 2000
150:Microsoft
1497:Category
1427:Delivery
1393:CodeView
1304:Analysis
1252:Database
1039:APIs and
1000:Power Fx
985:IronRuby
872:VBScript
718:MACRO-80
713:GW-BASIC
290:See also
258:Features
185:used by
168:Overview
18:Maryland
1398:OneFuzz
1273:Compact
1268:Express
1152:ADO.NET
1115:ASP.NET
1070:DirectX
973:JScript
894:C++/CLI
822:XAMLPad
817:WinDiff
728:MSBuild
667:Express
144:) is a
136:, also
91:scholar
1413:WinDbg
1048:Native
889:C++/CX
879:Bosque
862:VB.NET
857:legacy
760:Roslyn
750:QuickC
743:QBasic
733:Pascal
691:Others
377:
210:, and
196:OLE DB
93:
86:
79:
72:
66:"MSDE"
64:
1454:vcpkg
1449:NuGet
1328:Other
1140:Razor
1097:WinUI
921:Dafny
849:BASIC
807:ILAsm
708:FxCop
698:Blend
274:. No
220:Alpha
98:JSTOR
84:books
1288:MSDE
1227:UMDF
1222:KMDF
1184:LINQ
1164:MAUI
1125:AJAX
1120:Core
1107:.NET
1030:XAML
990:Lean
946:Java
916:C/AL
662:Code
218:and
200:ODBC
198:and
134:MSDE
70:news
16:For
1469:WiX
1444:npm
1239:WDM
1217:WDF
1212:WDK
1135:MVC
1082:UWP
1065:XNA
1025:VPL
951:J++
867:VBA
216:x86
140:or
53:by
1512::
1015:Q#
956:J#
936:F*
931:F#
911:C#
442:.
417:.
392:.
322:.
264:GB
206:,
995:P
631:e
624:t
617:v
566:.
453:.
428:.
403:.
360:.
333:.
132:(
120:)
114:(
109:)
105:(
95:·
88:·
81:·
74:·
47:.
24:.
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.