Hi, I have a very strange and dangeorous problem, I have MSDE 2000 SP3 installed on several laptops using a database as local, and it replicates as the user request to, using Merge replication. Everything works fine, but sometimes suddenly the MDF and TRN files of the laptops just dissappears....more >>

We are packaging our application installer with MSDE. Is there any specific version of MSDE that we have to use so we don't require admin users to perform the installation? Thanks. ...more >>

How can i install eand run Full text research Service in Windows xp Sp2...more >>

Installed MSDE on windowsxp pro. When computer restarts, icon seen at System Tray. Click on icon and SQL Server Service Manager. Server field blank Services field blank typed in computername for Server field select start/continue button. error message that no service has been sele...more >>

Anybody out there know why i can't install MSDE on a win2000 server. I start setup in dos mode with sapwd ="password" but it dies without error messages. Thanks in advance ...more >>

To anyone who can assist: Everything I have read online today states that I should be able to take a backup copy of my database in MSDE 1.0 and restore it to MSDE 2000. However, I am experiencing problems with this. We are wanting to upgrade our customer sites to MSDE 2000 (from MSDE 1.0)...more >>

I'm using Web Data Administrator to backup/restore some database to move to a new server but when I try and restore on a new server I get the following error? Any ideas? Thanks ...more >>

I'm using MSDE2000sp3 and I can't get the service to start. The error that I get is, 'error 1067 The process terminated unexpectedly'. Can anyone tell me why I get this error. Please help. ...more >>

Hello, I need to create an ODBC DNS that points to a remote MSDE instance, but I can only get it to work if I turn Windows Firewall off. Both the local and remote machines are WinXP SP2 and have SQL2000 and MSDE, same domain and I can login as the same person on each machine. On the rem...more >>

Hi All; MSDE has so many complication to install and to use. So, I am facing one problem right now. It is very frustrating right now. I created one VB.NET application and used MSDE SP3. I am trying to install on Windows 2000 professional. There is a problem setting the SA password. To inst...more >>

Hello. I tried to install MSDE 2000. The installation process could not be finished successfully. After reboot my computer I get the error message: Your SQL Server installation is either corrupt or has been tampered with (unknown package id). It is impossible to re-install the MSDE ans it isn't...more >>

I installed MSDE on a Server 2000 machine as sql authentication. I can login locally using osql -U sa fine but when I try and access using sql manager or visual studio I get cannot connect to server or access denied? I use this on some nt 4.0 machine and 2000 workstation no problem. Any ideas?...more >>

Hi I am looking for MSDE for Win CE. Any clue of how to get that version Thank you, Shmuel Shulman SBS Technologies LTD ...more >>

I get this error when trying to install msde2000a at the end of the installation. After the installation, i install msde with no problem, and Client components of SQL Server 2000, later uninstall the msde instance and client components, but when i try to install again msde, i get this.... ...more >>

We had to rename our domain and thus, had to re-join the new domain after MSDE was installed. I am now unable to connect to MSDE. MSDE is installed on XP 2 on a workstation computer. I'm guessing it has something to do with the accounts the MSDE is running under. Does anyone know how to ge...more >>

MSDE archive downloaded & extracted. to G:\Windows Server Update Services\MSDERelA. setupsapwd="password"instancename="WSUS" run at command prompt for above folder. Program appears to install successfully but MSSQL$WSUS does not appear in the list of services. Install retried, same result. ...more >>

Hello, I work for a company that wants to deploy MSDE with an application and put a lot of data in the database when it is installed. The data is in XML and I tried to insert it line by line, but the performance was not good enough. So I have been experimenting with SQLXMLBULKLOADLib. I ...more >>

Hi, I've installed the MSDE 2000 before and use programming to create database. However, I would like to change the machine name now. Do I need to reinstall the MSDE again before I can connect to the old database? How to change the server name in data connection? -- Regards, SCM Pro...more >>

Hi, I continue to have problems within an application that I wrote in VB.Net with an error "SQL Server does not exist or access denied". I thought it had something to do with the install script installing MSDE 2000 and attaching the databases. So I uninstalled MSDE and manually ran the i...more >>

I know this is going to make me look like a complete 'numpty' but... I just installed this server and the server Manager tools. Installed great and only went that route because I had so many problems trying to get MSDE to install and work. So, anyway, installed fine. The Server Manager starts...more >>

I keep getting setup errors in MSDE. None of the KB articles I've found have helped. Here is the MSDE setup log: === Verbose logging started: 06/25/2005 13:42:38 Build type: SHIP UNICODE 3.01.4000.1823 Calling process: C:\WINDOWS\system32\msiexec.exe === MSI (c) (2C:C8) [13:42:38:263]: Rese...more >>

Hi I am new to MSDE. I see that you can use Access Data Projects to setup MSDE but don't see some of the tools I have seen in SQL Server enterprise manager. (Forgive me if I ask some really elementary questions for a while). I want to set up tables with unique PK's that auto-generate values. ...more >>

A few questions here. 1. I have noticed a problem when MSDE SP3a is installed on a server with SQL Server SP4. The Registry key value SQLPath at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\ClientSetup loses the last character and that makes the path to osql, inval...more >>

I USE VB.NET AND MSDE I WANT TO DO A QUERY LIKE IN MSACCESS SELECT * FROM TABLENAME WHERE FIELD1 LIKE 'TEXT*' THE QUERY DO NOT RETURN RECORDS THANKS IN ADVANCE FLAVIO ...more >>

Hi, all! I encountered that error message while testing my application using MSDE. It appears when I issue this type of statement: INSERT INT atable (Col1, Col2, ...) VALUES (Val1, Val2,...) The string columns are of type 'char'. The strange is that the message does not appear always....more >>

After pulling my hair out for quite some time trying to log in to MSDE with osql, I discovered that I have to reboot Windows after installing MSDE to get it to start up. Is that normal? I'm using MSDE SP4 on WinXP Pro SP2. ...more >>

Hi, If I install MSDE on a live deployed server and manage it using SQL Server 2000 DEVELOPER Edition, which is installed on another machine, would I be breaking the licencing rules? By manage, I mean use Enterprise Manager to perform maintenance tasks etc. Our situation is that we curr...more >>

Hi We distribute an application that includes MSDE. The customer installed our application on their W2K Server.They had Hebrew set as their language in their regional settings (from control panel). However, something didn't work and the msde installation was not successful (unfortunately I do...more >>

The MSDE redistribution agreement is unclear (to me). It talks about redistributing specific parts of MSDE. I just want to put the whole MSDE2000A.exe setup program on a CD with my app's setup program. Is that allowed? Thanks! J....more >>

ok yesterday i crunched my head against the wall, after trying MSDE installation (MSDE rel.A and MSDE SP4) on a brand new WXPPSP2 laptop. Today it worked, in this way: #Prerequisites 1.removed any MSDE installation (control panel > Remove Applications) 2.removed any MSDE directory (eg. "C:\p...more >>

does anyone know the link to get the northwinds db for sqlserver? (i need it for sql2005) thanks kes...more >>

When creating a database using OSQL -E -I CreateDatabase.sql I have the following in my input file: CREATE TABLE admin ( ID char(7), Pwd varchar(32) ) GO How could I make it so that Pwd does not allow nulls and has a default value of 'Password'? ...more >>

I am trying to configure several remote WSUS servers which need access to an SQL database for reporting. I am trying to setup MSDE to run on those machines and I am getting an error "A strong SA password is required for security reasons. Please use SAPWD switch to supply the same" I have...more >>

I am trying to setup a strong password and instance name to use in WSUS. I get to the command prompt, and it begin the installation process, but freezes with 15 seconds remaing...more >>

If I do a windows update, would MSDE get updated along with it or should I download MSDE patches separately? Thanks,...more >>

Hello All I have recently installed MSDE to use with a trial version of Visual Studio .NET 2003 I installed MSDE 2000 release A with the following command: Setup.exe /qb+ INSTANCENAME=3D"NetSDK" DISABLENETWORKPROTOCOLS=3D1 SAPWD=3D"notthisone" I now have to install a database to be used in...more >>

Hello, I have installed MSDE 2000 on Win Server 2003 with instance name brprof, there SQL Server 2000 already installed as a local instance named SBGBHO. Now, I registered my new MSDE 2000 on enterprise manager, registration done successfully, but it display following error LOGIN FAILED FOR...more >>

Hi, I have a data base which hold a record for each contact in exchange the records contain Status column I have been asked to allow the user to do a search on both the status and some other properties of the contact(currently FirstName and LastName) in order to do that I am going to ...more >>

Hi, I'm new user for MSDE 2000 Release A. Recently i have downloading MSDE2000A.exe and extract the MSDE 2000 Release A installation files under folder name MSDERelA. I have read thrg the document but still failed to install a new instance of Desktop Engine for win XP . Command Prompt...more >>

I installed a named instance of MSDE SP4. It seemed to go OK, and no errors were reported. The instance is listed in the computer's services, and it is running. However, neither the computer name nor the new MSDE instance is listed in the SQL Server Service Manager (although an instance on ...more >>

I've read, or attempted to read, the various distribution licenses for MSDE. I'm a doctor, not a mechanic... no wait, I mean I'm a programmer, not a lawyer. Can anyone provide an executive summary of what these licenses say about who can distribute MSDE and where? I'm looking for something ...more >>

I'm testing the installation procedure before installing in the production environment. If I install simply by double-clicking setup.exe, it installs fine, although I had to add sapwd switch to setup.ini. (There are no other settings in setup.ini.) But I want a named instance, so I uninstal...more >>